how to know the default tablespace?
do have some sql to do?
i have the following tablespace:
how should i known which tablespace is the system default ?
WHERE property_name = 'DEFAULT_PERMANENT_TABLESPACE';
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
what do you mean 'system default' ?
Originally Posted by oldboy
Try hard to get what you like OR you will be forced to like what you get.
IT is the default tablespace when add new user dont specify default tablespace.
you can only have that in 10g by the way
Click Here to Expand Forum to Full Width