Oracle导入导出提示EXP0006消失内部不全都的错误会决方法.docx
- 文档编号:17900651
- 上传时间:2023-08-04
- 格式:DOCX
- 页数:6
- 大小:16.42KB
Oracle导入导出提示EXP0006消失内部不全都的错误会决方法.docx
《Oracle导入导出提示EXP0006消失内部不全都的错误会决方法.docx》由会员分享,可在线阅读,更多相关《Oracle导入导出提示EXP0006消失内部不全都的错误会决方法.docx(6页珍藏版)》请在冰点文库上搜索。
Oracle导入导出提示EXP0006消失内部不全都的错误会决方法
Oracle导入导出提示EXP-0006:
消失内部不全都的错误会决方法_
exp、imp是ORACLE幸存的最古老的两个操作系统指令行工具,导入(IMP)/导出(EXP),昨天在Oracle用exp、imp导入导出报EXP-0006:
消失内部不全都的错误。
以前用exp、imp导库指令胜利的实现了Oracle数据库的导出、导入,对此,昨天再对服务器新安装的Oracle数据库用exp、imp导库,始终报“EXP-0006:
消失内部不全都的错误”,于是在网上XX,尝试其他导库方式,发觉采纳expdp、impdp数据泵同样可以完成数据库的导出、导入,而且数据泵与传统导出导入有如下区分:
1.EXP和IMP是客户段工具程序,EXPDP和IMPDP是服务端的工具程序;
2.EXP和IMP效率比较低.EXPDP和IMPDP效率高;
3.数据泵功能强大并行、过滤、转换、压缩、加密、交互等等;
4.数据泵不支持9i以前版本,EXP/IMP短期内还是比较适用;
5.同exp/imp数据泵导出包括导出表,导出方案,导出表空间,导出数据库4种方式。
有了理论支持,下面开头实战。
expdp导出Oracle数据库
1.在sqlplus下创建Directory,优点在于让我们可以在Oracle数据库中敏捷的对文件进行读写操作,极大的提高了Oracle的易用性和可扩展性。
指令:
createdirectoryoracleDBas'D:
\OracleDB';
2.把读写权限授予特定用户
指令:
Grantread,writeondirectoryoracleDBtoradpcs;
3.在dos窗口执行expdp导出指令
指令:
expdpdirectory=oracleDBdumpfile=20210226.dmplogfile=20210226.logFULL=y;
到此导出工作完成,下面讲解如何用impdp导入Oracle数据库。
impdp导入Oracle数据库
1.以sysdba级别登录Oracle数据库
指令:
--sqlplus/nolog
--connassysdba
2.创建数据表空间
指令:
--创建数据表空间
CREATETABLESPACERADPCS_DATA
LOGGING
DATAFILE'D:
\OracleDB\radpcs_DATA.DBF'SIZE200MREUSEAUTOEXTEND
ONNEXT10MMAXSIZE16383MEXTENTMANAGEMENTLOCALUNIFORM
SIZE1024K;
--创建索引表空间
CREATETABLESPACERADPCS_INDX
LOGGING
DATAFILE'D:
\OracleDB\radpcs_INDX.DBF'SIZE200MREUSEAUTOEXTEND
ONNEXT10MMAXSIZE16383MEXTENTMANAGEMENTLOCALUNIFORM
SIZE1024K;
这步很关键,创建的表空间需要和原Oracle表空间名称、个数相同,否则会导入失败。
假如不知道原表空间名称、个数,就先创建一个临时的表空间进行导入,导入过程中依据错误提示,比如“RADPCS1_DATA表空间不存在”提示,缺哪个创建哪个。
3.创建用户、对用户授权
--创建用户
createuserradpcsidentifiedbyictradpcs
defaulttablespaceradpcs_data
quotaunlimitedonradpcs_data
quotaunlimitedonradpcs_indx;
--授权
grantaq_administrator_roletoradpcs;
grantaq_user_roletoradpcs;
grantauthenticatedusertoradpcs;
grantconnecttoradpcs;
grantctxapptoradpcs;
grantdbatoradpcs;
grantdelete_catalog_roletoradpcs;
grantejbclienttoradpcs;
grantexecute_catalog_roletoradpcs;
grantexp_full_databasetoradpcs;
grantgather_system_statisticstoradpcs;
granths_admin_roletoradpcs;
grantimp_full_databasetoradpcs;
grantjavadebugprivtoradpcs;
grantjavaidprivtoradpcs;
grantjavasysprivtoradpcs;
grantjavauserprivtoradpcs;
grantjava_admintoradpcs;
grantjava_deploytoradpcs;
grantlogstdby_administratortoradpcs;
grantoem_monitortoradpcs;
grantolap_dbatoradpcs;
grantrecovery_catalog_ownertoradpcs;
grantresourcetoradpcs;
grantselect_catalog_roletoradpcs;
grantxdbadmintoradpcs;
--Grant/Revokesystemprivileges
grantadministerdatabasetriggertoradpcs;
grantalteranyclustertoradpcs;
grantalteranydimensiontoradpcs;
grantalteranyindextoradpcs;
grantalteranyindextypetoradpcs;
grantalteranylibrarytoradpcs;
grantalteranyoutlinetoradpcs;
grantalteranyproceduretoradpcs;
grantalteranyroletoradpcs;
grantalteranysequencetoradpcs;
grantalteranysnapshottoradpcs;
grantalteranytabletoradpcs;
grantalteranytriggertoradpcs;
grantalteranytypetoradpcs;
grantalterdatabasetoradpcs;
grantalterprofiletoradpcs;
grantalterresourcecosttoradpcs;
grantalterrollbacksegmenttoradpcs;
grantaltersessiontoradpcs;
grantaltersystemtoradpcs;
grantaltertablespacetoradpcs;
grantalterusertoradpcs;
grantanalyzeanytoradpcs;
grantauditanytoradpcs;
grantauditsystemtoradpcs;
grantbackupanytabletoradpcs;
grantbecomeusertoradpcs;
grantcommentanytabletoradpcs;
grantcreateanyclustertoradpcs;
grantcreateanycontexttoradpcs;
grantcreateanydimensiontoradpcs;
grantcreateanydirectorytoradpcs;
grantcreateanyindextoradpcs;
grantcreateanyindextypetoradpcs;
grantcreateanylibrarytoradpcs;
grantcreateanyoperatortoradpcs;
grantcreateanyoutlinetoradpcs;
grantcreateanyproceduretoradpcs;
grantcreateanysequencetoradpcs;
grantcreateanysnapshottoradpcs;
grantcreateanysynonymtoradpcs;
grantcreateanytabletoradpcs;
grantcreateanytriggertoradpcs;
grantcreateanytypetoradpcs;
grantcreateanyviewtoradpcs;
grantcreateclustertoradpcs;
grantcreatedatabaselinktoradpcs;
grantcreatedimensiontoradpcs;
grantcreateindextypetoradpcs;
grantcreatelibrarytoradpcs;
grantcreateoperatortoradpcs;
grantcreateproceduretoradpcs;
grantcreateprofiletoradpcs;
grantcreatepublicdatabaselinktoradpcs;
grantcreatepublicsynonymtoradpcs;
grantcreateroletoradpcs;
grantcreaterollbacksegmenttoradpcs;
grantcreatesequencetoradpcs;
grantcreatesessiontoradpcs;
grantcreatesnapshottoradpcs;
grantcreatesynonymtoradpcs;
grantcreatetabletoradpcs;
grantcreatetablespacetoradpcs;
grantcreatetriggertoradpcs;
grantcreatetypetoradpcs;
grantcreateusertoradpcs;
grantcreateviewtoradpcs;
grantdebuganyproceduretoradpcs;
grantdebugconnectsessiontoradpcs;
grantdeleteanytabletoradpcs;
grantdropanyclustertoradpcs;
grantdropanycontexttoradpcs;
grantdropanydimensiontoradpcs;
grantdropanydirectorytoradpcs;
grantdropanyindextoradpcs;
grantdropanyindextypetoradpcs;
grantdropanylibrarytoradpcs;
grantdropanyoperatortoradpcs;
grantdropanyoutlinetoradpcs;
grantdropanyproceduretoradpcs;
grantdropanyroletoradpcs;
grantdropanysequencetoradpcs;
grantdropanysnapshottoradpcs;
grantdropanysynonymtoradpcs;
grantdropanytabletoradpcs;
grantdropanytriggertoradpcs;
grantdropanytypetoradpcs;
grantdropanyviewtoradpcs;
grantdropprofiletoradpcs;
grantdroppublicdatabaselinktoradpcs;
grantdroppublicsynonymtoradpcs;
grantdroprollbacksegmenttoradpcs;
grantdroptablespacetoradpcs;
grantdropusertoradpcs;
grantexecuteanyindextypetoradpcs;
grantexecuteanylibrarytoradpcs;
grantexecuteanyoperatortoradpcs;
grantexecuteanyproceduretoradpcs;
grantexecuteanytypetoradpcs;
grantflashbackanytabletoradpcs;
grantforceanytransactiontoradpcs;
grantforcetransactiontoradpcs;
grantglobalqueryrewritetoradpcs;
grantgrantanyobjectprivilegetoradpcs;
grantgrantanyprivilegetoradpcs;
grantgrantanyroletoradpcs;
grantinsertanytabletoradpcs;
grantlockanytabletoradpcs;
grantmanagetablespacetoradpcs;
grantoncommitrefreshtoradpcs;
grantqueryrewritetoradpcs;
grantrestrictedsessiontoradpcs;
grantresumabletoradpcs;
grantselectanysequencetoradpcs;
grantselectanytabletoradpcs;
grantunderanytabletoradpcs;
grantunderanytypetoradpcs;
grantunderanyviewtoradpcs;
grantunlimitedtablespacetoradpcs;
grantupdateanytabletoradpcs;
grantselectondba_free_spacetoradpcs;
grantselectondba_data_filestoradpcs;
4.在sqlplus下创建Directory
指令:
createdirectoryoracleDBas'D:
\OracleDB';
5.把读写权限授予特定用户
指令:
Grantread,writeondirectoryoracleDBtoradpcs;
6.在dos窗口执行impdp导入指令
指令:
impdpdirectory=oracleDBdumpfile=20210226.dmplogfile=20210226.log;
漫长的等待后,dos窗口会提示导出完成。
假如导入过程出错,会提示错误信息(只要数据完整,一些错误可以忽视)。
更多信息请查看IT技术专栏
...
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle 导入 导出 提示 EXP0006 消失 内部 不全 错误 方法
![提示](https://static.bingdoc.com/images/bang_tan.gif)