change the INITIAL extent of the tables/partitions during import

  • From: "Lei Zeng" <lzeng@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 13 Nov 2009 12:36:10 -0800

Hi, all:

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


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

Other related posts: