IMPDP - without data - running out of space
Oracle 19.12 - 4 nodes RAC on Oracle Linux 7
I need to copy a large production schema to dev database without data. it has lots of partition tables and indexes. some tables have 300+ partitions and many tables have 4+ local partition indexes.
Export Par file: CLUSTER=n CONTENT=metadata_only EXCLUDE=STATISTICS
SCHEMAS ='PHXTXN
Import Par file: CLUSTER=n PARALLEL=4 REMAP_TABLESPACE=PHX_DATAL:PHX_DATAM
( I have many remap_tablespace parameters)
Issue: the source database tables/indexes have extent size 4 mg, 16 mg, 65mg,etc.
the destination database's tablespace extent size is 32 mb. So, when Oracle import even a small table with 4mb or 16 mb original extent, the import will occupy at least 32 mb initial extent.