DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Defaults system tablespaces and table names in ORACLE

  1. #1
    Join Date
    Dec 2010
    Posts
    11

    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.

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by jitender singh View Post
    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.

  4. #4
    Join Date
    Dec 2010
    Posts
    11
    Please tell me the name of the system tablespaces?

  5. #5
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by jitender singh View Post
    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.

  7. #7
    Join Date
    Dec 2010
    Posts
    12
    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
  •  


Click Here to Expand Forum to Full Width