Re: impdp with table containing XMLTYPE on OCI

Stupid mistake on our part. The owner of that table has DBA granted to it on-prem, which isn't possible in OCI, resulting in some missing privileges.    

> On 11/22/2023 10:44 AM MST DOUG KUSHNER <dougk5_at_cox.net> wrote:
>
>
> 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-l