I run nightly exports in our production 9i database. I have several testing databases that are setup just like our production one. I need to refresh one of our test db's from our production db as of last night. I was going to use the export file. I export the entire schema that our application uses. Do I need to trucate all the tables in the test db's schema before I do the import? If I do is there a command to truncate all tables in a schema rather then doing it one table at a time? Can I just run the import and tell it to over-write the data allready there?