query join dba_objects and dba_tables
chijarMay 13 2010 — edited May 13 2010dear all.
i want to get : list of owners, tablespace_name where the table was created, table_name and the date created column of that table_name in tablespaces t1,t2,t3"
i try to do the script with dba_tables and dba_objects but it shows a lot of records. and the object_id exist only in dba_objects but not in dba_tables.
my query was:
select t.owner, o.created, o.object_name,
t.table_name, t.tablespace_name
from dba_tables t
--,dba_objects o
where
--(o.object_type='TABLE' and o.object_name=t.table_name)
--and
t.tablespace_name in ('t1','t2)
/
please could you help me??
thanks