Home » RDBMS Server » Server Administration » select and describe tables
select and describe tables [message #369522] Thu, 12 October 2000 08:41 Go to next message
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 Go to previous message
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!
Previous Topic: Convert FMX
Next Topic: Windows 2000
Goto Forum:
  


Current Time: Thu Mar 28 10:05:03 CDT 2024