Import Tables from SYSTEM Tablespace (urgent) [message #72546] |
Tue, 15 July 2003 02:18 |
Deepak Bisht
Messages: 13 Registered: October 2001
|
Junior Member |
|
|
I have exported Tables from Schema old_schema, created in SYSTEM tablespace and now i want to import the same tables into Schema old_schema having tablespace name Old_schema_tbs(new tablespace). for this i tried following commands.
1.I export schema(user) old_schema into data.dmp
2.I drop the schema(user) (drop old_schema cascade)
3.I create tablespace Old_schema_tbs
4.I create schema(user) in tablespace Old_schema_tbs
5.i grant dba,resource,connect to old_schema.
6.i give command alter user old_schema quota 0M on system.
7.i give command alter user old_schema quota unlimited on old_schema_tbs;
8.i export the data.dmp into same schema.
after exporting dump,i found that the tables were in system tablespace. i 'm not able to sort out this problem.Please tell me some solution.
Thanx.
|
|
|
|
Re: Import Tables from SYSTEM Tablespace (urgent) [message #72549 is a reply to message #72546] |
Tue, 15 July 2003 08:13 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
and if you just trying to move the tables from the system tablespace ( the still owned by the same user)
try this
----------------------------------------------------------------------
alte table table_name move tablespace < your_new_tablespace >;
|
|
|