rami.info

The About

I'm a geek that loves everything that has to do with computers and recently got into photography. I'm also a unix sysadmin working at an ISP in Kuwait doing what I love the most.

The Links

My Flickr

The Search

The Storage

The Categories

The Hangout

The Meta

Admin
Back to top

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.

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'.

Shehabi said,

on March 18th, 2007 at 12:32 am

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