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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

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