Re: Sys and System

marcus.rangel_at_gmail.com wrote:
> 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

For the export any id with the export_full_database privilege will work equally well.

For the import any username with the corresponding import_full_database privilege will work.

HTH -- Mark D Powell -- Received on Sat Jul 15 2006 - 16:57:15 CDT