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

Thread: tablespace

  1. #1
    Join Date
    Jun 2007
    Posts
    29

    tablespace

    pls if i my logged on as user 'SYSTEM' how do i know which tablespace i am using.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    You mean, what would your default tablespace be? In that case you'd want to look at the default_tablespace column in DBA_USERS.

    P.S. Don't create user objects in the SYSTEM tablespace....
    Assistance is Futile...

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