Re: Windows: Create DB creation scripts from an running instance

Dear HJR

With the database configuration assistant, you are only able to get creation scripts for a new DB. But I'm looking for a script that receives all the current settings from a running instance. My aim is to run an export of a DB, create a second db with these creation scripts (with all the changes done since the DB has been started, e.g: - increases of the memory usage like shared pool or java pool size or - adding datafiles (for example 4 times 500mb), but optimized to big datafile (1 time 2gb)
and then to import all the data in the new db. I have to change this DB from a slow machine to a faster one and I would like to use this situation to do a reorganization at the same time.

cygwin is surely a beautiful tool, but our nt-administrators are afraid of installing any os-interpreters.

best regards

Casi Schmid

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> schrieb im Newsbeitrag news:ZD2m9.43496$g9.124570_at_newsfeeds.bigpond.com...
> I'm sure this isn't particularly helpful, but is there any reason why you
> don't use the database configuration assistant to create databases? Or
are
> you just deeply in love with the command line? ;-)
>
> When madness struck once, I installed CYGWIN on a Windows box. It gives
you
> a fully-functional unix shell, in which these sorts of scripts will run
more
> or less without modification (I can never remember whether CYGWIN uses the
> korn or bourne shells... I think it's bourne, which means that unix
scripts
> written for that shell work fine). I believe that CYGWIN is a free
download,
> too.
>
> But trying to get that sort of functionality in a boring old batch file is
a
> bit of a non-starter, I'm afraid.
>
> Regards
> HJR
>
> "Casi" <casimir.schmid_at_swisscom.com> wrote in message
> news:1033395117.347861_at_exnews...
> > Dear all
> >
> > I'm looking for a similar script to the one found here....
> >
> > http://www.orafaq.com/scripts/unix/crdb.txt
> >
> > ...for Windows NT 4.0 32-Bit.
> >
> > Thanks in advance!
> >
> > Casi Schmid
> >
> >
>
>
Received on Tue Oct 01 2002 - 01:48:14 CDT