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
satish.gaikwad
Messages: 2
Registered: October 2008
Location: MUMBAI
Junior Member
All,

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.

Thanks,
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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?

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


Current Time: Tue Dec 24 10:18:18 CST 2024