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

Thread: sys and system tablespaces

  1. 03-13-2001, 01:01 PM #1
    mary
    mary is offline Member
    Join Date
    Aug 2000
    Posts
    163
    Would you guys check this for me?
    I need to know the names of temporary and default tablespaces for users sys and system.
    I have system using system as default tablespace and sysTEMP as temporary tablespace. On another hand my sys
    is using system tablespace for both.
    Thank you.
    Reply With Quote Reply With Quote
  2. 03-13-2001, 01:36 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I always configure SYS with the default tablespace of SYSTEM and temporary tablespace as TEMP. SYSTEM usually has a default tablespace of TOOLS and temporary tablespace as TEMP.

    The reason I do this is because I have some tools that create tables on the fly as system. I don't want those tables in the system tablespace.
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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