首页 » ORACLE 9i-23c » impdp 与 imp区别

impdp 与 imp区别

  • 2012/05/10
  • ORACLE 9i-23c
  • 1,195 views
  • impdp 与 imp区别已关闭评论

今天刚遇到了这个问题：impdp 如果不导入权限？看了下impdp参数没有了grants选项，看了些文档发现还是除了data dump 必需要在服务端执行个参数上还是有一定区别的

放上官方的对照表

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.

note:

所以排除授权

impdp   anbob/anbob directory=xxx datafile=xxx  EXCLUDE=grant

排除用户 exclude=user,排除外键exclude=ref_constraint,还有exclude=view,package,function…

imp 是要在导入前先有dba创建用户才可以导入，impdp 是将会recreate 数据库的用户，还有grant,应用以前的password,impdp的parallel特性是动态的，并且impdp的转储格式是xml.

打赏

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：