On Wed, 7 Jul 2004, Christopher Kings-Lynne wrote:
> > Its questionable if these are to be interpreted as just changing the
> > default tablespace for subsequent creates, or also moving all objects
> > that were created using the previous tablespace. Since it's
> > indistinguishable whether an object was created using the default from
> > schema/database or given a tablespace explicitely (unless default was
> > 0), I'd opt for version one.
>
> I meant option one - I hadn't considered the second. The thing is
> though you have to maybe move some stuff on disk as well.
Maybe? You definately do.
In the ALTER DATABASE case you'd also need to lock users out of the
database.
I'm not so sure these additions are necessary for 7.5 though...
Does anyone else have thoughts?
Gavin