OraFAQ Forum: Server Utilities » exporting data pump file in oralcle

Home » RDBMS Server » Server Utilities » exporting data pump file in oralcle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exporting data pump file in oralcle [message #318336]

Tue, 06 May 2008 09:12

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

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

Frank Naude
Messages: 4596
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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 17 00:32:33 CDT 2026