Re: Scripts to generate views and tables

Oh, a note on that, concerning referential integrity of creating the tables in the correct order, you would want to look at ALL_DEPENDENCIES and ALL_CONSTRAINTS as well. Getting into ALL_DEPENDENCIES may be more trouble that it is worth. You can get around this (total hack) by just running the script several times ignoring errors. It's not pretty, but it saves time.

You can also use a program called PowerDesigner to reverse engineer a database and recreate the dropscript. I think it ignores table creation order when dealing with referential integrity (i.e. parent tables must be created before child tables, or all tables must be created before referential constraints are in place).

Tom
www.oraclepower.com

"Vinnie" <vwas_at_nospam.hotmail.com> wrote in message news:zAg48.2052$s_7.1445465338_at_newssvr14.news.prodigy.com...
> I'm running an Oracle 8.0.6 database and would like to see if there is a
> script which I can run which will in turn generate both tables and views
for
> a test version of our production database. I don't want to use the
> export/import because I'd like to modify several of the tables at the time
> of creation. I saw a couple of scripts on Metalink but they were all crap.
> Any ideas?
>
> TIA
>
Received on Fri Jan 25 2002 - 11:37:13 CST