数据泵导入impdp参数如何映射到原始导入imp实用程序的参数

最新推荐文章于 2022-08-16 17:09:15 发布

allway2

最新推荐文章于 2022-08-16 17:09:15 发布

阅读量303

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.csdn.net/allway2/article/details/109697006

本文档概述了如何将旧版数据泵导入参数转换为新版，重点介绍了哪些参数已变更或不再适用，以及功能调整带来的影响。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

表3-2映射，尽可能将数据泵导入参数更改为原始导入参数。在某些情况下，由于重新设计了功能，不再需要原始的Import参数，因此没有数据泵命令可以与其进行比较。另外，如表中所示，某些参数名称可能相同，但功能略有不同。

表3-2数据泵导入中的原始导入参数及其对应项

Original Import Parameter	Comparable Data Pump Import Parameter
BUFFER	A parameter comparable to `BUFFER` is not needed.
CHARSET	A parameter comparable to `CHARSET` is not needed.
COMMIT	A parameter comparable to `COMMIT` is not supported.
COMPILE	A parameter comparable to `COMPILE` is not supported.
CONSTRAINTS	`EXCLUDE=CONSTRAINT`
DATAFILES	`TRANSPORT_DATAFILES`
DESTROY	`REUSE_DATAFILES`
FEEDBACK	`STATUS`
FILE	`DUMPFILE`
FILESIZE	Not necessary. It is included in the dump file set.
FROMUSER	`SCHEMAS`
FULL	`FULL`
GRANTS	`EXCLUDE=GRANT`
HELP	`HELP`
IGNORE	`TABLE_EXISTS_ACTION`
INDEXES	`EXCLUDE=INDEX`
INDEXFILE	`SQLFILE` with `INCLUDE` `INDEX`
LOG	`LOGFILE`
PARFILE	`PARFILE`
RECORDLENGTH	A parameter comparable to `RECORDLENGTH` is not needed.
RESUMABLE	A parameter comparable to `RESUMABLE` is not needed. It is automatically defaulted for privileged users.
RESUMABLE_NAME	A parameter comparable to `RESUMABLE_NAME` is not needed. It is automatically defaulted for privileged users.
RESUMABLE_TIMEOUT	A parameter comparable to `RESUMABLE_TIMEOUT` is not needed. It is automatically defaulted for privileged users.
ROWS=N	`CONTENT`=`METADATA_ONLY`
ROWS=Y	`CONTENT`=`ALL`
SHOW	`SQLFILE`
SKIP_UNUSABLE_INDEXES	`SKIP_UNUSABLE_INDEXES`
STATISTICS	A parameter comparable to `STATISTICS` is not needed. If the source table has statistics, they are imported.
STREAMS_CONFIGURATION	`STREAMS_CONFIGURATION`
STREAMS_INSTANTIATION	A parameter comparable to `STREAMS_INSTANTIATION` is not needed.
TABLES	`TABLES`
TABLESPACES	This parameter still exists, but some of its functionality is now performed using the `TRANSPORT_TABLESPACES` parameter.
TOID_NOVALIDATE	A command comparable to `TOID_NOVALIDATE` is not needed. OIDs are no longer used for type validation.
TOUSER	`REMAP_SCHEMA`
TRANSPORT_TABLESPACE	`TRANSPORT_TABLESPACES` (see command description)
TTS_OWNERS	A parameter comparable to `TTS_OWNERS` is not needed because the information is stored in the dump file set.
USERID	A parameter comparable to `USERID` is not needed. This information is supplied as the `username`/`password` when you invoke Import.
VOLSIZE	A parameter comparable to `VOLSIZE` is not needed because tapes are not supported.