Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Import to a different tablespace
Hi,
I have two users who have two different default tablespaces. I export some tables from user1 and import using imp newuser/pasword_at_db FROMUSER=olduser TOUSER=newuser.
Both tables end up in the old user's tablespace. I want the imported tables to be in the new tablespace.
I can not use copy or "create table as" because there is LONG data so I am forced to use Export/Import.
Any advice - to be appreciated. Received on Mon Jan 28 2002 - 12:00:33 CST