Hello Experts-
I'm a little puzzled and hope to get some clarification as why the schema sizes are different after the schema was exported & imported into another database(Oracle 11.2.0.3 on HP-UX 64 bit).
Source Schema(USERS1): 188.067932.
Target Schema(USERS1_TEST): 140.85.
Script Used for the above calculation::
select owner,sum(bytes)/1024/1024/1024 schema_size_gig
from dba_segments group by owner;
Expdp Parfile:
DUMPFILE="EXPDP_%u.dmp"
LOGFILE="EXPDP.log"
DIRECTORY=EXPORT_DIR
PARALLEL=6
COMPRESSION=ALL
REUSE_DUMPFILES=YES
SCHEMAS=('HR_INFO', 'USERS1')
Impdp Parfile:
DUMPFILE="EXPDP_%u.dmp"
LOGFILE="impdp.log"
DIRECTORY=EXPORT_DIR
STREAMS_CONFIGURATION=n
TABLE_EXISTS_ACTION=SKIP
SKIP_UNUSABLE_INDEXES=y
CONTENT=ALL
PARTITION_OPTIONS=none
PARALLEL=12
REMAP_SCHEMA='USERS1:USERS1_TEST'
SCHEMAS=('USERS1')
Is the import missing something from the source schema ?