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: 28
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
BlackSwan
Messages: 26766
Registered: January 2009
Location: 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: 4587
Registered: April 1998
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: 28
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
BlackSwan
Messages: 26766
Registered: January 2009
Location: 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: 1554
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) ] [ RSS ]

Current Time: Tue Dec 24 23:36:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.