DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: What is system Database in oracle

  1. #1
    Join Date
    Mar 2006
    Posts
    2

    What is system Database in oracle

    Hi
    Anybody let me know what are the System Database in Oracle

    Thanks
    Asim

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you are getting confused, there is no such thing as a system database in oracle, thre is just 'a database'

    perhaps you mean the system user?

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    or the SYSTEM tablespace?
    Jeff Hunter

  4. #4
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    SYS and SYSTEM user, I think.

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by dba1
    SYS and SYSTEM user, I think.
    Sys owns the data dictionary, i.e. Oracle supplied packages, v$ views dba_ views, all_ views, etc. Sys has all of the privileges that can get granted. System, contains most of the privileges that can be granted. It doesn't own many objects.

  6. #6
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Davey is right.. There is no system database..
    but there is a system tablespace that every oracle database have, which stores dictionary objects and is owned by sys.
    ~KD.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