Re: Copying the structure

pankaj_wolfhunter_at_yahoo.co.in wrote:
> Thanks for the reply Brian. I am using Oracle 10g.
> I am kinda new to Oracle. DBMS_METADATA didnt clicked me.
> neways, thanks for the help.
>

You could have done the following:

SELECT DBMS_METADATA.GET_DDL('TABLE','TABLE_NAME','TABLE_OWNER') FROM DUAL; Make appropriate substitutions for the table name and owner place holders above. The output can be pasted into a script and modified in whatever manner you choose. This does not create the table in one simple SQL command, so it does not meet your initial requirements. But give it a try!

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown