Re: "dbschema"

>I know some of you are going to shoot me for this ...... but does Oracle >have an equivalent for Informix's dbchema command ? The short answer for an Oracle direct equiv of dbschema is 'No'. But there are many ways to get the same sort of information that dbschema provides, this can be done using tools suc as Toad or depending on what you actually want, and which oracle version you are using, there is a package called DBMS_METADATA which you can get the DDL necessary to create most objects. All of the information that would be required to provide the similar output to dbschema is held in system tables and can be extracted. You can generate SQL to recreate users/roles etc etc. There are many scripts out there on forums such as DBA-Village which would provide scripts to do this.

<continue> .... .....also, there is of course the way to extract DDL from imp(ort) for tables and indexes etc....This can be very fiddly, which is probably why they brought in the dbms_metadata package in later (9i) version...