Re: Tablespaces comparison

From: Sylvester, Peter A. <>
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...    


-- Received on Wed Apr 02 2008 - 14:49:05 CDT

Original text of this message