oracle数据库命令速查手册

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

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

2、sql>'/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>alterdatabasedroplogfilegroup3;7.droponlineredo

3、logmemberssql>alterdatabasedroplogfilemember'c:/oracle/oradata/redo01.log';8.clearingonlineredologfilessql>alterdatabaseclear[unarchived]logfile'c:/oracle/log2a.rdo';9.usinglogmineranalyzingredologfilesa.intheinit.oraspecifyutl_file_dir=''b.sql>executedbms_logmnr_d.build('ora

4、db.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>executedbms_logmnr.start_logmnr(dictfilename=

5、>'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_namedatafile'c:oracleoradatafile1.dbf'size100m,sql>'c:orac

6、leoradatafile2.dbf'size100mminimumextent550k[logging/nologging]sql>defaultstorage(initial500knext500kmaxextents500pctinccease0)sql>[online/offline][permanent/temporary][extent_management_clause]2.locallymanagedtablespacesql>createtablespaceuser_datadatafile'c:oracleoradat

7、auser_data01.dbf'sql>size500mextentmanagementlocaluniformsize10m;3.temporarytablespacesql>createtemporarytablespacetemptempfile'c:oracleoradatatemp01.dbf'sql>size500mextentmanagementlocaluniformsize10m;4.changethestoragesettingsql>altertablespaceapp_dataminimumextent2m;sq

8、l>altertablespaceapp_datadefaultstorage(initial2mnext2mmaxextents999