rami.info


Importing An ORACLE Schema Into A Different Schema With A Different Tablespace

Posted in DBA,RDBMS,Software,Sysadmin by Rami on the March 18th, 2007

Change the new user’s default tablespace to the new tablespace:
alter user scott default tablespace newspace;
Revoke the unlimited tablespace and change the new user’s quota to have space only on the new tablespace:
revoke unlimited tablespace from scott;
alter user scott quota unlimited on newspace quota 0 on oldspace;
Do the import.

1 Comment

One Response to 'Importing An ORACLE Schema Into A Different Schema With A Different Tablespace'

Subscribe to comments with RSS or TrackBack to 'Importing An ORACLE Schema Into A Different Schema With A Different Tablespace'.

  1. Shehabi said,

    on March 18th, 2007 at 12:32 am

    Greeeeeeeeeeeeeat after huge effort, i need to repost it into my blog ;)

Leave a Reply