Hi

I have created a test database and would like to do an import form the live
database. The live export was done by system.

Is it nececessary for me to drop all users first and recreate them? or can i
simpy issue the drop database command?

and then use import as follows

imp system/[Email Address Removed] file=live.dmp ignore=y commit=y

and i don't have to specify from and to and all users and tables will be
imported?

many thanks
Sean

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail


Oracle LazyDBA home page