Re: recreating databases

med10054_at_leonis.nus.sg (NORHISHAM BIN MAIN) 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

No...... the user "sys" and objects owned by him/her are off limits. Even a "full" export/import bypasses "sys".

Ken F.

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
Q: How many Zen masters does it take to screw in a light bulb?
 
A: None.
   The Universe spines the bulb, and
   the Zen master stays out of the way.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~