> 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.
Chris