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

In this issue, the editor will bring you what matters needing attention about the IMPDP partition table. The article is rich in content and analyzes and describes for you from a professional point of view. I hope you can get something after reading this article.

1. Import user A's partition table par_table to user B and map to the new tablespace

Impdp dba01/dba01 directory=EXPIMP_DIR dumpfile=dmpfile_%U tables=a.par_table REMAP_SCHEMA=a:b REMAP_TABLESPACE=' (TBS1:NEWTBS1,TBS2:NEWTBS2)'

Pay attention to

1. It is best to use the sqlfile clause to confirm the content of the DDL statement before the actual import. The sqlfile clause only outputs the DDL statement in the DMP file, not the actual import.

The 2.transform=segment_attributes: n clause invalidates the REMAP_ TABLESPACEclause.

These are the notes of the IMPDP partition table shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are 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.