Re: Expanding Database Size

Noah Monsey wrote in message <3496eed8.20108606_at_207.225.159.3>...

<snip>
>Yes a script would be faster, but then you have to know exactly
>what sizes to make most of the objects. If you make a mistake
>adding a tablespace with Oracle Storage Manager, you can
>drop the tablespace, delete the datafile and do it over again until
>you are happy.

Which is why I believe that it must be scripted. IMHO a good dba should exactly know what the sizes the datafiles should be, the total size of a tablespace etc. I agree that a GUI tool is indespensible when looking after a database (even though I don't believe that Oracle's Enterpise Manager always fits the bill), but when it comes down to changing database structure it should be included in the db scripts for that database. BTW, dropping and adding datafiles can be very time consuming, especially if the datafiles are a couple of GB's.

But then every dha has his/hers own methods of doing things. :-)

regards,
Billy Received on Wed Dec 17 1997 - 00:00:00 CST