Re: Oracle10g temporary tablespace and datafiles

  • From: Maxim Demenko <mdemenko@xxxxxxxxx>
  • To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
  • Date: Mon, 08 May 2006 14:19:07 +0200

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
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006