oracle数据库命令汇总

《oracle数据库命令汇总》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

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

2、filemembersql>'/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.dropon

3、lineredologmemberssql>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.buil

4、d('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>executedbms_logmnr.start_logmnr(dictfilen

5、ame=>'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>createtablespacetablespace_namedatafile'c:oracleoradatafile1.dbf'size100m,sq

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

7、eoradatauser_data01.dbf'sql>size500mextentmanagementlocaluniformsize10m;3.temporarytablespacesql>createtemporarytablespacetemptempfile'c:oracleoradatatemp01.dbf'sql>size500mextentmanagementlocaluniformsize10m;4.changethestoragesettingsql>altertablespaceapp_dataminimumexten

8、t2m;sql>altertablespaceapp_datadefaultstorage(initial2