Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » RDBMS Server » Server Utilities » exporting data pump file in oralcle
exporting data pump file in oralcle [message #318336] Tue, 06 May 2008 09:12 Go to next message
suneelvarma_27
Messages: 13
Registered: April 2008
Junior Member
Dear All,
i am having oracle .dmp file with the size of 12 GB. i want to export this to my oracle database (sunil schema)...could you pls tell me the procedure...
thanks in advance
Report message to a moderator
Re: exporting data pump file in oralcle [message #318337 is a reply to message #318336 ] Tue, 06 May 2008 09:14 Go to previous messageGo to next message
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in SoCal
Senior Member
Read The Fine Manual
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
Report message to a moderator
Re: exporting data pump file in oralcle [message #318338 is a reply to message #318336 ] Tue, 06 May 2008 09:15 Go to previous messageGo to next message
Frank Naude
Messages: 3657
Registered: January 2002
Senior Member
Do you mean you want to import (load) the data? If so, use the "impdb" command. For more details, see Datapump.
Report message to a moderator
Re: exporting data pump file in oralcle [message #318457 is a reply to message #318338 ] Tue, 06 May 2008 22:44 Go to previous messageGo to next message
suneelvarma_27
Messages: 13
Registered: April 2008
Junior Member
yaa i want to import .dmp file into oracle database in my schema
Report message to a moderator
Re: exporting data pump file in oralcle [message #318458 is a reply to message #318336 ] Tue, 06 May 2008 22:46 Go to previous messageGo to next message
anacedent
Messages: 5027
Registered: July 2005
Location: surf meets turf in SoCal
Senior Member
>i want to import .dmp file into oracle database in my schema
Please proceed with the import.

imp help=yes
Report message to a moderator
Re: exporting data pump file in oralcle [message #318461 is a reply to message #318336 ] Tue, 06 May 2008 22:53 Go to previous message
Arju
Messages: 1470
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member
Quote:
i am having oracle .dmp file with the size of 12 GB. i want to export this to my oracle database (sunil schema)


You have concept problem. You have dump file and you want to export! Read documentation first.
Report message to a moderator
Previous Topic:ora8i with form 60 on win xp professional
Next Topic:SQL*Loader-282: Unable to locate character set handle for character set ID (871).
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Fri May 16 23:07:37 CDT 2008

Total time taken to generate the page: 0.30467 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.