Hallo... Itu artinya P3_REQUESTTABLE adalah tabel yang berpartisi. Pada table berpartisi, data (segment) disimpan di dalam partisinya. Lebih lanjut saya bahas di sini:
http://rohmad.net/2008/09/14/partitioning-table-segment-tablespace/ Salam, Rohmad --- In [email protected], Andi Afandi <[EMAIL PROTECTED]> wrote: > > 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 >
