On premises database: 19.23
OCI: free account
Hi,
I'm trying to datapump export directly to object storage. The export starts but then fails. I have implemenetd the work around for 19.23 to get dbms_cloud to work.
In followed this blog
https://oracle-base.com/articles/21c/dbms_cloud-installation#install-dbms_cloud
DATA PUMP EXPORT TO OCI OBJECT STORAGE FAILED ORA-39001 ORA-39000 ORA-31641 (Doc ID 2806178.1)
Any help would be appreciated.
Credential created:
begin
dbms_credential.create_credential(
credential_name => 'obj_store_cred',
username => 'example@gmail.com',
password => 'auth token');
end;
/
SQL> select object_name
from dbms_cloud.list_objects(
'obj_store_cred',
'https://objectstorage.region/n/namespace/b/bucketname/o/'); 2 3 4
OBJECT_NAME
--------------------------------------------------------------------------------
exp_bucket.dmp
exp_bucket.dmp_aaaaaa
export
export/
private.txt
text.txt
toets_poets.lst
7 rows selected.
Export parfile:
schemas=hr
credential=obj_store_cred
dumpfile=https://objectstorage.region/n/axgjcu9ip0sw/b/bucketname/o/exp_bucket.dmp
logfile=dump:exp_bucket.log
exclude=statistics
Then export and error:
expdp hr/hr@//localhost:1521/ORCLPDB1 parfile=exp_bucket.par
Export: Release 21.0.0.0.0 - Production on Wed Jun 18 22:00:49 2025
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production
Starting "HR"."SYS_EXPORT_SCHEMA_03": hr/********@//localhost:1521/ORCLPDB1 parfile=exp_bucket.par
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
. . exported "HR"."SYS_EXPORT_SCHEMA_02" 671.2 KB 1705 rows
. . exported "HR"."SYS_EXPORT_SCHEMA_01" 502.1 KB 1694 rows
ORA-31693: Table data object "HR"."COUNTRIES" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLECLOSE callout
ORA-31644: unable to position to block number 321 in dump file "https://swiftobjectstorage.af-johannesburg-1.oraclecloud.com/v1/axgjcu9ip0sw/mig/exp_bucket.dmp"
ORA-19502: write error on file "https://swiftobjectstorage.af-johannesburg-1.oraclecloud.com/v1/axgjcu9ip0sw/mig/exp_bucket.dmp", block number 321 (block size=4096)
ORA-17500: ODM err:ODM Unauthorized
ORA-31693: Table data object "HR"."DEPARTMENTS" failed to load/unload and is being skipped due to error:
ORA-31644: unable to position to block number 323 in dump file "https://swiftobjectstorage.af-johannesburg-1.oraclecloud.com/v1/axgjcu9ip0sw/mig/exp_bucket.dmp"
ORA-19502: write error on file "https://swiftobjectstorage.af-johannesburg-1.oraclecloud.com/v1/axgjcu9ip0sw/mig/exp_bucket.dmp", block number 323 (block size=4096)
ORA-17500: ODM err:ODM Invalid Input