摘要：
Login as sysman user to the database and execute the following :execute MGMT_USER.MAKE_EM_USER('ARCER');//标红处为需要导出导入权限的用户的用户名备注:假如你没有开启SYSMAN用户，自行开启； 阅读全文
摘要：
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 阅读全文
摘要：
数据泵与原始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 阅读全文
摘要：
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 阅读全文
摘要：
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 阅读全文
摘要：
健康检查项目指标信息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... 阅读全文
摘要：
placeholder 阅读全文
摘要：
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 阅读全文
摘要：
参考博文:http://www.cnblogs.com/arcer/archive/2013/06/05/3119511.html 阅读全文
摘要：
合并于上一章节:http://www.cnblogs.com/arcer/archive/2013/06/05/3119511.html 阅读全文