-
What is system Database in oracle
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?
Jeff Hunter
-
SYS and SYSTEM user, I think.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|