Computing.Net > Forums > Database > Oracle System tables

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Oracle System tables

Reply to Message Icon

Name: deeps
Date: June 19, 2006 at 10:49:49 Pacific
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.



Sponsored Link
Ads by Google

Response Number 1
Name: lchi2000g
Date: July 17, 2006 at 12:46:44 Pacific
Reply:

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


Luke Chi


0

Response Number 2
Name: tpspsz
Date: July 20, 2006 at 20:38:34 Pacific
Reply:

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


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Oracle System tables

to get package name from ora sys ta www.computing.net/answers/dbase/to-get-package-name-from-ora-sys-ta/269.html

Script to check database status www.computing.net/answers/dbase/script-to-check-database-status-/393.html

Can Access open Oracle tables www.computing.net/answers/dbase/can-access-open-oracle-tables/138.html