Shulou(Shulou.com)05/31 Report--

Xiaobian to share with you how to use expdp/impdp to import the specified table space, I believe most people still do not know how to share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

I want to export all objects on Scott user. Now there is a new user A. The default table space of A is TBS_A. How to import Scott's data into TBS_A?

All right, you now need to import all of Scott's objects into user A.

1. Set dba_directory

2. expdp system/ DIRECTORY=datamove DUMPFILE=scott.dmp SCHEMAS=scott logfile=expdp.log

3. impdp system/ directory=datamove dumpfile=scott.dmp SCHEMAS=scott logfile=impdp.log remap_schema=scott:A

---------------

Processing object types SCHEMA_EXPORT/TABLE/TABLE

Processing object types SCHEMA_EXPORT/TABLE/TABLE_DATA

It's stuck at this point; what's going on?

--------------

Press Ctrl+C and enter status. You can see exactly what you are doing.

-------

Just press it once.

You now need to type: impdp / attach

Return to import>

Then enter status

That's all for "how to import a specified table space using expdp/impdp." Thanks for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.