OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » import/export

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

import/export [message #194021]

Wed, 20 September 2006 08:13

vaddiparthi
Messages: 12
Registered: September 2006
Location: bangalore

Junior Member

any one can tell me ,how to do for importing/eporting of database,from one database to another database.if is there any tools plz tell me.I am awaiting for ur reply.

Report message to a moderator

Re: import/export [message #194023 is a reply to message #194021]

Wed, 20 September 2006 08:18

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

The tools is Oracle's own. Use exp for export and imp for import.
You'll have to read up on them as there are way too many options and restrictions to mention here.
Please do a search to get to the documentation.

Report message to a moderator

Re: import/export [message #195444 is a reply to message #194021]

Thu, 28 September 2006 11:53

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi.
if ur on 10g.
then use impdp,expdp instead of original exp,imp utilities
thanx

Report message to a moderator

Previous Topic:	SQLLDR with Date column
Next Topic:	Result of query to xls

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 07:08:20 CDT 2024