Re: Oracle10g temporary tablespace and datafiles

Mercadante, Thomas F (LABOR) schrieb:

>Sve,
>
>David's suggestion is one way top do this.
>
>I would follow another approach.
>
>Create a new temporary tablespace in the new location using the script
>below. The next day (or maybe later the same day) you will be able to
>drop the old temporary tablespace. If I read your email correctly,
>there is no way to remove a single file from a multi-file tablespace -
>you need to drop the entire tablespace to do that.
>
>
>

I didn't tried it yet, but since 10gR2 there is stated in the SQL Reference New Features, it is possible now to drop one datafile/tempfile from a tablespace under some restrictions ( should be empty file, should be not the first file in the tablespace etc)

Best regards

Maxim

--
http://www.freelists.org/webpage/oracle-l