What is system Database in oracle
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,333
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  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,027
    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.
    this space intentionally left blank

  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