Advertisement
Guest User

Untitled

a guest
Jul 26th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.17 KB | None | 0 0
  1. ORA-39165: Schema OFDAT was not found.
  2.  
  3. GRANT EXPORT FULL DATABASE TO OFDAT;
  4.  
  5. GRANT EXPORT FULL DATABASE TO OFDAT WITH ADMIN OPTION;
  6.  
  7. [oracle@OptTekOracleDB dpdump]$ oerr ora 39165
  8. 39165, 00000, "Schema %s was not found."
  9. // *Cause: If exporting or importing over the network, either the user
  10. // specified a schema name that was not found in the source database
  11. // or else the user lacked the proper EXP_FULL_DATABASE or
  12. // IMP_FULL_DATABASE role that would allow them to access another
  13. // schema. For importing from files, the user specified a schema
  14. // name not found in the dump file set.
  15. // *Action: Retry the operation using the correct schema name.
  16.  
  17. GRANT EXP_FULL_DATABASE TO OFDAT;
  18.  
  19. DUMPFILE="dev_ofdat_2-1-3-0_afterbackfill.dmp"
  20. LOGFILE="exp_dev_ofdat_2-1-3-0_afterbackfill.log"
  21. DIRECTORY=DATA_PUMP_DIR
  22. COMPRESSION=METADATA_ONLY
  23. CONTENT=ALL
  24. SCHEMAS=('OFDAT')
  25.  
  26. expdp ofdat PARFILE=exp_dev_ofdat_2-1-3-0_afterbackfill.dat
  27.  
  28. expdp {dbausername}/{dbapassword} SCHEMAS=OFDAT DUMPFILE=dev_ofdat_2-1-3-0_afterbackfill.dmp
  29.  
  30. ORA-39165: Schema XXXX was not found.
  31.  
  32. INCLUDE=TABLE:"IN('T1','T1')"
  33. INCLUDE=TABLE:"IN('T3','T4')"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement