| 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
We export from prod and import subsets into "test". There are about 5-6 test databases, so the names need to pretty much be the same or we'd have to create all of those by hand.
I have found that some of my candidates are LOCAL but USER, NOT UNIFORM, thank goodness.
The major concerns were the partitions and they ARE the same on both sides. One of them this month, one months data, was 186 million rows. We use export policy and don't export these, but we import to create the first extent on the way back in. This allows the 40GB partition tablespace in PROD to be collapsed to 105 MEG in TEST and that's why we can fit it in a much smaller space. But this still means the tablespaces need to have the same name.
It also appears some of the others may be empty and that is why this problem has not surfaced sooner. I've been through three refreshes so far and this one hit me with about 2-3 tablespaces that didn't fit.
The INFORMATICA tablespace was unused on all other test databases and was one that nailed me this go around.
Fortunately the "populating" step was repeatable, so we saved what we had to, purged the rest, then did the recreate only having to move like 1 table and 1 index back.
I totally drop all tables before population, so I'll be building a list of "things to do before population" if I can hold off for this "cycle". These are the 400-700gb databases, so it's not fun.
-- Michael Kline 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545Received on Tue Jan 27 2004 - 10:00:18 CST
> 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
> -------------------------------------------------------------
> 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.
> -------------------------------------------------------------
> -------------------------------------------------------------
> 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.
> -------------------------------------------------------------
------------------------------------------------------------- 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. -------------------------------------------------------------
 |
 |