Clear Oracle 9i tables before import.
Posted on 2008-10-22
I have an Oracle 9i database that I need to refesh all the data in the tables of a single schema. I am moving data from my production server to a replacement server, and now that the testing is complete I need to get them in sync. The first import I ran sometime back was no problem because no data existed on this replacement server. Now, when I try to import, it says all the data exist already. When I used IGNORE=Y, I ended up with duplicate data. I would like to clear out all the old data before I run the imp command. This single schema has hundres of tables, so a solution that clears one table at a time will not work.
I have very little experience with Oracle, so please include as much detail as possible.