Home » RDBMS Server » Server Utilities » import .dmp file using IMP utility for tablespaces
import .dmp file using IMP utility for tablespaces [message #354304] Fri, 17 October 2008 09:15 Go to next message
Messages: 2
Registered: October 2008
Location: MUMBAI
Junior Member

I am trying to import ".dmp" file using "IMP" utility.

".dmp" files includes two tablespaces e.g. "tblspace1" and "tblspace2".

And I am trying to import two tablespaces into single tablespace e.g. "tblmainspace".

How can define both tablespaces i.e. Source tablespace and Destination tablespace using "IMP" utility for ORACLE 10G.

Satish Gaikwad
Re: import .dmp file using IMP utility for tablespaces [message #354310 is a reply to message #354304] Fri, 17 October 2008 10:20 Go to previous message
Michel Cadot
Messages: 65134
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your problem is not well explained.
An import file does not contains tablespaces, it contains:
- tablespaces definition (if it is a full export)
- objects that were in tablespace

What do you want to do?

Previous Topic: Export/import full database query
Next Topic: SQLLoader Unicode from Unix enviroment
Goto Forum:

Current Time: Wed Aug 16 12:38:41 CDT 2017

Total time taken to generate the page: 0.13985 seconds