Getting Table / Index creation script

#1

Hello,

is there any view where I could get the creation script of an existing table
?
Same question for an index.

Thanks.

Fred.

#2

fred wrote:

Quote:

Hello,

is there any view where I could get the creation script of an existing table
?
Same question for an index.

http://oraclesvca2.oracle.com/docs/c...2/d_metada.htm

#3

fred wrote:

Quote:

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@x.washington.edu
(replace x with u to respond)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Getting Table / Index creation script

comp.databases.oracle.misc comp.databases.oracle.misc

Getting Table / Index creation script - 03-20-2006 , 09:23 AM

Re: Getting Table / Index creation script - 03-20-2006 , 09:29 AM

Re: Getting Table / Index creation script - 03-20-2006 , 10:37 AM