| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Reducing table initial extent size for subset of production
I have not used it by I remember seeing this script on Ferenc Mantfeld site
http://www.solvit.net/dbscripts/resize_db.html
Haven't seen Ferenc post in awhile....
............................................................................ .................................
Database Administrator office: 336 878-7268 LifeStyle Furnishings International fax : 336 878-7038 ............................................................................ .................................
> -----Original Message-----
> From: Linda Hagedorn [SMTP:Linda_at_pets.com]
> Sent: Friday, June 16, 2000 2:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Reducing table initial extent size for subset of production
>
> I inherited an export/import process to create a subset of production data
> for development and QA use. It's consistently running out of space.
>
> The goal is to create a duplicate production database on a test platform,
> delete rows and/or truncate specific tables, export the tables and data,
> and
> import the reduced-volume tables.
>
> In reviewing the MetaLink doc 61949.1 Export and Import Bulletin, it's
> saying COMPRESS will alter the initial size to be the currently allocated
> size, despite the contents or lack thereof. This explains why I'm running
> out of space, even after deleting a significant portion of the data.
>
> To reach my goal of smaller tables, do I have to 1) export without
> compression, 2) preallocate all 200+ tables, and 3) import, or is there
> another way? If I have to preallocate the tables, does someone have SQL
> to
> generate the DDL statements, including the size math to recalucluate the
> tables smaller?
>
> Any input is appreciated. Thanks.
>
> Linda Hagedorn
>
> --
> Author: Linda Hagedorn
> INET: Linda_at_pets.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jun 16 2000 - 14:43:47 CDT
 |
 |