Re: How to switch a datafile to another tablespace?

This is true, at least until Oracle 7.3. Version 7.3 allows you to dynamically add/drop datafiles on the fly...

Phillip D. Jackson wrote:
>
> No can do. Once a datafile has been added to a tablespace, it is forever
> owned by that tablespace. About the only option is to drop the
> tablespace, recovering the file space and then add a new file to a
> different tablespace.
>
> Dr. Phil
Received on Thu Dec 28 1995 - 00:00:00 CET