Re: Tablespaces comparison
From: Sylvester, Peter A. <peters_at_mitre.org>
Date: Wed, 2 Apr 2008 15:49:05 -0400
Message-ID: <2BA3384D0B8F9A41A906D1FFC25EB35D0256D953@IMCSRV3.MITRE.ORG>
Date: Wed, 2 Apr 2008 15:49:05 -0400
Message-ID: <2BA3384D0B8F9A41A906D1FFC25EB35D0256D953@IMCSRV3.MITRE.ORG>
Try creating a database link, then can you run queries like this:
select owner, table_name from dba_tables where tablespace_name='X'
minus
select owner, table_name from dba_tables_at_link where
tablespace_name='X';
You will need to run the reverse test too. And can get fancier with dba_tab_columns etc...
--Peter
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 02 2008 - 14:49:05 CDT