--
"Tyler Smith Watu" <watuni2000_at_yahoo.co.nz> wrote in message
news:2f3438a4.0310030536.4e15118d_at_posting.google.com...
> Dale Edgar <Dale_at_DataBee.com> wrote in message
news:<sbaqnvo1h9hu1d1lg8lt6pjm0bgugh7uft_at_4ax.com>...
> > 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
Doing just tables shouldn't be too hard, but it might become more difficult
doing everything that an Oracle schema might contain like indexes, primary
keys, foreign keys, sequences, synonyms, materialized views, functions,
procedures, packages, regular views, grants, etc. etc. etc.
> >
> > 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
> >
> > - Dale
> > -----
> > Need test and development databases? You need DataBee.
> > Simple and cost effective database subsets. http://www.DataBee.com
>
> Appreciate your responses
> Will have a look at databee looks like it may do the trick.
> I thought there was a data dictionary table to query or may be someone
had
> done a similar thing.
I wouldn't be surprised if this has been done a few million times over the
world over the last 20 years (or however long Oracle has been around).
We use to have in-house developed Sql scripts for 1 table and then used exp
for many tables.
I would still use exp for many tables, but for 1 table I like using TOAD
these days.
>
> HP unix 11
> RDBMS Version 8.1.7.0.0
>
> TYSW
Received on Sat Oct 04 2003 - 00:29:12 CDT
