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)
Export Import Issue (Table's count mismatch) [message #679158] Wed, 12 February 2020 01:28 Go to next message
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
. . exported "NETWORK_PLANNING"."LINKAMCTHRESHOLD"       39.66 MB  103405 rows
From Import Log
. . 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
Re: Export Import Issue (Table's count mismatch) [message #679159 is a reply to message #679158] Wed, 12 February 2020 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Export Import Issue (Table's count mismatch) [message #679160 is a reply to message #679158] Wed, 12 February 2020 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Export Import Issue (Table's count mismatch) [message #679161 is a reply to message #679160] Wed, 12 February 2020 02:14 Go to previous messageGo to next message
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,
Re: Export Import Issue (Table's count mismatch) [message #679163 is a reply to message #679161] Wed, 12 February 2020 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Export Import Issue (Table's count mismatch) [message #679166 is a reply to message #679163] Wed, 12 February 2020 04:12 Go to previous messageGo to next message
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)

expdp <DBA login> parfile=asset_full_v12.par 
Parameter file contents
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....
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.
Re: Export Import Issue (Table's count mismatch) [message #679168 is a reply to message #679166] Wed, 12 February 2020 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Export Import Issue (Table's count mismatch) [message #679169 is a reply to message #679168] Wed, 12 February 2020 04:43 Go to previous messageGo to next message
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
Re: Export Import Issue (Table's count mismatch) [message #679170 is a reply to message #679169] Wed, 12 February 2020 04:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Export Import Issue (Table's count mismatch) [message #679180 is a reply to message #679170] Wed, 12 February 2020 22:23 Go to previous messageGo to next message
vippysharma
Messages: 73
Registered: May 2013
Location: www
Member
Noted. thank you
Re: Export Import Issue (Table's count mismatch) [message #679229 is a reply to message #679180] Mon, 17 February 2020 01:24 Go to previous messageGo to next message
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.
Re: Export Import Issue (Table's count mismatch) [message #679230 is a reply to message #679229] Mon, 17 February 2020 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you suggest him the advice I posted about the names?

Re: Export Import Issue (Table's count mismatch) [message #679231 is a reply to message #679230] Mon, 17 February 2020 01:44 Go to previous message
vippysharma
Messages: 73
Registered: May 2013
Location: www
Member
Yes, new logs were with timestamps.

thank you
Previous Topic: ERROR - START ORCLE SERVICE IRCL
Next Topic: Oracle Server 11g times out after only a few min online
Goto Forum:
  


Current Time: Thu Mar 28 04:19:33 CDT 2024