Hi All;
I found table for which I cannot find tablespace in dba_tables, dba_tab_partitions and same (nothing) in dba_segments - below queries:
Query(dba_tables):
SELECT table_name, tablespace_name, temporary
FROM dba_tables
WHERE table_name = 'SOP_HIST';
Results:
Table name, Tablespace name, Temporary
SOP_HIST (null) N
Query(dba_tab_partitions):
SELECT table_name, partition_name, tablespace_name, subpartition_count
FROM dba_tab_partitions
WHERE table_name = 'SOP_HIST';
Results:
table_name, partition_name, tablespace_name, subpartition_count
SOP_HIST MO201208 (null) 0
SOP_HIST MO201209 (null) 0
SOP_HIST MO201210 (null) 0
SOP_HIST MO201211 (null) 0
SOP_HIST MO201212 (null) 0
SOP_HIST MO201301 (null) 0
SOP_HIST MO201302 (null) 0
SOP_HIST MO201303 (null) 0
SOP_HIST MO201304 (null) 0
SOP_HIST MO201305 (null) 0
SOP_HIST MO201306 (null) 0
SOP_HIST MO201307 (null) 0
SOP_HIST MO201308 (null) 0
SOP_HIST MO201309 (null) 0
SOP_HIST MO201310 (null) 0
SOP_HIST MO201311 (null) 0
SOP_HIST MO201312 (null) 0
SOP_HIST MO201401 (null) 0
SOP_HIST MO201402 (null) 0
SOP_HIST MO201403 (null) 0
SOP_HIST MO201404 (null) 0
SOP_HIST MO201405 (null) 0
SOP_HIST MO201406 (null) 0
SOP_HIST MO201407 (null) 0
SOP_HIST MO201408 (null) 0
SOP_HIST MO201409 (null) 0
SOP_HIST MO201410 (null) 0
SOP_HIST MO201411 (null) 0
SOP_HIST MO201412 (null) 0
Query (dba_segments):
SELECT *
FROM dba_segments
WHERE table_name = 'SOP_HIST';
Results:
No rows selected
Thanks for advise.
Regards,
Bolo