RE: tablespace resize Q

Hi Jack.

I use resize fairly frequent and can't say I have come across problems so far ...
(Oracle 7.2.3 on HP-UX 10.20)

Greets,

Kirsten

> -----Original Message-----
> From: Jack van Zanen [SMTP:nlzanen1_at_ey.nl]
> Sent: Monday, July 24, 2000 9:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: tablespace resize Q
>
>
>
>
> Hi All,
>
>
> I am close to increasing one of our production tablespaces size. Can you
> share
> your opinions/experience on this.
>
> Did anybody experience any problems/corruption/crash while executing the
> "alter
> database datafile '<file>' resize xxxM;" command
>
> or is it on a live system preferable to add a datafile(not really my
> favorite on
> a reasonable small database! 6G total )?
>
> Personally I have not yet experienced any problems doing this (all on test
> environment far less busy).
>
Received on Mon Jul 24 2000 - 07:27:50 CDT