Oracle Database Discussions

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!

table structure...

khallas301Feb 20 2013 — edited Feb 21 2013

friends..

oracle 11g

I'm trying to write sql script to get table structure of all tables that a particular user can see from all_tab_columns...

i know we can do desc table_name and get table structure but trying to get output in file so that can compare all tables in different database by linux diff command..

diff file1.txt file2.txt

for a single table it's easy but if user/schema has 50 tables then it gets tricky....
any thoughts / tips??

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 21 2013

Added on Feb 20 2013

#general-database-discussions, #table

11 comments

2,455 views