Database Administration (MOSC)

MOSC Banner

JD Edwards PD - PY refresh

edited May 2, 2012 9:04AM in Database Administration (MOSC) 1 commentAnswered
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:

BUFFER=10485760
FILE=$OEXP/exp_Date.dmp
OWNER=(UName1, UName2)
CONSISTENT=Y
GRANTS=Y
ROWS=N
INDEXES=Y
CONSTRAINTS=Y
COMPRESS=Y
LOG=$OEXP/exp_Date.log

IMPort Parameter File:

BUFFER=1048576
FILE=$OEXP/exp_Date.dmp
FROMUSER=(Uname1, UName2)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center