Oracle Database Discussions

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