Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL for all database tables
On 2 Oct 2003 10:04:20 -0700, watuni2000_at_yahoo.co.nz (Tyler Smith
Watu) wrote:
>I am in search of a query that can return DDL which can recreate a users tables
Do you want the query or do you really just want the DDL the query would produce? If all you really want is the DDL have a look at the freeware DBATool. It reads export files and can display and save all of the schema (or database) DDL in runnable .sql files.
http://www.DataBee.com/dt_home.htm