Oracle System tables

Computing.Net > Forums > Database > Oracle System tables

Original Message

Name: deeps
Date: June 19, 2006 at 10:49:49 Pacific
Subject: Oracle System tables
OS: WIN XP
CPU/Ram: 1GB

Comment:

Can someone please tell me which system tables in Oracle have the source code of creating a table or index.
That is to say, that once the table is created and i wish to retrieve the source code used for creating the table then where can i find it.
thanks.

Report Offensive Message For Removal

Response Number 1

Name: lchi2000g
Date: July 17, 2006 at 12:46:44 Pacific

Reply: (edit)

Oracle does not store the source code of "create table".

Luke Chi

Report Offensive Follow Up For Removal

Response Number 2

Name: tpspsz
Date: July 20, 2006 at 20:38:34 Pacific

Reply: (edit)

Have a look at the SQL Developer tool (free). If you open a table there's an "SQL" tab which presents SQL to (re) create the table.
Cheers, tpspsz

Report Offensive Follow Up For Removal


to get package name from ora sys ta Script to check database status Can Access open Oracle tables MySQL Select multiple tables Designing Check Printing System	creating a message table in oracle find column name across tables Unload data from table to file Oracle spool output to file SQL - get difference between rows

inspiron 7000

Left/Right Join MYSQL

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: Oracle System tables

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 4 Days.
Discuss in The Lounge

PCMCIA card Microtech mp60287?

My PC got something wrong

Default Browser ?

Creative DXR2 DVD decoder

Installing Pastel on Vista

All Posts Awaiting Replies