Skip to Main Content
  • Questions
  • export and import table data by using imp & exp utility

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: May 10, 2016 - 1:07 pm UTC

Last updated: May 10, 2016 - 2:53 pm UTC

Version: 11.2.0.3

Viewed 1000+ times

You Asked

Dear Team,

Greetings !

Hope you are doing good.

I need your help i want to export and import table rows(or data) only by using IMP & EXP utility.

Is it possible with imp & exp utility?

I knew that it's possible with datapump utility but i want to use imp & exp utility because i dont have permissions to create directory at os level for datapump.

Your help will be appreciated,thanks in advance.


OS:RHEL 6.1
db:11.2.0.3

and Chris said...

To only import just the rows without DDL, use the data_only parameter of imp:

http://docs.oracle.com/database/121/SUTIL/GUID-051EC293-8325-4D7B-B400-6287CD1EFB6D.htm#SUTIL3677

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, May 11, 2016 - 5:02 am UTC

Hi Team,

Thanks once again for your invaluable support.

Great work you people are doing,keep it up.

Hope i will get the same support in future also.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.