| select and describe tables [message #369522] |
Thu, 12 October 2000 08:41  |
shad
Messages: 50
Registered: October 2000
|
Member |
|
|
I need to extract all the information about all tables in the database, i.e the structure not the content.
I have to do this for about 20 databases, each database with about 400 tables.
I tried to use select table_name from dba_tables and then do a desc of each table. How can I do this in a way that I will not have to go to each table to decribe it. please help
|
|
|
|
| Re: select and describe tables [message #369523 is a reply to message #369522] |
Thu, 12 October 2000 09:05  |
Girodaon
Messages: 4
Registered: August 2000
|
Junior Member |
|
|
Hi Shad!
I suppose to use the export-util for that purpose. You simply export your tables without content and with the objects you need. Then you could you Import with show=y and spool the output in a file. Now you will have all the SQL that recreates your tables (objects) in ascii!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
