difference between sys and system
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: difference between sys and system

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69

    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

    rswamin

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    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).

    Cheers,
    R.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    SYSTEM user won't be created by default in future releases of Oracle.
    Last edited by SANJAY_G; 12-22-2002 at 09:22 PM.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width