Re: Moving tables from one tablespace to another

cfischer_at_ancillary.utmrad1.utmb.edu wrote:

>I have been given the task of upgrading/moving an application. The
>tables are currently in Oracle v6 database but they are all in the
>system tablespace. I need to move them to an Oracle7 db on another
>machine and I need to put the tables in an application data tablespace
>and the indexes in an index tablespace. Everything is under one user. I
>know I can export the user but when I import it it wants to put it into
>the system tablespace again. How do I convince it that that is not the
>right thing to do? Do I have to edit the export file and change ALL the
>references?(Yuk)
 

>please post or send replies to cfischer_at_ancillary.utmrad1.utmb.edu
 

>Thanks

Revoke the user's privileges from the SYSTEM tablespace (ALTER USER xxx QUOTA 0 ON SYSTEM). When IMP sees it can't put them back into SYSTEM, it'll try to put them into the user's default tablespace.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!