Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sys and System
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