OraFAQ Forum: Server Utilities » Export and Import

Home » RDBMS Server » Server Utilities » Export and Import

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

Export and Import [message #297619]

Fri, 01 February 2008 14:37

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi guyzz,

can anybody tell me the differnce of using import and export in oracle 10g and 9i.

Regards,
Balaji.C

Report message to a moderator

Re: Export and Import [message #297621 is a reply to message #297619]

Fri, 01 February 2008 14:50

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What didn't you find in the documentation?

Regards
Michel

Report message to a moderator

Re: Export and Import [message #297622 is a reply to message #297619]

Fri, 01 February 2008 14:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Nothing much if we talk about the original export and import utilities. However, Oracle 10g offers Data Pump export and import tools which

Oracle

have vastly improved performance and greatly enhanced functionality, such as restartability, flexible object selection, and better monitoring and control of export and import jobs. Because of these valuable improvements, Oracle recommends that you use these new Data Pump Export and Import clients rather than the original Export (exp) and Import (imp) clients.

Is that what you have in mind?

Report message to a moderator

Re: Export and Import [message #297624 is a reply to message #297622]

Fri, 01 February 2008 14:55

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Given the questions already posted by OP, I think he didn't have anything in mind and is just unable to search and read the documentation.

Regards
Michel

[Updated on: Fri, 01 February 2008 14:56]

Report message to a moderator