You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How export schema tables if DB has an APEX workload type?

Received Response
4
Views
1
Comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!