Trying to do a PD to PY Refresh taking PD:
PD Production JDE DB on Oracle 10.2.0.2 DB/AIX 5.3
PY Development JDE DB on Oracle 10.2.0.2 DB/AIX 5.3
New to this JDE environment.
Any best practices? Docs? URL's?
Currently Dropping Constraints/Indexes and IMP into from EXP from Production.
However, in test Table, dropped constraint/index and import did not bring in.
EXPort Parameter File:
IMPort Parameter File:
IMP-00015: following statement failed because the object already exists:
Import terminated successfully with warnings.
However, looking for the indexes and constraints, they are not there.
Thanks in advance for comments/replies!
Uncommented the _"IGNORE=Y"_ on the IMP.par (parameter file).
Changed the "CONSISTENT=Y" to _"CONSISTENT=N"_
Actually we ran into an issue as we were only trying to import in the INDEXES and CONSTRAINTS, however, we were pulling STATISTICS as well.
We added _"STATISTICS=NONE"_ on both the EXP/IMP Parameter file to resolve this issue.
This also, sped up IMP/EXP times, shrunk the size of .dmp file, etc.
Recommend this, as it was helpful (my boss is brilliant).
Here's the final results - in case you run into in the future. EXPort.par
Hope this helpful!