Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ORA-39165: Schema OFDAT was not found.
- GRANT EXPORT FULL DATABASE TO OFDAT;
- GRANT EXPORT FULL DATABASE TO OFDAT WITH ADMIN OPTION;
- [oracle@OptTekOracleDB dpdump]$ oerr ora 39165
- 39165, 00000, "Schema %s was not found."
- // *Cause: If exporting or importing over the network, either the user
- // specified a schema name that was not found in the source database
- // or else the user lacked the proper EXP_FULL_DATABASE or
- // IMP_FULL_DATABASE role that would allow them to access another
- // schema. For importing from files, the user specified a schema
- // name not found in the dump file set.
- // *Action: Retry the operation using the correct schema name.
- GRANT EXP_FULL_DATABASE TO OFDAT;
- DUMPFILE="dev_ofdat_2-1-3-0_afterbackfill.dmp"
- LOGFILE="exp_dev_ofdat_2-1-3-0_afterbackfill.log"
- DIRECTORY=DATA_PUMP_DIR
- COMPRESSION=METADATA_ONLY
- CONTENT=ALL
- SCHEMAS=('OFDAT')
- expdp ofdat PARFILE=exp_dev_ofdat_2-1-3-0_afterbackfill.dat
- expdp {dbausername}/{dbapassword} SCHEMAS=OFDAT DUMPFILE=dev_ofdat_2-1-3-0_afterbackfill.dmp
- ORA-39165: Schema XXXX was not found.
- INCLUDE=TABLE:"IN('T1','T1')"
- INCLUDE=TABLE:"IN('T3','T4')"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement