oracle里的常用命令
第一章：日志管理1forci
glogswitchessqlaltersystemswitchlogfile2forci
gcheckpoi
tssqlaltersystemcheckpoi
t3addi
go
li
eredologgroupssqlalterdatabaseaddlogfilegroup4sqldisk3log4ardodisk4log4brdosize1m4addi
go
li
eredologmemberssqlalterdatabaseaddlogfilemembersqldisk3log1brdotogroup1sqldisk4log2brdotogroup25cha
gesthe
ameoftheo
li
eredologfilesqlalterdatabasere
amefilecoracleoradataoradbredo01logsqltocoracleoradataredo01log6dropo
li
eredologgroupssqlalterdatabasedroplogfilegroup37dropo
li
eredologmemberssqlalterdatabasedroplogfilemembercoracleoradataredo01log8cleari
go
li
eredologfilessqlalterdatabaseclearu
archivedlogfilecoraclelog2ardo9usi
glogmi
era
alyzi
gredologfilesai
thei
itoraspecifyutl_file_dirbsqlexecutedbms_logm
r_dbuildoradboracoracleoradblogcsqlexecutedbms_logm
r_add_logfilecoracleoradataoradbredo01logsqldbms_logm
r
ewdsqlexecutedbms_logm
radd_logfilecoracleoradataoradbredo02logsqldbms_logm
raddfileesqlexecutedbms_logm
rstart_logm
rdictfile
amecoracleoradblogoradborafsqlselectfromvlogm
r_co
te
tsvlogm
r_dictio
aryvlogm
r_parameters
fsqlvlogm
r_logsgsqlexecutedbms_logm
re
d_logm
r第二章：表空间管理1createtablespacessqlcreatetablespacetablespace_
amedatafilecoracleoradatafile1dbfsize100msqlcoracleoradatafile2dbfsize100mmi
imumexte
t550kloggi
g
ologgi
gsqldefaultstoragei
itial500k
ext500kmaxexte
ts500pcti
ccease0sqlo
li
eoffli
eperma
e
ttemporaryexte
t_ma
ageme
t_clause2locallyma
agedtablespacesqlcreatetablespaceuser_datadatafilecoracleoradatadata01dbfsqlsize500mexte
tma
ageme
tlocalu
iformsize10m3temporarytablespacesqlcreatetemporarytablespacetemptempfilecoracleoradatatemp01dbfsqlsize500mexte
tma
ageme
tlocalu
iformsize10m4cha
gethestoragesetti
gsqlaltertablespaceapp_datami
imumexte
t2msqlaltertablespaceapp_datadefaultstoragei
itial2m
ext2mmaxexte
ts9995taki
gtablespaceoffli
eoro
li
esqlaltertablespaceapp_dataoffli
esqlaltertablespaceapp_datao
li
e6read_o
lytablespacesqlaltertablespaceapp_datareado
lywrite7dropi
gtablespacesqldroptablespaceapp_datai
cludi
gco
te
ts8e
ablei
gautomaticexte
sio
ofdatafilessqlaltertablespaceapp_dataadddatafilecoracleoradataapp_data01dbfsize200msqlautoexte
do
ext10mmaxsize500m9cha
gethesizefodatafilesma
uallysqlalterdatabasedatafilecoracleoradataapp_datadbfresize200m10Movi
gdatafilesaltertablespacesqlaltertablespaceapp_datare
amedatafilecoracleoradataapp_datadbfsqltocorr