Thinking Out Loud

March 3, 2008

DEFAULT_PERMANENT_TABLESPACE

Filed under: oracle,Uncategorized — mdinh @ 2:47 am

Prior to 10g, a created users would have SYSTEM tablespace as default. 

In 10g, the database can have a specified default tablespace for created users.

The information is stored in DATABASE_PROPERTIES view.

SQL> select PROPERTY_VALUE 
  2  from DATABASE_PROPERTIES 
  3  where PROPERTY_NAME='DEFAULT_PERMANENT_TABLESPACE';  

PROPERTY_VALUE 
-------------------------------------------------------------------------------- 
USERS 
Advertisements

2 Comments »

  1. I don’t even understand how I finished up right here, however I thought this post was once great.
    I do not recognise who you might be but certainly you’re going to a well-known blogger should you
    aren’t already. Cheers!

    Comment by Tramadol — October 10, 2013 @ 8:44 pm | Reply

  2. Wonderful goods from you, man. I have understand your stuff previous to
    and you’re just extremely magnificent. I actually like what you’ve acquired here, really like what
    you’re stating and the way in which you say it.
    You make it entertaining and you still take care of to keep it
    smart. I cant wait to read much more from you.
    This is really a wonderful site.

    Comment by vodafone sim only unlimited data — November 9, 2015 @ 1:57 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: