change the INITIAL extent of the tables/partitions during import

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.

 

Thanks,
Lei Zeng




Other related posts: