import and export using impdp/expdp in oracle10g/11g

oracle10g oracle11g datapump
orcluser picture orcluser · Jul 15, 2010 · Viewed 11.5k times · Source

I have two databases, one is production and second is a test. I want to export from production database and import into test database. My production db contains many users/schema out of which only few (<10) schemas contain actual objects. First time, i did a successful full export and full import into my test system without any problem.

The idea is to do this on a periodic basis maybe once in couple of weeks. How can i do this process without creating a whole new test database again doing the re-import??

Answer

marvini picture marvini · Jan 10, 2011

In impdp there is the option to import data only using CONTENT=DATA_ONLY http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm
Also have a look at TABLE_EXISTS_ACTION (which already defaults to APPEND if using DATA_ONLY)

Related questions

ORA-28000: the account is locked error getting frequently

I am getting the error : ORA-28000: the account is locked Is this a DB Issue? When I unlock user account using the command ALTER USER username ACCOUNT UNLOCK temporarily it will be OK. Then after some time the same account …

Read More
Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1 varchar2(4000); str2 varchar2(4000); BEGIN str1:=''; str2:='sdd'; IF(str1<>str2) THEN dbms_output.put_line('The two strings is …

Read More
When should I use 'for update nowait' in cursors?

In which case do we need to use for update nowait in cursors.

Read More