change the INITIAL extent of the tables/partitions during import

From: Lei Zeng <>
Date: Fri, 13 Nov 2009 12:36:10 -0800
Message-ID: <>

Hi, all:

I have a question about the data pump (expdp/impdp) and the traditional export/import.  

We have a production database in which some tables/partitions have 10M as the initial extent size. When we extract DDL (impdp CONTENT=METADATA_ONLY) and use it to build another dev/qa database, I will run into space issue because the huge number of tables/partitions. I don't need data, I only need DDL. However, the initial extent is the big stop sign due to limited space.  

Is there any way to change the initial size in the DDL during impdp or import ?  

I tried impdp using SQLFILE option and then edit the sql fie generated. However, #1, the file is huge because FULL=y, this could lead to a time-consuming manual process. #2, I ran into tons of errors when running this sql file - either format issue or whatever.  

Anybody has better idea? I appreciate your help ahead of time.  

Lei Zeng

Received on Fri Nov 13 2009 - 14:36:10 CST

Original text of this message