Dear all friends,
I investigated Oracle RAC Database in a company and I found this case
SQL> select distinct tablespace_name from dba_tables;
TABLESPACE_NAME
------------------------------
SYSTEM
<-- blank
USERS
PRISMAJMS
PRSMADATA
SYSAUX
Note: There is a blank tablespace in this query.
And then I query
select TABLE_NAME from dba_tables where owner='PRISMA' AND
TABLESPACE_NAME IS NULL;
TABLE_NAME
------------------------------
P3_TXTABLE
P3_REQUESTRESPONSEDATA
P3_REQUESTTABLE
QUEST_SL_TEMP_EXPLAIN1
SQL> select tablespace_name from dba_tables where TABLE_NAME=
2 'P3_REQUESTTABLE';
TABLESPACE_NAME
------------------------------
<-- blank
There are tables that reside in a blank tablespace.
My question:
What is the possibility of this case..?
Thank you guys...
Regards,
Afandi
