I'd recommend you post a copy of your "init<SID>.ora" file before you reorg.
Did you install it? Did you use the wizard to install it? If yes, then it's
more likely that the problem is related to db buffers, shared sql area and
checkpoint parameters than with the data. The last time I inherited an NT
install, the database was using less than 12 Mb for the SGA on a box with
2Gb of RAM.
"Heiko" <ht_at_bigfoot.de> wrote in message
news:6ea78$3ee33b26$d4cac0e3$20785_at_nf1.news-service.com...
> Hi @All!
>
> Is there a tool to reorg a Oracle 8 database? Size is 10 GB with > 100
> tables.
>
> Thanks!
> Heiko
>
>
Received on Sun Jun 08 2003 - 23:22:02 CDT
