API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 25th, 2020
262
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.38 KB | None | 0 0
raw download clone embed print report
  1.  
  2. Error starting at line : 3 in command -
  3. begin
  4. dbms_cloud.copy_data(
  5. table_name =>'CHANNELS',
  6. credential_name =>'OBJ_STORE_CRED',
  7. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/chan_v3.dat',
  8. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true')
  9. );
  10. end;
  11. Error report -
  12. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/chan_v3.dat
  13. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  14. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  15. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  16. ORA-06512: at line 2
  17.  
  18.  
  19. Error starting at line : 13 in command -
  20. begin
  21. dbms_cloud.copy_data(
  22. table_name =>'COUNTRIES',
  23. credential_name =>'OBJ_STORE_CRED',
  24. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/coun_v3.dat',
  25. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true')
  26. );
  27. end;
  28. Error report -
  29. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/coun_v3.dat
  30. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  31. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  32. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  33. ORA-06512: at line 2
  34.  
  35.  
  36. Error starting at line : 23 in command -
  37. begin
  38. dbms_cloud.copy_data(
  39. table_name =>'CUSTOMERS',
  40. credential_name =>'OBJ_STORE_CRED',
  41. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/cust1v3.dat',
  42. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true', 'dateformat' value 'YYYY-MM-DD-HH24-MI-SS')
  43. );
  44. end;
  45. Error report -
  46. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/cust1v3.dat
  47. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  48. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  49. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  50. ORA-06512: at line 2
  51.  
  52.  
  53. Error starting at line : 33 in command -
  54. begin
  55. dbms_cloud.copy_data(
  56. table_name =>'SUPPLEMENTARY_DEMOGRAPHICS',
  57. credential_name =>'OBJ_STORE_CRED',
  58. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/dem1v3.dat',
  59. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true')
  60. );
  61. end;
  62. Error report -
  63. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/dem1v3.dat
  64. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  65. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  66. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  67. ORA-06512: at line 2
  68.  
  69.  
  70. Error starting at line : 43 in command -
  71. begin
  72. dbms_cloud.copy_data(
  73. table_name =>'SALES',
  74. credential_name =>'OBJ_STORE_CRED',
  75. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/dmsal_v3.dat',
  76. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true', 'dateformat' value 'YYYY-MM-DD')
  77. );
  78. end;
  79. Error report -
  80. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/dmsal_v3.dat
  81. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  82. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  83. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  84. ORA-06512: at line 2
  85.  
  86.  
  87. Error starting at line : 53 in command -
  88. begin
  89. dbms_cloud.copy_data(
  90. table_name =>'PRODUCTS',
  91. credential_name =>'OBJ_STORE_CRED',
  92. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/prod1v3.dat',
  93. format => json_object('delimiter' value '|', 'quote' value '^', 'ignoremissingcolumns' value 'true', 'dateformat' value 'YYYY-MM-DD-HH24-MI-SS', 'blankasnull' value 'true')
  94. );
  95. end;
  96. Error report -
  97. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/prod1v3.dat
  98. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  99. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  100. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  101. ORA-06512: at line 2
  102.  
  103.  
  104. Error starting at line : 63 in command -
  105. begin
  106. dbms_cloud.copy_data(
  107. table_name =>'PROMOTIONS',
  108. credential_name =>'OBJ_STORE_CRED',
  109. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/prom1v3.dat',
  110. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true', 'dateformat' value 'YYYY-MM-DD-HH24-MI-SS', 'blankasnull' value 'true')
  111. );
  112. end;
  113. Error report -
  114. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/prom1v3.dat
  115. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  116. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  117. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  118. ORA-06512: at line 2
  119.  
  120.  
  121. Error starting at line : 73 in command -
  122. begin
  123. dbms_cloud.copy_data(
  124. table_name =>'SALES',
  125. credential_name =>'OBJ_STORE_CRED',
  126. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/sale1v3.dat',
  127. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true', 'dateformat' value 'YYYY-MM-DD', 'blankasnull' value 'true')
  128. );
  129. end;
  130. Error report -
  131. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/sale1v3.dat
  132. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  133. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  134. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  135. ORA-06512: at line 2
  136.  
  137.  
  138. Error starting at line : 83 in command -
  139. begin
  140. dbms_cloud.copy_data(
  141. table_name =>'TIMES',
  142. credential_name =>'OBJ_STORE_CRED',
  143. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/time_v3.dat',
  144. format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true', 'dateformat' value 'YYYY-MM-DD-HH24-MI-SS', 'blankasnull' value 'true')
  145. );
  146. end;
  147. Error report -
  148. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/time_v3.dat
  149. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  150. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  151. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  152. ORA-06512: at line 2
  153.  
  154.  
  155. Error starting at line : 94 in command -
  156. begin
  157. dbms_cloud.copy_data(
  158. table_name =>'COSTS',
  159. credential_name =>'OBJ_STORE_CRED',
  160. file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/costs.dat',
  161. format => json_object('ignoremissingcolumns' value 'true', 'dateformat' value 'YYYY-MM-DD', 'blankasnull' value 'true')
  162. );
  163. end;
  164. Error report -
  165. ORA-20401: Authorization failed for URI - https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/costs.dat
  166. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 757
  167. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1550
  168. ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 1573
  169. ORA-06512: at line 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!