Re: DB Create Script

Hi!

One way would be to use dbca (database creation assistant) to create fresh databases and then use exp/imp with full=y option to transfer everything else (with rows=y or n depending on whether you want to transfer actual data as well).

There's definitely tools as well... but I've usually managed to get away with standard Oracle tools, so others know better about 3rd party solutions. First things that come into my mind are DataBee, Toad and Oracle Change Manager module in OEM.

Tanel.

"Michael Rothwell" <marothwell_at_yahoo.com> wrote in message news:9a-dnW0AcKAgVIOiXTWJkw_at_comcast.com...
> Any suggestions on a tool to use to create a "database creation script"?
> I need to take the database on a dev box and create the scripts to run
> on production boxes to re-create the db there. This will include
> tablespaces, tables, indexes, constraints, stored procs/functions,
> etc... I can gen these all by hand, but if there is a tool that will do
> it, that would be nice.
>
> Michael
> --
> There is no worse tyranny than to force a man to pay for what he does
> not want merely because you think it would be good for him. -- Robert
> Heinlein
>
Received on Wed Jul 23 2003 - 13:40:29 CDT