Oracle数据库命令速查手册.pdf

《Oracle数据库命令速查手册.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、第一章：日志管理1.forcinglogswitchessql>altersystemswitchlogfile;2.forcingcheckpointssql>altersystemcheckpoint;3.addingonlineredologgroupssql>alterdatabaseaddlogfile[group4]sql>('/disk3/log4a.rdo','/disk4/log4b.rdo')size1m;4.addingonlineredologmemberssql>alterdatabaseaddlo

2、gfilemembersql>'/disk3/log1b.rdo'togroup1,sql>'/disk4/log2b.rdo'togroup2;5.changesthenameoftheonlineredologfilesql>alterdatabaserenamefile'c:/oracle/oradata/oradb/redo01.log'sql>to'c:/oracle/oradata/redo01.log';6.droponlineredologgroupssql>alterdatabasedroplogfileg

3、roup3;7.droponlineredologmemberssql>alterdatabasedroplogfilemember'c:/oracle/oradata/redo01.log';8.clearingonlineredologfilessql>alterdatabaseclear[unarchived]logfile'c:/oracle/log2a.rdo';9.usinglogmineranalyzingredologfilesa.intheinit.oraspecifyutl_file_dir=''b.sq

4、l>executedbms_logmnr_d.build('oradb.ora','c:oracleoradblog');c.sql>executedbms_logmnr_add_logfile('c:oracleoradataoradbredo01.log',sql>dbms_logmnr.new);d.sql>executedbms_logmnr.add_logfile('c:oracleoradataoradbredo02.log',sql>dbms_logmnr.addfile);e.sql>e

5、xecutedbms_logmnr.start_logmnr(dictfilename=>'c:oracleoradblogoradb.ora');f.sql>select*fromv$logmnr_contents(v$logmnr_dictionary,v$logmnr_parameterssql>v$logmnr_logs);g.sql>executedbms_logmnr.end_logmnr;第二章：表空间管理1.createtablespacessql>createtablespacets_namedat

6、afile'c:oracleoradatafile1.dbf'size100m,sql>'c:oracleoradatafile2.dbf'size100mminimumextent550k[logging/nologging]sql>defaultstorage(initial500knext500kmaxextents500pctinccease0)sql>[online/offline][permanent/temporary][extent_management_clause]2.locallymanag

7、edtablespacesql>createtablespaceuser_datadatafile'c:oracleoradatauser_data01.dbf'sql>size500mextentmanagementlocaluniformsize10m;3.temporarytablespacesql>createtemporarytablespacetemptempfile'c:oracleoradatatemp01.dbf'sql>size500mextentmanagementlocaluniforms

8、ize10m;4.changethestoragesettingsql>altertablespaceapp_dataminimumextent2m;sql>altertablespaceapp_datadefaultstorage(initial2mnext2mmaxextents999