hi all,
i have a problem
when i give SQL> SELECT * FROM v$TABLESPACE; it shows all the tablespaces
TS# NAME INC
---------- ------------------------------ ---
3 CWMLITE YES
4 DRSYS YES
5 EXAMPLE YES
6 INDX YES
7 ODM YES
0 SYSTEM YES
8 TOOLS YES
1 UNDOTBS1 YES
9 USERS YES
10 XDB YES
2 TEMP YES
11 rows selected.
but i cant find the details of the tablespace in dba_ts_quotas why is that
SQL> select tablespace_name from dba_ts_quotas;
TABLESPACE_NAME
------------------------------
ODM
ODM
CWMLITE
TOOLS
EXAMPLE
EXAMPLE
EXAMPLE
EXAMPLE
EXAMPLE
EXAMPLE
EXAMPLE