Database Administration (MOSC)

MOSC Banner

Comparing objects between two database objects with one select statement

edited May 14, 2015 10:02AM in Database Administration (MOSC) 5 commentsAnswered

Hello,

Need to make comparation  that would

compare ddl definitions of tables between source and target schema ( same number of columns, columns have same names, each columns has same datatype ).

Would be safe for that case to use GET_DDL function which returns DDL definnition into CLOB ?

Is Oracle doing some character cleansing and character strings standardisation when storing DDL definitions so that strings are completely comparable ?

Would make sense to do similar comparation between two schemas on other objects like VIEW definitions, procedure source code?

Thank you for any reference or experience,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center