RE: Highwater mark for tablespace and table

If you don't need the table to continuously exist (for grants, etc.) and if
I'm correct in surmising that this tablespace only has one table and that
your point is to back up less, then you can just drop the tablespace
including contents and recreate it and the table.

If you need the table to continuously exist, then an alter table move should
not take much time after you truncate. Then drop and create the original
tablespace and move the table back.

I do not believe there is a single convenient command in 9i to mark blocks
above the last occupied address as never written.

Please let me know if this does not work for you; I think it *should* work
but I've not tested it.

Regards,

mwf 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Yasin Baskan
Sent: Wednesday, August 29, 2007 6:37 AM
To: hrishy; oracle-l@xxxxxxxxxxxxx
Subject: RE: Highwater mark for tablespace and table



RMAN does not backup NEVER USED blocks in 9i. In your case those blocks
are not NEVER USED, they have been used before, so it backs them up.

-----Original Message-----
From: hrishy [mailto:hrishys@xxxxxxxxxxx] 
Sent: Wednesday, August 29, 2007 12:31 PM
To: Yasin Baskan; oracle-l@xxxxxxxxxxxxx
Subject: RE: Highwater mark for tablespace and table

Hi

Thanks again

One more question if we truncate a table then the
higwater mark of that table gets reset but what
happens to highwater mark of the datafile

I am aksing this in relation to RMAN in 9i

<snip>


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


Other related posts: