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

Editor to share with you how to export and import expdp and impdp tablespaces in oracle, I believe most people do not know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

[oracle@hr1 opt] $mkdir-p infor1

SQL > create directory scprd as'/ opt/infor1'

Directory created.

SQL > grant read,write on directory scprd to system

Grant succeeded.

[oracle@hr1 opt] $expdp system/oracle@HR dumpfile=tablespace_hr.dmp schemas=hr2 DIRECTORY=hr LOGFILE=hr2_exp.log

[oracle@hr1 opt] $impdp system/oracle@HR directory=hr dumpfile=tablespace_hr.dmp remap_schema=hr2:hr6, remap_tablespace=hr2_DATA:hr6_DATA logfile=hr6_imp.log

Use remap to realize the import of schema and tablespace.

Sometimes import reports an error:

Import: Release 11.2.0.3.0-Production on Sat Dec 23 23:18:22 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-29283: invalid file operation

ORA-06512: at "SYS.UTL_FILE", line 536

ORA-29283: invalid file operation

Just repeat it a few times.

These are all the contents of the article "how to export and import tablespaces for expdp and impdp in oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow 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.