Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Just to be sure: UNLOAD-DROP-LOAD
I want to reaorganize one O8 DB with the following steps:
UNLOAD with the Data manager using "no increment" DROP USER <xxx> CASCADE - actually I just want to delete all tables, indeices, triggers, and not the user himself. LOAD with the datamanager
With out the DROP USER the existing tables are not overwritten at the load, although I checked the "overwerite existing objects". So the tables were skipped. What I am unsure about, is if the subsequent load depeneds on the user <xxx>, and if I have to create him.
Thank you!
--
dato Denkwerkzeuge - Bernd Maierhofer
Corneliusgasse 4/5
A-1060 Wien , Austria
support_at_dato.at
Received on Fri Nov 26 1999 - 01:39:43 CST