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 -> Re: Sys and System

Re: Sys and System

From: <marcus.rangel_at_gmail.com>
Date: 15 Jul 2006 14:21:26 -0700
Message-ID: <1152998486.146855.232880@m73g2000cwd.googlegroups.com>

Basically, sys owns the core database objects and system has almost every available privilege. Sys is more powerful. You should use system for full exports and imports.

[]īs

ujangmz_at_gmail.com wrote:
> Hi everyone,
>
> What is the difference between sys and system? And which one is more
> powerful?
>
> If I want to use EXP to create a dump file and then use the dump file
> with IMP to recreate the database in another machine, which id should I
> use to do the EXP?
>
> Regards
> Ujang
Received on Sat Jul 15 2006 - 16:21:26 CDT

Original text of this message

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