We are using Transformation map to extract transform, subset and load data into target environment. We are using Oracle source as target schema. While running the export script, getting below error and export has failed.
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist.
DROP SEQUENCE GSD_DTM_OWNER.PUMPW_68039_822335
ERROR at line 1:
ORA-01031: insufficient privileges
Export script has thrown with an error "ORA-01031: insufficient privileges" and "ORA-01432: public synonym to be dropped does not exist. "
The first time was during a "create or replace directory" call, and the second was during a "DROP SEQUENCE" call. This appears to be a legitimate permissions issue with the account you are using.
Please have your Oracle DBA verify the account you are using has sufficient privileges and rolls set complete these tasks from a database perspective.
CA TDM 4.7 (Datamaker, GT Subset and Transformation map)
Source and Target database is: Oracle
After granting DROP privileges to user account and providing read/write access to the directory where dump files are created, we are able to run both import and script scripts.