Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Schema Size from dba_segments differ from soucre & target schema after impdp.

885068Dec 4 2015 — edited Dec 7 2015

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 ?

This post has been answered by EdStevens on Dec 4 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2016
Added on Dec 4 2015
3 comments
1,929 views