| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> [oracle-l] Re: Uniform extents
mkline1
Why would you want to move the tables and then turn around and move them back? Sentimental attachment to the original tablespace name? Unless there is some other messiness you haven't told us about, like an application with its own ideas about physical locations, just create a new tablespace, sized right, and move the tables you want over there. And indexes, per Thomas' posting. If you have some larger tables, don't move them. One move and you are done. Coalesce and resize the original tablespace, if desired.
Anyway I think you have the answer to your original question, there is no special magic to resize LMTs.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: mkline1_at_comcast.net [mailto:mkline1_at_comcast.net]
Sent: Tuesday, January 27, 2004 7:47 AM
To: oracle-l_at_freelists.org
Subject: [oracle-l] Uniform extents
I beleive I already know the answer, but is there any way to change the uniform extents on a tablespace?
I'm trying to put a production database into "templates" that were built before my time.
I'm running into production tablespaces built on 64k extents, and someone set up the test database with 100m uniform extents. Takes a lot of room to shove 100-1500 tables into there when I only need a few hundred meg normally.
I'm probably sunk, but just wondering what "tricks" may be done to fix this. Can I convert it to dictionary, then back to local at the right setting which will be ignored except on new tables?
Perhaps a trick to "export" a tablespace, then drop and recreate? I've also done some "moves", dropped and recreated, and put the tables back, but that too has been messy.
Sure is messy.
--
13308 Thornridge Ct
Midlothian, VA 23112
804-744-1545
 |
 |