oracle牛人笔记命令整理.pdf

《oracle牛人笔记命令整理.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle牛人笔记一命令第一章：日志管理____________________________________________________________2第二章：表空间管理__________________________________________________________3第三章：表__________________________________________________________________4第四章：索引______________________________

2、__________________________________5第五章：约束________________________________________________________________6第六章：LOAD数据___________________________________________________________7第七章：reorganizingdata______________________________________________________7第八章：man

3、agingpasswordsecurityandresources________________________________8第九章：Managingusers_______________________________________________________9第十章：managingprivilege_____________________________________________________9第十一章：managerrole____________________________

4、__________________________10第十二章:BACKUPandRECOVERY____________________________________________111第一章：日志管理1.forcinglogswitchessql>altersystemswitchlogfile;2.forcingcheckpointssql>altersystemcheckpoint;3.addingonlineredologgroupssql>alterdatabaseaddlogfile[gro

5、up4]sql>('/disk3/log4a.rdo','/disk4/log4b.rdo')size1m;4.addingonlineredologmemberssql>alterdatabaseaddlogfilemembersql>'/disk3/log1b.rdo'togroup1,sql>'/disk4/log2b.rdo'togroup2;5.changesthenameoftheonlineredologfilesql>alterdatabaserenamefile'c:/oracle/orada

6、ta/oradb/redo01.log'sql>to'c:/oracle/oradata/redo01.log';6.droponlineredologgroupssql>alterdatabasedroplogfilegroup3;7.droponlineredologmemberssql>alterdatabasedroplogfilemember'c:/oracle/oradata/redo01.log';8.clearingonlineredologfilessql>alterdatabaseclear

7、[unarchived]logfile'c:/oracle/log2a.rdo';9.usinglogmineranalyzingredologfilesa.intheinit.oraspecifyutl_file_dir=''b.sql>executedbms_logmnr_d.build('oradb.ora','c:oracleoradblog');c.sql>executedbms_logmnr_add_logfile('c:oracleoradataoradbredo01.log',sq

8、l>dbms_logmnr.new);2d.sql>executedbms_logmnr.add_logfile('c:oracleoradataoradbredo02.log',sql>dbms_logmnr.addfile);e.sql>executedbms_logmnr.start_logmnr(dictfilename=>'c:oracleoradblogor