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

This article mainly shows you "how to import and export in the database". The content is simple and easy to understand, and the organization is clear. I hope it can help you solve your doubts. Let Xiaobian lead you to study and learn "how to import and export in the database" this article.

----Import Export Command

create a directory

create directory BACKUP_DIR as '/app1/backup';

derived

expdp system/system@skdb directory=DUMP_DIR logfile=skkp_20170324.log dumpfile=skkp_20170324.dmp schemas=skkp

import

impdp system/MANAGER@suntx directory=BACKUP_DIR dumpfile=all.dmp logfile=all.log table_exists_action=replace TRANSFORM=SEGMENT_ATTRIBUTES:N

The above is "how to import and export database" all the contents of this article, thank you 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.