Re: copy of the schema map of specif. db - help

stanford_at_cableone.net wrote:
>
> I need to get a report showing tables, contraints, colomn defs, etc.
> is there a tool provided with oracle 8 that I could perform this with
> or could someone point me to a third party tool????
>

You can get a neat listing of the columns and datatypes in a table via the SQL*Plus "describe" command: type DESCRIBE YOUR_TABLE_HERE. To see what tables you have in a scheme, select * from USER_TABLES when logged in as the schema's owner. Same with indexes and USER_INDEXES.

Or, you can use the Schema Manager in Oracle Enterprise Manager to acheive the same effect more easily.

Erik Diehn
erikd_at_nospamm.cometsystems.com - nospamm Received on Fri Sep 03 1999 - 14:37:44 CDT