Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exp and Imp Data Without Storage Clause

Mehul MehtaSep 15 2010 — edited Sep 24 2010
Hello,

Can any one help me out, I am trying to export and Import entire database from my friends database, but exporting entire database by default it includes storage clause. I do not need his default storage clause as I have created different tablespace for that data.

But while importing data it takes default storage clause of my friend.

Ex:

My friends database has default table space as USERS, after exporting data using EXP utility from my friends database and Importing entire database using IMP Utility in my database it does not import in my assigned Tablesapce I.e.(*TESTING*), but it imports in my default Tablespace i.e. USERS.

Me and my friend has same default table space as USERS. When I edited exp.dmp file I saw that while exporting entire database. It has included storage i.e. Default Tablesapce as USERS *(_where my friends data is stored_)* and I do not need to import data in my USERS tablespace.

Is there any way where I can EXP or IMP data without Storage Clause. So that I gets imported in my assigned Tablespace.

Thanks

Mehul
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2010
Added on Sep 15 2010
14 comments
3,083 views