![]() In the ATP, we create a new user called HRATP. Oracle Database 18c Enterprise Edition Release 12.2.0.1.0 - 64bit ProductionĤ username => password => '***MY_TOKEN***' Last Successful login time: Fri 10:47:04 +02:00 Login into the Autonomous Transaction Processing database as admin user and create a new credential called ATPCS_CRED. Note your generated token and “Close” the window. The random generated string is the value for the DBMS_CLOUD password.Įnter a name for the token and click on “Generate Token”. Create a new token by click on “Generate Token”. Go to Identity – Users – your username and click on the left side on “Auth Tokens”. If you don’t now your token, create a new one. The DBMS_CLOUD procedure needs a password value which is the token from the user account. For more information about the package, see the blog post from Christian Antognini – DBMS_CLOUD Package – A Reference Guide. To get acccess to the dump file on the Oracle Object Storage, a credential has to be created in the Oracle Autonomous Transaction Processing database with the DBMS_CLOUD procedure. Part 3: Import of data into the ATP database with Oracle Data Pump.Part 2: Export of on-premises data with Oracle Data Pump and move into into the Oracle cloud.Part 1: Creation of the ATP database and connection verification.This is why I am suspecting that something has between the 1st sucessfull impdp and the second impdp command.In this blog post serie which has three parts, I want to describe how data will be uploaded from an on-premises environment into the Oracle Autonomous Transaction Processing database using Oracle Data Pump. I don't know if it is a co-incidence, but then also, it was the second impdp that failed with the same error. I put 5 impdp commands in a similair script. Info on very similair issue I had last week I don't understand why I get "unable to open dump file" because the dumpfile is present and moreover the two other impdp commands which uses the same dumpfile (1st and 3rd) were succesfull. Linux-x86_64 Error: 2: No such file or directory ORA-31640: unable to open dump file "/u07/wmsdata/expdat.dmp" for read With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,ĭata Mining and Real Application Testing options All rights reserved.Ĭonnected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |