Re: recreating databases
Date: 1996/01/03
Message-ID: <4ce044$pf_at_instasrv.admin>#1/1
I would also do a separate grants=y export and a separate rows=n full
export to rebuild all tables without rows. This is in addition
to what you are planning to do.
On the import side, once the db is created and the owners established
you can create all the tables using the rows=n. Once this is done you
can start the grants. The grants can be redone if needed for views, etc.
NORHISHAM BIN MAIN (med10054_at_leonis.nus.sg) wrote:
: Hi,
:
: I need to recreate an existing database. Due to space contraints, I
: need to do it using user exports. I know that I will need to export/import
: all users including SYSTEM. What about SYS .. should I export
: and import tables and views owned by SYS, too ?
:
: I'm using Oracle 6.0.37...
:
: rgds,
: mars
Received on Wed Jan 03 1996 - 00:00:00 CET