RE: Next Extent Failure Notification for Locally Managed Tablespaces

From: Guang Mei <gmei_at_incyte.com>
Date: Tue, 22 Jun 2004 12:46:00 -0400
Message-ID: <NJEDKDKJDGAKAEKKNEEJOEFKDFAA.gmei@incyte.com>

Maybe you could

create another tablespace (say tablespace XYZ), and move the objects to TS XYZ, drop the old (and empty) tablespace, re-create it with uniform extents, move back objects from XYZ, then finally drop TS XYZ.

Guang

> -----Original Message-----

That's not overly helpful, no ;)

I don't suppose there's any way to modify a tablespace to use uniform = extents after creation is there? It doesn't look like it, but if there = is, I figured I'd ask.

I really don't have the luxury of recreating this database.

Steve

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jun 22 2004 - 11:43:10 CDT