Database - RAC/Scalability (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center