There are various points should be considered while performing or diagnosing the imp/exp operation . Here are some important point which we should while diagnosing the import/export issues.
1.) Check if we are using correct syntax or not . Use exp help=y or imp help=y to get the correct syntax.
2.) Check if we are using correct exp/imp utility (version) against the database. Use following metalink note for compatibility matrix .Note 132904.1 – Compatibility Matrix for Export And Import Between Different Oracle Versions .
3.) Check DBA_REGISTRY view to see if the components are in valid state .
4.) Try setting errorstack if we are facing “ORA-” error .
5.) Try setting trace=y parameter in export/import. This will generate a trace file ( similar to sql trace ) which can be used to diagnose the problems .
e.g; exp system/passwd full=y file=expdat.dmp log=exp.log trace=y
Reference : http://askdba.org
Enjoy :-)
No comments:
Post a Comment