impdp的语法,请举出5个例子
时间: 2024-05-03 13:18:06 浏览: 166
1. 通过网络连接导入整个数据库:
```
impdp username/password@connect_string directory=dpump_dir network_link=source_db_link remap_schema=source_schema:target_schema
```
2. 导入指定的表:
```
impdp username/password@connect_string directory=dpump_dir tables=table1,table2,table3 remap_schema=source_schema:target_schema
```
3. 通过数据文件导入数据:
```
impdp username/password@connect_string directory=dpump_dir dumpfile=datafile.dmp logfile=logfile.log remap_schema=source_schema:target_schema
```
4. 只导入指定的数据:
```
impdp username/password@connect_string directory=dpump_dir tables=table1 query=where "column_name"='value' remap_schema=source_schema:target_schema
```
5. 导入指定的分区:
```
impdp username/password@connect_string directory=dpump_dir tables=table1 partition=partition_name remap_schema=source_schema:target_schema
```
阅读全文
相关推荐
![-](https://img-home.csdnimg.cn/images/20241231044833.png)
![-](https://img-home.csdnimg.cn/images/20241231045021.png)
![-](https://img-home.csdnimg.cn/images/20241231044833.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![doc](https://img-home.csdnimg.cn/images/20241231044833.png)
![docx](https://img-home.csdnimg.cn/images/20241231044901.png)
![txt](https://img-home.csdnimg.cn/images/20241231045021.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)