Re: Q: What is done when using desc?

In article <b00jqd$nlg$1_at_bambi.zdv.Uni-Mainz.DE>, "Moritz says...
>
>Galen Boyer wrote:
>> On Mon, 13 Jan 2003, mklein_at_students.uni-mainz.de wrote:
>>> Hi NG, I am wondering about what sqlplus is doing when I query the
>>> database with a DESC TABLE. I tried to find out by lokking at the
>>> DICT-Tables, but could not find out.
>>
>> Are you asking how to create the same output as desc?
>
>Yes that is the point, i am working on a backup-script for our Oracle-DB and
>the only thing i need to get into my flatfiles is the create statement for
>every table.
>
>Regards Moritz
>
>

exp userid=/ full=y rows=n
imp userid=/ full=y indexfile=backup_script.sql

backup_script.sql will have it all. actually, the expdat.dmp will have it all too.

Actually -- if you do real backups, you do not need to do this at all as your database BACKUPS will have this in the data dictionary.

Actually, if you use source code control for your developed software and treat DDL like the source code it is - you won't have to do this either!

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp