Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Unable to impdp 200GB schema — Cloud Customer Connect
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

Received Response
9
Views
2
Comments
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!