I'm learning oracle and I need to make a copy of a table structure in case I accidentally blow it away.
In my past lives with Fox, Access it was pretty intuitive.
Even though I'm using TOAD with Oracle 9i, I can't seem to find a way to do it.
If someone could point me in the right direction, I would sure appreciate it.
TOAD will generate a script for you if you are really only interested in the structure, and not the data. Just right-click on the table in the Schema Browser, choose Create Script, and then select the options which include those feature you are most interested in (ie including indexes, referential integrity).
Using the CTAS (create table as method) will not retain indexes, RI, etc, only the table structure itself.