Return
-
Title
Compare database produces different result for sys views of same oracle version -
Description
Compare database produces different result for sys views of same oracle version
-
Cause
Sys views are Inherently different for the databases.
-
Resolution
Check the result of this following query for the two databases from SQL*Plus, or from TOAD.:
SELECT dbms_metadata.get_ddl('VIEW', 'dba_ts_quotas') from dual;Note: for Toad to display CLOB result, ensure that Preview CLOB and LONG data is checked under View | Toad Options | Data Grid | Data | Behaviour menu.If the DDL in these two databases are inherently different, then Toad reports the two results differently. To know why the DDL is inherently different, check with Oracle Support for further advice.