how to know the default tablespace?

do have some sql to do?
for example:
i have the following tablespace:
system
temp
users
tools
data
...

how should i known which tablespace is the system default ?

Code:

---

SELECT property_value
FROM database_properties
WHERE property_name = 'DEFAULT_PERMANENT_TABLESPACE';

---

Thanks

what do you mean 'system default' ?

Thanks,

Quote:

---

Originally Posted by oldboy

do have some sql to do?
for example:
i have the following tablespace:
system
temp
users
tools
data
...

how should i known which tablespace is the system default ?

---

IT is the default tablespace when add new user dont specify default tablespace.

you can only have that in 10g by the way