resize in raw device

hi

I have a temporary tablespace in raw device, few days back we were getting problems with this raw device so we extended raw partition from 200MB to 400MB however my doub is how can I resize at database level? Should I drop the temporary tablespace and recreate it with 400MB?

cheers

how did u create the temporary tablespace.
i mean have u used
create temporary tablespace < name >
tempfile 'xxx'

if u create like this u will not have a dictionary enry for this.
better u drop and recreate the temporary tablespace.

well, I dont really mind about the dictionary, what I was asking if you can resize a datafile in raw device using resize command or you have to drop and recreate the tablespace

first check the path of the datafile of the temporary tablespace.

if u have then use

alter database datafile 'xxx' resize 400M;

this will work.

if u create a temporary tablespace using keyword temporary
and datafile ' path'

then definetely find out the location and increase this way.

xxx --> full path of ur datafile.

Without extending the partition, you can resize the partition < or > but not greater then the actual partition size.

Quote:

---

Originally posted by pando
well, I dont really mind about the dictionary, what I was asking if you can resize a datafile in raw device using resize command or you have to drop and recreate the tablespace

---

Pando, my TEMP tablespaces are on raw devices, I do drop and recreate. I suggest you do that.

I have 1G partitions for TEMP tablespaces.

I managed to resize, it takes a bit longer than resizing in file system (i thought it was hanging at the beggining), had to leave a few oracle data blocks empty though

BTW it was HP-UX 11.0 Oracle 8.0.6 Enterprise

Interesting to hear that. I have never resized TEMP. Since it's TEMP, I drop and recreate.

I thought that too but in this shop to drop and recreate tablespace you probably have to wait two days due to huge stuffs (burocracy, english is this?) we have to do... sad but true