0

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??

Bishan
  • 15,211
  • 52
  • 164
  • 258
orcluser
  • 1
  • 1
  • 1
  • 2

1 Answers1

1

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)

Bishan
  • 15,211
  • 52
  • 164
  • 258
marvini
  • 11
  • 1