Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

transfer data from one database to another

475788May 21 2007 — edited May 21 2007
Hello,

We have an application which uses an Oracle 9i server database. On this server we have two databases ( one for test and one for production ).
From time to time it's required to transfer data from production database to test database.
The steps followed by the ones which made the transfer are:
a) drop the user schema ( the one which contains all data)
b) recreate the user
c) import the data ( using import utility )
d) compile invalid object ( what this will mean I don't know)

It's not possible to delete only the content of the tables and then import data from a dump file? In this way the steps c) and d) will no longer be required. If this is possible can you tell me if is there a command which will delete all data from all table ( almost 2000 tables)?

Thank you fro your help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2007
Added on May 21 2007
10 comments
474 views