Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to find the new tables and columns in a schema

793965Dec 19 2010 — edited Dec 20 2010
hi..good morning to all...

I have a schema ABC which owns some objects.
Now some days before I have made another schema XYZ which was a replica of ABC schema.

between these days some new tables, new columns in the existing tables(with or without default value), comments on the columns are being added in the new schema i.e XYZ schema.

Now I have to find the extra things which are present in the new schema. I need to find the new tables, new columns in hte existing tables, their default values and descriptions of those.

Can u plss help me how can I find it?
I am guessing that I have to write a SQL query with a minus clause but I am not able to write it and also dont know where should I execute it.

plss help. thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2011
Added on Dec 19 2010
15 comments
793 views