difference between sys and system
can any one help me in telling the difference between the sys user and the system user.
thanks in advance
SYS is the data dictionary owner.
SYSTEM is intended for database administration.
In most cases you need SYSTEM to do general administration tasks.
SYS is used when creating a database or when running scripts to install an Oracle options such as PL/SQL support (catproc.sql).
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
SYSTEM user won't be created by default in future releases of Oracle.
Last edited by SANJAY_G; 12-22-2002 at 10:22 PM.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Click Here to Expand Forum to Full Width