IMPDP skip some tables while importing

Weird situation, it is importing some tables and skipping some tables, did export at 11.2.0.2/AIX and importing into 11.2.0.3/Oracle Linux db.

Does anyone have any idea why this kind of behavior?

Export logs are all good, don't see any error over there.

Thanks in advance.
Mushfique KhanDirector OperationsAsked:
Who is Participating?
 
Mushfique KhanConnect With a Mentor Director OperationsAuthor Commented:
thanks Gurus :) but resolved it, basically it's a RAC db with 2 nodes, dump files were only visible from one node and that was the reason of this behaviour, when I copied the same files to 2nd node too ... all went smooth.

Just a curiosity question, if you can ... what is the best practice for RAC configuration, where we should place our oracle home and other files ... can you share some best practice doc/link or anything, because I was in the impression that files/directories/oracle homes should be shared.

But thanks a lot for your input.
0
 
Geert GruwezOracle dbaCommented:
is deferred_segment_creation on true (that's the default)
http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams075.htm#REFRN10307

impdp will skip those tables that have 0 rows

you can solve this by manually allocating an extent to those tables
(or by inserting a row)
these are tables which exists in dba_tables and not in dba_segments

sample for allocating an extent:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_3001.htm#i2133144
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
can you upload your import logs here as impdp should have written about it to the logs ?
0
 
sdstuberCommented:
pleast post both your export logs as well as the import logs
0
 
Mushfique KhanDirector OperationsAuthor Commented:
solved it myself.
0
All Courses

From novice to tech pro — start learning today.