Database Administration (MOSC)

MOSC Banner

ORA-26032 impdp (Index organized table)

edited Aug 18, 2016 5:00AM in Database Administration (MOSC) 7 commentsAnswered

Iam performing a export and an import in a 12 C source and destination database. I have given the commands I have used. One particular table shows as exported and imported successfully but upon querying the table I see that no records are available.

select  * from CISADM.CI_ACCT_APAY_K - no records in destination.

*** exp par file ********************

DIRECTORY=DMTDATA

REUSE_DUMPFILES=Y

COMPRESSION=ALL

PARALLEL=32

METRICS=YES

KEEP_MASTER=Y

LOGFILE=DMTLOG:DMT_data.4.exp.log

DUMPFILE=DMT_data.4.%u.dmp

TABLES=CISADM.CI_ACCT_APAY_K

QUERY=CISADM.CI_ACCT_APAY_K:"inner join DMT.D000000109 X on ACCT_APAY_ID = X.\"acct_apay_id\" AND ENV_ID = X.\"env_id\""

Tagged:

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