How export schema tables if DB has an APEX workload type?
Summary:
If DB has an APEX workload type datapump can't be used.
Content (required):
I read several documents about datapump that is the main way to export data from a schema and reimport it in another schema. Unfortunatelly if DB has an APEX workload type, seems pretty impossible use datapump. External oracle client can't be used and I found some grant issues also with DBMS_CLOUD.CREATE_CREDENTIAL procedure.
Of course if data is not a lot I could use export in CSV or similar format and reimport data in someway but if tables have some LOBs this workaround doesn't work properly.
Tagged:
0