Re: How to switch a datafile to another tablespace?
From: Phillip D. Jackson <delphi_at_mail.iag.net>
Date: 1995/12/28
Message-ID: <4bsmso$898_at_news.iag.net>#1/1
Date: 1995/12/28
Message-ID: <4bsmso$898_at_news.iag.net>#1/1
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