Being new to Oracle and databases I have a question that may be basic to some of you, but I hope you will help me anyway.
We have one database with three tablespaces. The tablespaces are exact copies of each other. Al tables are present in both tablespaces. One tablespace holds our operational data, the other tablespace is for demo/testing.
I periodicaly want to update or replace the data in the demo tables with current data from the operational tables. I used imp / exp to create and fill the tables the first time, but I can't do this again becourse it fails if the tables are not empty. I think deleting all records in the tables by hand and and updating them again is not an option becourse there are 2000 or more tables.
IMHO there must be more people with simular problems. I think most ERP applications work with a operational company and one ore more test companies.