Hi
Anybody let me know what are the System Database in Oracle
Thanks
Asim
Printable View
Hi
Anybody let me know what are the System Database in Oracle
Thanks
Asim
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?
or the SYSTEM tablespace?
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.Quote:
Originally Posted by dba1
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.