Get the App
SLTechnology News&Howtos  ›  Database  › 

Data pump of Oracle imports / exports data

Shulou Source: shulou.com Published: 2022-06-01 13:48:45 10月04日 Update

Used to use imp/exp to import and export data, now let's do a data pump import and export method. It is needless to say that it has more advantages than imp/exp-faster!

But unfortunately, I made a mistake when exporting the data. Damn it, this is particularly embarrassing. As a result, the magic skill suddenly appeared, brother Kang is good at solving problems, isn't he?

Wow? At first glance, there is no one to report this mistake. I don't understand it at all. Don't be afraid, this kind of error report is a file problem, either permission or path related to the file, which means that the file does not exist inside the database, but I created it under the Oracle user.

It's no use. You have to create it inside the database. Oh, remember it's internal.

Come on, let's do it.

Come on, my friend, let's start our export data!

The problem was solved in this way. The same truth as IMPDP, I won't talk about it here.

Ps: when you encounter this kind of error that the error message is not obvious, keep calm, check step by step from the beginning, and you will eventually find a solution to the problem! Good luck!

Tags: Data problems files databases either obviously awkward needless to say unfortunately advantages information places that is ways schemes methods times friends permissions come on. Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi Shulou Information Microsoft NVidia Huawei