Re: wrong tablespace

Sunil Jayasinghe wrote:

> How can I move some tables and indexes from system tablespace ( where
> they
> should't be) to some other (users) tablespace?
> I tried to export the user, then edit the export file and replace all
> the
> "create table .... tablespace 'SYSTEM' "
> with "tablespace 'USERS' " and then import the user. That works O.K.
> but
> I would like to find out a better way to deal with it.
> Thanx
> sunil.jayasinghe_at_probanka.si

Export all of the tables, etc. from the SYSTEM tablespace that you want to move. Then recreate the objects in USERS and perform an import with the ignore=y option. This will load the data into the newly created objects.

--
====================================================================
Byron Pearce                         mailto:bpearce_at_csac.com
Systems Consultant                   http://www.csac.com
Computer Systems Authority (CSA)     Dallas, Texas

"It's hard to be a ninja when you wear a beeper."