摘要：
Data Pump Export using Database ControlData Pump Export Example:Basic OptionsData Pump Export Example:Advanced OptionsData Pump Export Example:FilesData Pump Export Example:ScheduleData Pump Export Example:ReviewData Pump Import Example:impdpData Pump Import:Transformations在原来的导入导出过程中，假如导出的表所在表空间为sy 阅读全文
posted @ 2013-06-06 19:40
ArcerZhang
阅读(371)
评论(0)
推荐(0)
摘要：
Login as sysman user to the database and execute the following :execute MGMT_USER.MAKE_EM_USER('ARCER');//标红处为需要导出导入权限的用户的用户名备注:假如你没有开启SYSMAN用户，自行开启； 阅读全文
posted @ 2013-06-06 18:32
ArcerZhang
阅读(881)
评论(0)
推荐(0)
摘要：
Directory Object（目录对象）其拥有者是SYS；Directory Objects for Data PumpCreating Directory ObjectsData Pump Export and Import Clients :OverviewData Pump导出、导入原理：在导入、导出过程中，进程会创建一个Master Table来记录实时的导入、导出的状态信息，一旦导入、导出操作完成，这个Master Table便会被进程清除；Database link(DBLINK)实现Source与Target之间的直接导入导出工作.Data Pump Utility:Inte 阅读全文
posted @ 2013-06-06 18:09
ArcerZhang
阅读(154)
评论(0)
推荐(0)
摘要：
数据泵与原始Imp、exp命令比较Data pump是一个服务器端的工具;数据泵可以实现暂停功能;imp、exp是一个客户端的工具;Oracle Data Pump:OverviewAs a server-based facility for high-speed data and metadata movement,Oracle Data Pump:Is callable via DBMS_DATAPUMPProvides the following toolsexpdpimpdpWeb-based interfaceProvides four data movement methodsDa 阅读全文
posted @ 2013-06-06 16:53
ArcerZhang
阅读(201)
评论(0)
推荐(0)
摘要：
ObjectivesAfter completing this lesson,you should be able to:Describe ways to move dataCreate and use directory objectsUse SQL*Loader to load data from a non-Oracle database(or user files)Use external tables to move data via platform-independent filesExplain the general architecture of Oracle Data P 阅读全文
posted @ 2013-06-06 16:01
ArcerZhang
阅读(173)
评论(1)
推荐(0)
摘要：
The Data Recovery Advisor handles both cases:when you cannot start up the database (because some required database files are missing,inconsistent,or corrupted) and when file corruptions are discovered during run time.TrueFlaseWhich of the following checks can the Health Monitor Perform?Intuitive com 阅读全文
posted @ 2013-06-06 12:34
ArcerZhang
阅读(308)
评论(0)
推荐(0)
摘要：
健康检查项目指标信息SQL> select name,internal_check,offline_capable,description from v$hm_check order by 2,3;NAME I O DESCRIPTION------------------------------ - - ---------------------------------------------Transaction Integrity Check N N Checks a transaction for corruptionsDict... 阅读全文
posted @ 2013-06-06 12:30
ArcerZhang
阅读(158)
评论(0)
推荐(0)
摘要：
placeholder 阅读全文
posted @ 2013-06-06 12:22
ArcerZhang
阅读(264)
评论(0)
推荐(0)
摘要：
Automatic Diagnostic WorkflowAutomatic Diagnostic Repository查看ADR(Automatic Diagnositc Repository)方法有三:通过OEM support workbenchADRCI - ADR Command-Line(ADR命令行)V$DIAG_INFO(动态性能视图)The ADR Command-Line Tool(ADRCI)ADRCI procides interaction with ADR from an operating system prompt.Using ADRCI,you can vie 阅读全文
posted @ 2013-06-06 12:01
ArcerZhang
阅读(340)
评论(0)
推荐(0)
摘要：
参考博文:http://www.cnblogs.com/arcer/archive/2013/06/05/3119511.html 阅读全文
posted @ 2013-06-06 10:50
ArcerZhang
阅读(339)
评论(1)
推荐(0)
摘要：
合并于上一章节:http://www.cnblogs.com/arcer/archive/2013/06/05/3119511.html 阅读全文
posted @ 2013-06-06 10:48
ArcerZhang
阅读(155)
评论(0)
推荐(0)
摘要：
安装Oracle的时候碰到也是这样的问题，刚好在网上搜到了一篇很好的文章。转载在这里，给方便自己以后学习。 原文链接：http://www.iteye.com/problems/62745好像从oracle10开始，就没有enterprise console manager（有没有写错？）这个东西了，只能通过类似http://localhost:5500/em打开，于是打开http://localhost:5500/em，打不开，想到dbconsole可能没起动，于是在服务中启动，结果启动不了。于是做如下操作希望能启动。1、在cmd下，照网上资料：在命令行下输入 emctl start dbc 阅读全文
posted @ 2013-06-06 09:51
ArcerZhang
阅读(3404)
评论(0)
推荐(0)
浙公网安备 33010602011771号