OraFAQ Forum: Server Administration » Export Import Issue (Table's count mismatch)

Home » RDBMS Server » Server Administration » Export Import Issue (Table's count mismatch) (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export Import Issue (Table's count mismatch) [message #679158]

Wed, 12 February 2020 01:28

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

Hello All,

We exported oracle DB dump from one machine and imported to another with same oracle version.

But then i notice one thing that for one table i.e. "NETWORK_PLANNING"."LINKAMCTHRESHOLD" exported and imported count is not matching. No error encountered related to this table in log files.
From Export Log

Code: [Select all] [Show/ hide]

. . exported "NETWORK_PLANNING"."LINKAMCTHRESHOLD"       39.66 MB  103405 rows

From Import Log

Code: [Select all] [Show/ hide]

. . imported "NETWORK_PLANNING"."LINKAMCTHRESHOLD"       14.88 MB  101972 rows

Isn't there should be some message in log file related to missing entries ? or any prerequisite which i need to follow before importing?

Note: I have checked NLS parameters and all are same in both M/Cs.

Let me know if need to share anything more here. thank you

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679159 is a reply to message #679158]

Wed, 12 February 2020 01:54

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is there any trigger or VPD policy set on this table?

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679160 is a reply to message #679158]

Wed, 12 February 2020 01:55

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Also are you sure you are importing the dump associated with the log you showed?

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679161 is a reply to message #679160]

Wed, 12 February 2020 02:14

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

Quote:

Is there any trigger or VPD policy set on this table?

No Trigger and No Security policies on this table.

Quote:

Also are you sure you are importing the dump associated with the log you showed?

Yes,

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679163 is a reply to message #679161]

Wed, 12 February 2020 03:21

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post both export and import commands and the header and footer of each file.

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679166 is a reply to message #679163]

Wed, 12 February 2020 04:12

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

Export was executed by our client only and below is what they shared when we asked them to show Export command they executed. (This is only we have for export)

Code: [Select all] [Show/ hide]

expdp <DBA login> parfile=asset_full_v12.par

Parameter file contents

Code: [Select all] [Show/ hide]

CONTENT=ALL
DIRECTORY=DP_DIR
dumpfile=ASSET_export_V12_%u.dmp
logfile=ASSET_export.log
FULL=Y
PARALLEL=4
version=12
EXCLUDE=SCHEMA:"IN ('MTN_ADMIN','MTN_QSPL')"

below is what we used while importing....

Code: [Select all] [Show/ hide]

IMPDP system/****@OSID full=y dumpfile=ASSET_export_V12_01.dmp,ASSET_export_V12_02.dmp,ASSET_export_V12_03.dmp,ASSET_export_V12_04.dmp logfile=ImportLog06Feb2020.log directory=DATA_IMPORT_DIR

Meantime, we request fresh dump from client.

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679168 is a reply to message #679166]

Wed, 12 February 2020 04:31

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So
1/ You are not sure they imported the correct dump maybe an old one
2/ We can't diagnose without the log files

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679169 is a reply to message #679168]

Wed, 12 February 2020 04:43

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

We just imported the dump which was shared by our customer. No alteration in b/w, direct import. Might be export dump got corrupted somewhere so now we requested fresh export dump.

Will keep posted if that work or not.

thank you

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679170 is a reply to message #679169]

Wed, 12 February 2020 04:57

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But you are not sure you imported, that is they gave you, the dump associated with the log you told us.
I advise you to tag with a timestamp the name of the dump to prevent from this kind of error.

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679180 is a reply to message #679170]

Wed, 12 February 2020 22:23

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

Noted. thank you

Report message to a moderator

Re: Export Import Issue (Table's count mismatch) [message #679229 is a reply to message #679180]

Mon, 17 February 2020 01:24

vippysharma
Messages: 73
Registered: May 2013
Location: www

Member

Fresh dump imported successfully with exactly same counts.

Client seems confused (might not sure) when i told them to confirm initial export log associated with initial dump. Seems like some disconnect from there side causing initial mismatch.

Report message to a moderator