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@link where tablespace_name='X'; You will need to run the reverse test too. And can get fancier with dba_tab_columns etc... --Peter
