Re: Getting Table / Index creation script

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 20 Mar 2006 08:37:07 -0800
Message-ID: <1142872600.55455@yasure.drizzle.com>

fred wrote:
> Hello,
>
> is there any view where I could get the creation script of an existing table
> ?
> Same question for an index.
>
> Thanks.
>
> Fred.

To do this use the dbms_metadata built-in package.

An easy to follow demo can be found in Morgan's Library at www.psoug.org.

HTH

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Mar 20 2006 - 10:37:07 CST