Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Unable to impdp 200GB schema

edited Jun 17, 2019 8:32AM in Autonomous Database 2 comments

Summary

impdp hangs but works for smaller tables

Content

Hi everyone, I have just joined the Oracle Cloud environment last week and is now trying the ADW out.

I transferred 200GB (split into 32files, 5gb each) up to my object storage and tried to impdp using native object storage URI. But when I try to import the whole schema it hangs and disconnect after some time. When I do smaller tables it is fine... is this a limitation of Oracle Cloud Infrastructure or am I doing something wrong? Any advice is appreciated.

Thanks guys.

Regards,

Matthew

Version

18.2

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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