Trigger error using Datapump Import on underlying APEX schema
TnJedMay 31 2013 — edited May 31 2013Howdy,
I have a schema which contains underlying data for an APEX application. They asked for a refresh of acceptance with production data. I used Datapump and did a simple export, sftp'd the file into acceptance, dropped the schema owner with cascade, recreated the user and started the import. Standard stuff. Then my import started throwing this:
ORA-31693: Table data object "WPSR"."GENVIEW_STG" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26086: direct path does not support triggers
on a number of the tables. I'm extracting the triggers, then I'm going to drop them and retry my import with a t_e_a=REPLACE.
Anybody seen this? Any suggestions, criticisms, etc, gratefully accepted.
LarryO