How to export & import only data in oracle 11g?

database oracle database-administration
Nitesh Kumar picture Nitesh Kumar · Nov 16, 2012 · Viewed 30.7k times · Source

I want to export only data on of my master tables and then imports it to some other server on same oracle 11g . Is it possible to do that. using exp command it dumps the complete data along with schema which I don`t want . I want only data to be dump and imported to some other location.

Please help me out.

Thanks,

Nitesh Kumar

Answer

Alex Poole picture Alex Poole · Nov 16, 2012

You can't with the original export (exp) utility, but with the newer data pump expdp you can use the content parameter to export only the data:

expdp content=data_only ...

With exp I think the closest equivalent is to set ignore=y on import; it will try to recreate the schema objects but won't complain that they're already there. But since the original utilities are deprecated, you should use data pump anyway.

Related questions

ORA-12528: TNS Listener: all appropriate instances are blocking new connections. Instance "CLRExtProc", status UNKNOWN

I'm getting this error if i try to login as db user. If lsnrctl status is run i get the below error. DB was working fine all these years and stopped working suddenly. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=…

Read More
ORA-01219: database not open: queries allowed on fixed tables/views only

I Am using oracle 11g and SQL developer tool. When i tried to retrieve rows from db i am getting error message as :- ORA-01219: database not open: queries allowed on fixed tables/views only) I looked for sgadef.dbf …

Read More
How to use DBMS_CRYPTO.encrypt function in oracle

I want to encrypt password column in the database and I am trying to use encrypt function present inside DBMS_CRYPTO package (have given execute access from sys account to the current user) but I am getting the following error. …

Read More