What is system Database in oracle

[alie4u]

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

Thanks
Asim

[davey23uk]

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?

[marist89]

or the SYSTEM tablespace?

[dba1]

SYS and SYSTEM user, I think.

[gandolf989]

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.

[dhar_kiran]

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.