Re: recreating databases

From: Chuck Isaacson <ccisaac_at_mtu.edu>
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

Original text of this message