Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Just to be sure: UNLOAD-DROP-LOAD

Just to be sure: UNLOAD-DROP-LOAD

From: Bernd Maierhofer <BerndM_at_dato.at>
Date: Fri, 26 Nov 1999 08:39:43 +0100
Message-ID: <81ldvr$snc$1@newsmaster01.magnet.at>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US