Generate CREATE TABLE DDL from Oracle?

Question

Is there a way in Oracle to have it generate the DDL (e.g. CREATE TABLE ...) for an existing table.

I have a table that was apparently created with additional LOB_storage_clauses or LOB_parameters and would like to figure out what there are. I am trying to create a new, but similar table.

Answer 1

I think, Oracle doesn't give it at standalone engine.

If you have Oracle designer it gives.

People normally use Toad or PL/SQL developer while working with Oracle, they both generate DDLs.

Also, if you use some data modeling tools like, ERwin, they are also capable of generating DDLs for you.

Answer 2

Oracle has a new tool, Oracle SQL Developer, replaces Project Raptor. It is a TOAD/SQL Navigator utility. Has some built in data dictionary views as well as DDL/SQL extraction tools. Have only evaluated it a little. I use Quest Software's SQL Navigator. Oracle's SQL Developer is for versions 9i and above.

Answer 3

1. Export the table, or the schema that owns it, no data, just structure

exp owner/pass file=mystery_table.dmp owner=schema_name rows=N

2. Extract the statements from the export file, by importing it in show mode. It will not actually import anything

imp owner/pass file=mystery_table.dmp table=table_name show=y log=statements.log

3. Statements.log will have all the sql needed to create the table, including all its related objects, such as indexes, lobs, constraints, etc. Each line will be enclosed in quotes, so you will have to cut and paste out what you want, but it will be there.

Answer 4

No Terrorists No Racism No Recession No same sex marriages No Rape No devil No organic disaters No international Warming No international starvation No professional recreation Lockouts No newborn Abuse, No Animal Abuse, No female Abuse extra more cost-effective prices on nutrition, gas, clothing, Electronics & etc WWE and TNA rebranded as 'total Nonstop international Wrestling' Lance Bass, Reichen Lehmkuhl, Spencer Duhm, Sam Champion and Matt Dallas residing as women human beings GSN divide into 2 channels(GSN classic and GSN present day) with the aide of project television, Fremantlemedia, Fremantlemedia Australia, Viacom, Seven community, BBC, Channel 4(uk), CBS, Warner Bros, NBCUniversal and Sony pictures Televison Comcast digital, structure digital and AT&T U-verse united jointly as one massive united statesa.'s digital cable televison a tremendous variety of the total earth's panorama will be resembling the Eighties and Nineties