Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Perform FULL DB Export datapump from SQLDEVELOPER

CooldbaDec 2 2018 — edited Dec 3 2018

Hi Experts,

We have several application teams would like to migrate the on-premise database to cloud and want to leverage the datapump from application/middle-tier to migrate the small databases upto 200G size.

As part of this migration that application wants to manage, they have options to migrate either schema level or database level export and import using datapump utility

My Questions are:

1. What are various methods available for application users to migrate the database without help of a DBA or without SYSDBA privilege?

2. Can SQLDEVELOPER from middle tier be leveraged for both Schema Level and DB(Full) export/import?

3. Does SQLDEVELOPER writes dump file locally in the middle-tier or db tier?

4. Can we perform direct import in the target connecting to source using DBLINK to cloud DB?

5. Any other best practices

Please share your valuable suggestions and inputs

Thanks in advance
Nanda

Comments

TomBlakeley

Hi,

How many LDAP directories do you have access to via Shared Services? I've seen issues where 5+ directories caused latency when logging in.

Did you perform any of the database tuning steps when first configuring FDM?

http://docs.oracle.com/cd/E12825_01/epm.111/fdm_dba.pdf

1 - 1