-
Defaults system tablespaces and table names in ORACLE
What are the all Defaults system tablespaces and table names in ORACLE?
example: v$parameter, dba_segments, dba_data_files etc.
Last edited by jitender singh; 12-28-2010 at 01:00 AM.
-
what you have found so far???
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by jitender singh
What are the all Defaults system tablespaces and table names in ORACLE?
example: v$parameter, dba_segments, dba_data_files etc.
These are neither tablespace names nor table names.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Please tell me the name of the system tablespaces?
-
system table space in oracle is SYSTEM.
but I am sure that not you are looking for. I am also sure that you are not clear about what you want to know. Do more research and come back with a meaningful question.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by jitender singh
Please tell me the name of the system tablespaces?
Which Oracle version?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Sounds like jitender singh wants everyone to do his research for him.
jitender singh, you might try looking this up for yourself - the same way we learned (some of us more than 15-20 yrs ago)
http://lmgtfy.com/?q=oracle+system+tablespaces
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
|