Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Tablespace management
Vince Laurent wrote:
> I have a situation on one of our systems (Oracle 8.1.7.3).
> Seems there a few tables that have grown a bit. The NEXT
> extent for each of these tables is larger than the largest
> free chunk. Is there a way to adjust the NEXT on the fly
> (ie short of a reorg/imp/exp) to make the NEXT smaller?
alter table tab_a storage(next xxxxk);
alter tablespace tblspace_a default storage (next xxxk pctincrease 0);
> All the freespace chunks have been coalesed. My ultimate
> goal is to get these tables to thier own tablespaces but
> thanks to SAP they don't make it easy.
afaik: touch/tune/alter the database directlty (not going thru the
SAP tools), and you lose _all_ support (by SAP, that is).
-- Regards, Frank van BortelReceived on Thu Apr 10 2003 - 13:40:16 CDT