impdp with table containing XMLTYPE on OCI
From: DOUG KUSHNER <dougk5_at_cox.net>
Date: Wed, 22 Nov 2023 10:44:36 -0700 (MST)
Message-ID: <2120737298.1844552.1700675076496_at_myemail.cox.net>
Any OCI DBAs in the house? We are just getting our feet wet in OCI with Oracle 19c Autonomous Database on dedicated Exadata.
Date: Wed, 22 Nov 2023 10:44:36 -0700 (MST)
Message-ID: <2120737298.1844552.1700675076496_at_myemail.cox.net>
Any OCI DBAs in the house? We are just getting our feet wet in OCI with Oracle 19c Autonomous Database on dedicated Exadata.
While running impdp (as admin user) to import an on-prem database to OCI, all tables containing an XMLTYPE column are raising an error:
ORA-39083: Object type TABLE:"OWNER"."TABLE_NAME" failed to create with error: ORA-01031: insufficient privileges
The column was originally CLOB, so we converted to SECUREFILE BINARY XML, but subsequent imports are still encountering this error. Any ideas would be appreciated.
Regards,
Doug
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 22 2023 - 18:44:36 CET