We are using a transformation map to extract transform, subset, and load data into a target environment.
We are using Oracle source as the 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
CA TDM 4.7
Datamaker
GT Subset
Transformation map)
Source and Target database is: Oracle
Permissions issue on the database
The 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.
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.