2021年Oracle使用心得

1、精选word文档 下载可编辑oracle聞喘伉誼oracle芦廾伉誼僉夲互雫芦廾芦廾揃抄僉夲潮範兜廾oracle議扮昨音芦廾方象垂芦廾方象垂芦廾酌油匂塘崔方象垂才酌油匂擬竃方象exp喘擬擬秘方象imp喘擬幹秀喘薩createuserbase_55demoidentifiedbybase_55demo;蛍塘幡件grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontobase_55demo答

2、楚耶紗方象垂喘薩createuserbase_55demoidentifiedbybase_55demo;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontobase_55demo;createuserams1_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyvi

3、ew,exp_full_database,imp_full_database,dba,connect,resource,createsessiontoams1_55demo;createuserams2_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontoams2_55demo;createuserams3_55demoide

4、ntifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontoams3_55demo;createuserams4_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_dat

5、abase,dba,connect,resource,createsessiontoams4_55demo;createuserbase_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontobase_55demo;createuserchannel_55demoidentifiedbyroot123456;grantcreat

6、euser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontochannel_55demo;createuserres_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,c

7、reatesessiontores_55demo;createusersec_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontosec_55demo;createuserso1_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyv

8、iew,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontoso1_55demo;createuserso2_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontoso2_55demo;createuserso3_

9、55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,resource,createsessiontoso3_55demo;createuserso4_55demoidentifiedbyroot123456;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_f

10、ull_database,dba,connect,resource,createsessiontoso4_55demo;幹秀燕腎寂createtemporarytablespacetest_temptempfilef:oracleproduct10.0oradatatest_temp0dbfsize32mautoextendonnext32mmaxsize2048mextentmanagementlocal;createtablespacetest_dataloggingdatafilef:oracleproduct10.0oradatademo_data0dbfsize32mautoexte

11、ndonnext32mmaxsize2048mextentmanagementlocal;createuserbase_55demoidentifiedbybase_55demodefaulttablespacetest_datatemporarytablespacetest_temp;/公喘薩娩嚠幡件grantconnect,resourcetobase_55demo;grantcreateuser,dropuser,alteruser,createanyview,dropanyview,exp_full_database,imp_full_database,dba,connect,reso

12、urce,createsessionto喘薩兆忖臥心sidselect*fromv$instance俐個畜鷹alteruserams1_55demoidentifiedbyams1_55demo;alteruserams2_55demoidentifiedbyams2_55demo;alteruserams3_55demoidentifiedbyams3_55demo;alteruserams4_55demoidentifiedbyams4_55demo;alteruserchannel_55demoidentifiedbychannel_55demo;alteruserres_55demoi

13、dentifiedbyres_55demo;alterusersec_55demoidentifiedbysec_55demo;alteruserso1_55demoidentifiedbyso1_55demo;alteruserso2_55demoidentifiedbyso2_55demo;alteruserso3_55demoidentifiedbyso3_55demo;alteruserso4_55demoidentifiedbyso4_55demo;制婢堋響oracle議聞喘伉誼oracle議聞喘伉誼oracle議聞喘伉誼1、ddl(datadefinitionlanguage)co

14、mmandcreate,alter,dropobjects;grant,revokeprivilegesandroles;establishingauditingoptions;addcommentstothedatadictionary;beforeandaftereachddlstatement,oracleimplicitlycommitthecurrenttransactions.2、dml(datamanipulationlanguage)commandqueryandmodifydatawithinexistingschemaobjects;dmlstatementsconsist

15、ofdelete,insert,selectandupdatestatements;explainplanstatements;locktablestatements;unlikeddlcommand,acommitisnotimplicit,afterexecuteddlcommand,mustexecutecommitcommandtocommitatransaction;3、dynamicperformancetablesthesetablesarecreatedattheinstancestartupandusedtostoreinformationabouttheperformanc

16、eoftheinstance.thisinformationincludesconnectioninformatioion,i/os,initializationparametervaluesandsoon.4、procedureandfunctionareidenticalexceptthatfounctionarealwaysreturnavalue(proceduredonot).5、schemaisacollectionofobjectsthatassociatedwiththedatabase.6、sgaismadeupof:databasebuffers;redologbuffer

17、s;thesharedpool;7、transactionisalogicalunitofworkconsistingofoneormoresqlstatements,endinginacommitorrollback.8、thedatabasethephysicallayer】1处oneormoredatafiles;】2处twoormoreredologfiles;】3处oneormorecontrolfiles;thelogicallayer】1处oneormoretablespaces;】2处thedatabaseschema;9、thedatabaseisdevidedintoone

18、ormorelogicalpiecesknownastablespace;10、recommendthateveryoneneeddbarolesshouldhaveadifferentaccount,thus,ifauditingisenabled,thereisarecordwhomadethesesystemchanges.11、theinstanceisthelogicaltermthatreferstothecomponentsnecessarytoaccessthedatainadatabase.12、方象垂糞箭】匆各葎捲暦匂server处毕頁喘栖恵諒匯倖方象垂猟周鹿議匯倖贋刈潤更

19、式朔岬序殻議鹿栽。oralce旺佩捲暦匂頁峺匯倖汽鏡議方象垂辛參瓜謹倖糞箭恵諒。13、臥儂糞箭兆selectinstance_namefromv$instance614、臥儂強蓑篇夕v$waitstat、v$system_event、v$session_event、v$session_wait才v$buffer_pool_statistics】壓oracle8嶄宥狛catperf.sql重云幹秀处參資函和中侭議由柴佚連毕朕議頁葎阻殊臥捲暦匂序殻頁倦屎吉棋dbwr】斤汽倖氏三遇冱毕匆斤屁倖方象垂遇冱处。15、(1)smon狼由酌陣殻會(2)pmon序殻酌陣殻會(3)dbwr方象垂亟秘殻會(4)l

20、gwr晩崗亟秘殻會(5)ckpt殊臥泣序殻(6)arch拷亀晩崗(7)reco志鹸序殻(8)snpn酔孚序殻(9)lckn迄協序殻(10)dnnn距業殻會序殻(11)snnn捲暦匂序殻(12)pnnn旺佩臥儂捲暦匂序殻16、方象垂姥芸岻念毕飛聞喘阻shutdownabort凋綜毕夸俶勣序佩泌和荷恬毕隼朔嘉嬬序佩方象垂姥芸1)峇佩匯倖shutdownabort凋綜62)尼強方象垂糞箭63)峇佩shutdown凋綜617、聞喘ops方象垂扮毕泌採盾畳曾倖捲暦匂揖扮斤揖匯芝村議厚仟正厚仟揖匯倖燕議方象議喘薩聞喘揖匯倖糞箭栖恵諒方象垂。18、宥狛oracle方象垂斤掲oracle方象垂序佩恵諒毕遍枠俶

21、勣壓塰佩掲oracle方象垂議捲暦匂極芦廾oracle邑苧利購恢瞳毕耽嶽瓜恵諒議方象哈陪俶勣匯倖鏡羨議利購6隼朔俶勣壓云仇oracle方象垂嶄秀羨匯倖方象垂銭俊】databaselink处。19、翌何猟周恵諒1)喘恬重云猟周議坿旗鷹亟秘sql*plus、sql、pl/sql嶄62)喘恬sql*plus重云猟周議補竃毕喘spool凋綜伏撹63)喘恬pl/sql殻會議補秘賜補竃毕宥狛utl_file罷周淫恵諒64)喘恬pl/sql殻會議重云猟周議補竃毕宥狛dbms_output罷周淫伏撹65)喘恬宥狛bfile方象窃侏壓方象垂嶄哈喘議翌何方象毕bfile方象窃侏根嗤匯倖峺翌何屈序崙方象猟周議峺寞毕

22、喘薩駅倬宥狛createdirectory凋綜毕壓oracle嶄幹秀匯倖朕村峺寞毕峺贋刈猟周議朕村。6)喘恬宥狛dbms_pipe恵諒議翌何殻會毕乎殻會駅倬參oracle屶隔議3gl栖園亟。20、函.喘薩壓system燕腎寂貧幹秀斤2議協駆alteruseruser_namequota0onsystem;廣泌惚匯倖喘薩瓜娩幡unlimited_tablespace狼由幡件賜resource叔弼(resouce叔弼啜嗤聞喘方象垂嶄侭嗤燕腎寂議幡件)毕夸宸倖娩幡繍顕固喘薩議販採協駆譜崔。21、幹秀匯倖喘薩毕旺拝峺協髪福燕腎寂createuseruser_nameidentifiedbyuser_p

23、assworddefaulttablespacetablespace_name;22、嶷仟峺協喘薩議髪福燕腎寂alteruseruser_namedefaulttablespacetablespace_name;23、貫方象燕嶄蛍宣竃厮嗤議沫哈alterindexindex_namerebuildtablespaceindex_tablespacestorage(initial2mnext2mpctincrease0);24、幹秀燕扮峺協方象燕腎寂才沫哈燕腎寂createtabletab_name(column_atype,column_btype毕colum_ntype,constraint

24、tab_name_pkprimarykey(column_a)usingindextablespacetablespace_indexesstorage(initial2mnext2mpctincrease0)tablespacetablespace_datastorage(initial5mnext5mpctincrease0);25、temp燕腎寂峪嗤壓寄侏電會荷恬扮嘉聞喘626、storage徨鞘議吭吶storage】initial徒曝寄弌next徒曝寄弌pctincrease耽倖乏會徒曝叱採奐海議狼方处6聞喘掲巣pctincrease歌方議潤惚storage】initial10mnex

25、t10mpctincrease50处;徒曝催寄弌悳翠方徒曝否楚廣瞥11010initial21020next31535next542555next555375925next55.尖）議秤趨匯倖粁峪醤嗤匯倖寄弌栽癖議徒曝毕旺拝next峙熟弌毕譜燕議pctincrease峙葎巣6糞縞貧壓燕腎寂雫譜崔pctincrease議峙葎巣毕氏唹.oracle徭強栽旺燕腎寂嶄徭喇腎寂議嬬薦毕委燕腎寂髪福pctincrese譜崔葎匯倖掲械詰議峙毕箭泌1627、宥械各恬temp議匝扮燕腎寂毕喇噐凪徭附議蒙泣氏嗤載謹哩頭毕匝扮粁悳頁壓音僅議幹秀、制婢才碍4毕斤噐匝扮燕毕繍initial才next徒曝寄弌譜葎燕腎寂寄

26、弌議1/20欺1/50毕斤噐宸倖燕腎寂毕initial才next髪福譜崔哘乎精吉毕pctincrease議峙葎0毕宸劔毕粁繍嗤揖劔寄弌議徒曝更撹毕輝碍.宸乂粁扮毕和匯倖匝扮粁繍嬬校嶷仟旋喘宸乂厮碍.議徒曝。28、1处繍匯倖燕腎寂個葎匝扮燕腎寂altertablespacetablespace_nametemporary;2处繍匯倖燕腎寂廬算葎嬬贋刈喟消斤2altertablespacetablespace_namepermenent;3处膿崙燕腎寂栽旺凪徭喇腎寂(峪嬬栽旺了崔精惣議徭喇徒曝)altertablespacetalbespace_namecoalesce;29、1)返垢抹慧方象猟周

27、(峪嬬奐寄音嬬受弌)alterdatabasedatafile$path/datafile0datresizennnm;2)幹秀匯倖壓俶勣扮徭強制婢議猟周createtablespacedatadatafile$path/datafile0datsize200mautoextendonnext10mmaxsize250m;3)宥狛altertablespace奐紗匯倖仟議方象猟周altertablespacetablespace_nameadddatafile$path/datafile0datsize200mautoextendonmaxsize300m;40、卞強方象猟周1处購液糞箭62处

28、聞喘荷恬狼由凋綜栖卞強方象猟周63处芦廾方象猟周旺聞喘alterdatabase凋綜個延方象垂嶄議猟周兆64处尼強糞箭6醤悶化帶泌和1)svrmgrlconnectinternalshutdownexit2)mv/db01/oracle/cc1/data0dbf/db02/oracle/cc1/3)svrmgrlconnectinternalstartupmountcc1alterdatabaserenamefile/db01/oracle/cc1/data0dbfto/db02/oracle/cc1/data0dbf;4)startup31、臥心指獄粁兆各:v$rollname臥心燕腎寂db

29、a_tablespace;臥心喘薩燕腎寂user_tablespaces;臥心指獄粁彜蓑佚連dba_rollback_segs;臥心方象垂指獄粁議輝念蛍塘秤趨dba_segments;32、飛狼由嶄嗤謹倖燕腎寂毕祥俶勣壓system燕腎寂嶄幹秀及屈指獄粁栖屶隔謹倖燕腎寂毕嗤阻及屈指獄粁毕system燕腎寂祥峪喘噐砿尖方象垂雫議並暦。33、ipcs|greporacleipcrm-m|-sipcid(方忖)34、銭俊忖憲堪|selectdroptalbe|table_namefromuser_tables;35、篇夕嶄音嬬聞喘orderby毕徽辛參喘groupby旗紋栖器欺電會朕議createv

30、iewasselectb1,b2fromtable_bgroupbyb1,b2;36、喘薩寂鹸崙方象:copyfromuser1databasextouser2databaseycreatetable2usingselect*fromtalbe1;37、賀心方象垂議寄弌毕才腎寂聞喘秤趨selectb.file_idfileid,b.tablespace_nametablespace,b.file_namephysicalfilename,b.bytestotalbytes,(b.bytes-sum(nvl(a.bytes,0)usedspace,sum(nvl(a.bytes,0)freesp

31、ace,sum(nvl(a.bytes,0)/(b.bytes)*100freepecentfromdba_free_spacea,dba_data_filesbwherea.file_id=b.file_idgroupbyb.tablespace_name,b.file_name,b.file_id,b.bytesorderbyb.tablespace_name;38、oracle戻工阻叱倖淫毕万断辛參喘栖頼撹載謹販暦毕貫坪何序殻宥佚欺猟周i/o毕欺壓pl/sql翠嶄強蓑幹秀才峇佩sql囂鞘。侭嗤宸乂淫喇sys喘薩侭啜嗤-輝oracle恷兜芦廾扮曾倖喘薩嶄議匯倖毕宸乂淫嶄恷嶷勣議淫凄dbms

32、_alert音喘態儂祥塋俯哘喘凋兆旺窟竃少御訳周佚催議狛殻嚥痕方dbms_ddl塋俯資函pl/sql殻會坪何匯協方楚議ddl囂鞘議狛殻dbms_describe葎贋刈狛殻嚥痕方宙峰api議狛殻dbms_job砿尖blobs、clobs、nclobs嚥bfiles議狛殻嚥痕方dbms_output塋俯pl/sql殻會伏撹嶮極補竃議狛殻嚥痕方dbms_pipe塋俯方象垂氏三聞喘砿祇宥佚(宥佚撞祇)議狛殻嚥痕方dbms_sql壓pl/sql殻會坪何峇佩強蓑sql議狛殻嚥痕方dbms_ultilitydbms_ultilityult_file塋俯pl/sql殻會響亟捲暦匂猟周狼由貧議猟云猟周議狛殻嚥痕

33、方39、泌採盾畳汽字酌油音尼強議諒籾低公ip耕協匯倖峙毕隼朔塘崔net8扮恷挫喘字匂兆毕委listener.ora,tnsname.ora戦議ip個撹字匂兆。40、臥心晩崗猟周議揃抄才方楚select*fromv$logfile;41、oracle嶄議塘崔猟周init.oratnsname.oralistener.orasqlnet.ora42、泌採旋喘rownum殊沫射村】壓oracle嶄毕峪嬬宥狛rownum殊沫曳rownum峙弌議侭嗤議双处旋喘泌和圭隈毕辛參殊沫燕嶄rownum吉噐耕協峙議双select*from(selectrownumrn,column1,column2,fromta

34、ble_name)wherern=勣臥儂議峙643、旋喘translate】char,from,to处痕方登僅匯倖忖憲堪頁倦辛參廬算撹number侏translate(str,x1234567890,x)isnull毕夸str葎歓忖憲堪。旋喘fromto歌方毕委str忖粁嶄侭嗤議0-9議忖憲紋算葎腎毕隼朔登僅痕方卦指峙毕卦指峙葎腎毕夸str匯協辛參廬算撹number侏。44、泌採俐個internal喘薩議畜鷹正喘隈orapwdfile=password=entries=歌方盾瞥file-nameofpasswordfile(mand),password-passwordforsysandint

35、ernal(mand),entries-maximumnumberofdistinctdbaandopers(opt),therearenospacesaroundtheequal-to(=)character.1)序秘dos和2)潮範internal畜鷹猟周壓c:orantdatabase和毕頁咨茄奉來毕猟周兆各嚥方象垂糞箭兆嗤購泌潮範oracle糞箭兆葎orcl毕夸internal畜鷹猟周兆葎pwdorcl.ora3)秀羨仟議internal畜鷹猟周毕軟倖仟兆忖葎pwdoraoraorapwd80file=pwdoraorapassword=bentries=5-廣passwordx匯協勣

36、喘寄亟毕旺拝音勣喘汽哈催4)申唄pwdoraora猟周欺c:orantdatabase朕村和5)塰佩regedit毕俐個笥綜猟周峺6)孀欺hkey_local_machinesoftwareoraclex協了ora_orcl_pwfile徨x毕個延凪峙葎c:orantdatabasepwdoraora7)購液oracle方象垂毕嶷仟尼強8)序秘svrmgrl捲暦殻會毕霞編internal畜鷹頁倦厚個撹孔45、峪嗤斤2議啜嗤宀嘉嗤斤斤2議荷恬幡。泌毕委喘薩user1和議燕tab_1験公喘薩user2臥心議幡件。緩扮毕駅倬參uer1喘薩鞠遜毕斑朔峇佩泌和囂鞘grantselectontab_1to

37、user2;46、oracle議云仇序殻ps-aef|greplocal=yes議幻序殻id音嬬葎1毕飛葎1毕夸乎序殻瓜渠棒毕俶勣喘凋綜姫棒個序殻实实47、壓windows201*server荷恬狼由和毕喘netstart凋綜尼強oracle議捲暦,泌和netstartoracleserviceorclnetstartoraclestartorclnetstartoracletnslistener80netstartoracle賜宀毕旋喘netstop凋綜栖嶮峭捲暦netstoporaclestartorclnetstoporacleserviceorclnetstoporacletnslis

38、tener80尼強方象垂議総翌匯倖圭隈oradim-startup-sidsid購液方象垂議総翌匯倖圭隈oradim-shutdown-sidsid48、謹燕荷恬壓瓜糞縞峇佩念毕臥儂單晒匂氏功象銭俊訳周毕双竃叱怏辛嬬議銭俊圭宛旺貫嶄孀竃狼由蝕4恷弌議恷煮圭宛。銭俊訳周勣割芸深打揮嗤沫哈議燕、佩方謹議燕6坪翌燕議僉夲辛喇巷塀翌蚊燕嶄議謄塘佩方*坪蚊燕嶄耽匯肝臥孀議肝方鳩協毕核持恷弌葎恷煮圭宛。49、隠隔oracle方象垂單措來嬬議飛孤穣馬1处蛍曝功象糞縞将刮侭誼毕壓匯倖寄方象垂嶄毕方象垂腎寂議蒸寄謹方頁瓜富楚議燕侭媼嗤。泌採酒晒寄方象垂才砿尖毕泌採個鋲哘喘議臥儂來嬬毕匯違辛參聞喘蛍曝宸嶽返粁。侭

39、僚蛍曝祥頁強蓑仇繍燕嶄芝村蛍宣欺飛孤音揖議燕腎寂貧毕聞方象壓麗尖貧瓜蛍護蝕栖毕宴噐略擦、姥芸、志鹸、並暦式臥儂來嬬。輝聞喘議扮昨辛秀羨匯倖銭俊侭嗤蛍曝議篇夕毕聞凪壓貸辞貧挽參匯倖屁悶竃。(1)秀羨蛍曝燕createtableemployee(empnovarchar2(10)primarykey,namevarchar2(30),deptnonumber(2)partitionbyrange(deptno)(partitionpart1valueslessthan(11)tablespacepart1_ts,partitionpart2valueslessthan(21)tablespacep

40、art2_ts,partitionpart3valueslessthan(31)tablespacepart3_tspartitionpart4valueslessthan(maxvalue)tablespacepart4_ts);燕employee卆象deptno双序佩蛍曝。(2)蛍曝沫哈createindexemployee_deptnoonemployee(deptno)local(partitionpart1tablespacepart1_ndx_ts,partitionpart2tablespacepart2_ndx_ts,partitionpart3tablespacepart3_

41、ndx_ts,partitionpart4tablespacepart4_ndx_ts,);輝蛍曝嶄竃俯謹並暦旺拝勣隠屬侭嗤蛍曝嶄議方象芝村議率匯來扮寡喘畠蕉沫哈毕泌createindexemployee_deptnoonemployee(deptno)globalpartitionbyrange(deptno)(partitionpart1valueslessthan(11)tablespacepart1_ndx_ts,partitionpart2valueslessthan(21)tablespacepart2_ndx_ts,partitionpart3valueslessthan(31)

42、tablespacepart3_ndx_tspartitionpart4valueslessthan(maxvalue)tablespacepart4_ndx_ts);壓秀羨畠蕉沫哈扮毕global徨鞘塋俯峺協沫哈議袈律峙毕宸倖袈律峙辛參音揖噐燕蛍曝議袈律峙。峪嗤秀羨蕉何沫哈嘉氏聞沫哈沫哈蛍曝嚥燕蛍曝寂秀羨軟匯匯斤哘購狼。咀緩毕壓寄謹方秤趨和毕哘乎聞喘蕉何沫哈蛍曝。飛聞喘阻緩沫哈毕蛍曝祥嬬校載否叟仇繍沫哈蛍曝嚥燕蛍曝秀羨購選毕蕉何沫哈曳畠蕉沫哈厚叟噐砿尖。(3)蛍曝砿尖功象糞縞俶勣毕珊辛參聞喘altertable凋綜栖奐紗、卿虹、住算、卞強、俐個、嶷凋兆、皿蛍、舜玉匯倖厮贋壓蛍曝議潤更。2)r

43、ebuildindexes】嶷秀沫哈音氏唹.贋刈狛殻处泌惚燕嶄芝村撞訓議瓜評茅賜峨秘毕勝砿燕嶄議芝村悳楚隠隔音延毕沫哈腎寂議聞喘楚氏音僅奐紗。埋隼芝村貫沫哈嶄瓜評茅毕徽頁乎芝村沫哈x議聞喘腎寂音嬬瓜嶷仟聞喘。咀緩毕泌惚燕延晒音協毕沫哈腎寂楚氏音僅奐紗毕音砿燕嶄芝村方楚頁倦奐紗-峪叙叙頁咀葎沫哈嶄涙丼腎寂楚議奐紗。勣指辺椎乂奚瓜評茅芝村聞喘議腎寂毕俶勣聞喘alterindexrebuild凋綜。辛參恂匯倖協豚塰佩議答侃尖殻會毕栖嶷秀恷試強燕議沫哈。宸倖答侃尖殻會辛參壓腎椀扮塰佩毕參閲窒殻會嚥喘薩喝融。飛嬬釈隔沫哈議宸匯殻會号皿毕宴辛參式扮指辺椎乂隆聞喘腎寂毕戻互腎寂旋喘楕。3)粁議哩頭屁尖輝伏撹

44、匯倖方象垂斤2扮】匯倖燕賜匯倖沫哈处毕宥狛喘薩髪福峙賜峺協峙栖葎万峺協燕腎寂。匯倖壓燕腎寂嶄侭伏撹議粁毕喘噐贋刈斤2議精購方象。壓粁瓜購液、辺抹、舜僅岻念毕粁侭蛍塘議腎寂繍音瓜瞥慧。匯倖粁頁喇袈律怏撹毕遇袈律頁喇精惣議oracle翠怏撹。匯稀贋壓議袈律音嬬壅贋刈仟議方象毕椎宸倖粁祥氏肇資誼仟議袈律毕拝旺音勣箔宸乂袈律頁泳緩精惣議。宸劔議制婢氏匯岷写偬和肇毕岷欺燕腎寂嶄議方象猟周音嬬戻工厚謹議徭喇腎寂毕賜宀袈律方楚厮器欺自件。咀緩毕匯倖哩頭湊謹議方象粁毕音叙氏唹.塰佩毕匆氏哈窟燕腎寂嶄議腎寂砿尖諒籾。侭參毕耽倖方象粁峪根嗤匯倖袈律頁噴蛍嗤吩議。処廁酌陣狼由毕辛參宥狛殊臥dba_segments方

45、象忖灸篇夕栖阻盾陳乂方象垂斤2根嗤10倖賜厚謹袈律議粁毕鳩協凪方象粁哩頭。飛匯倖粁議哩頭狛謹毕辛喘曾嶽圭隈盾畳宸倖諒籾(1)喘屎鳩議贋刈歌方秀羨匯倖仟燕毕繍症燕嶄議方象峨秘欺仟燕嶄毕壅評茅症燕6(2)旋喘export/import垢醤。泌expsystem/managerfile=exp.dmpcompress=ygrants=yindexes=ytables=(t1,t2)飛補竃撹孔毕序秘oracle毕評茅貧峰燕。廣compress=y畳協繍壓補竃狛殻嶄俐個万断議贋刈歌方。impsystem/managerfile=exp.dmpcommit=ybuffer=64000full=y廣壓補秘扮

46、嶷仟塘崔仟議贋刈歌方。徭喇袈律議哩頭屁尖燕腎寂嶄議匯倖徭喇袈律頁燕腎寂嶄精銭徭喇】腎寂处翠議鹿栽。輝匯倖粁購液扮毕万議袈律繍瓜瞥慧毕旺瓜炎芝葎徭喇袈律。隼遇毕宸乂徭喇袈律壅匆音嬬嚥精惣議徭喇袈律栽旺毕万断岻寂議順：兵嶮贋壓。徽頁輝燕腎寂議髪福峙pctincrease譜崔音葎0扮毕smon朔岬序氏協豚議繍宸乂精惣議徭喇袈律栽旺。飛pctincrease譜崔葎0毕椎精惣徭喇袈律音氏瓜方象垂徭強栽旺。徽辛參聞喘altertablespace凋綜coalesce僉x毕栖膿独序佩精惣徭喇袈律議栽旺。音序佩徭喇袈律栽旺毕壓晩朔議腎寂萩箔嶄毕氏唹.欺燕腎寂嶄議腎寂蛍塘。輝俶勣匯倖怎校寄議袈律扮毕方象垂旺音氏

47、栽旺精惣議徭喇袈律毕茅掲短嗤凪麿僉夲。宸劔毕輝燕腎寂嶄念中熟弌徭喇袈律厮瓜精購聞喘扮毕繍聞喘燕腎寂嶄朔中何蛍恷寄議匯倖徭喇袈律。潤惚毕氏咀葎万断短嗤怎校謹議聞喘腎寂毕貫遇擬崑燕腎寂嶄堀業貧議狸芹。喇噐宸劔議序殻竃毕聞方象垂議腎寂蛍塘鉦尖）埆栖埆垓。徭喇腎寂哩頭械氏竃壓椎乂将械購液嗽嶷仟伏撹議方象垂燕才沫哈嶄。壓尖）議oracle燕腎寂嶄毕耽匯倖方象垂斤2贋刈壓匯倖汽鏡議袈律嶄毕旺拝侭嗤嗤丼徭喇腎寂鹿嶄壓匯倖賞寄遇銭偬議袈律嶄。宸劔毕壓匯倖斤2俶勣現紗贋刈腎寂扮毕辛參壓奐紗資函怎校寄徭喇腎寂議辛嬬來揖扮毕恷弌晒腎寂嶄議儉桟距喘毕戻互徭喇腎寂聞喘楕50、臥心才俐個oracle捲暦匂極忖憲鹿圭隈匯1

48、)臥心捲暦匂極忖憲鹿select*fromv$nls_parameters;select*fromnls_database_parameters;select*ps$;2)俐個捲暦匂極忖憲鹿(喘sys喘薩)遍枠峇佩updateprops$setvalue$=we8iso8859p1wherename=nls_characterset;updateprops$setvalue$=chinawherename=nls_language;戻住】commit处毕隼朔毕嶷仟尼強方象垂63处喘人薩極垢醤】pl/sqldeveloporpbetc.处臥儂方象垂毕飛1幣岱鷹毕枠臥儂竃方象

49、垂極議忖憲鹿毕隼朔毕貫廣過燕嶄俐個nls_lang忖粁議峙毕辛嬬葎american_america.we8iso8859p1賜宀simplifiedchinese_china.zhs16gbk賜宀na吉。圭隈屈altersystemenablerestrictedsession;alterdatabaseorclcharactersetzhs16gbk;alterdatabaseorclnationalcharactersetzhs16gbk;51、臥心狼由嶄議叔弼select*fromdba_roles;52、import聞喘峺掴1处購囚忖髪福峙keyworddescription(defa

50、ult)keyworddescription(default)-useridusername/passwordfullimportentirefile(n)buffersizeofdatabufferfromuserlistofownerusernamesfileinputfile(expdat.dmp)touserlistofusernamesshowjustlistfilecontents(n)tableslistoftablenamesignoreignorecreateerrors(n)recordlengthlengthofiorecordgrantsimportgrants(y)i

51、nctypeincrementalimporttypeindexesimportindexes(y)commitcommitarrayinsert(n)rowsimportdatarows(y)parfileparameterfilenamekeyworddescription(default)-loglogfileofscreenoutputdestroyoverwritetablespacedatafile(n)indexfilewritetable/indexinfotospecifiedfilecharsetcharactersetofexportfile(nls_lang)point

52、_in_time_recovertablespacepoint-in-timerecovery(n)skip_unusable_indexesskipmaintenanceofunusableindexes(n)analyzeexecuteanalyzestatementsindumpfile(y)feedbackdisplayprogresseveryxrows(0)volsizenumberofbytesinfileoneachvolumeofafileontape傍苧1处泌惚擬竃喘薩短嗤dba幡件毕夸擬秘喘薩辛參音喘峺協fromuser、touser歌方62处泌惚擬竃喘薩啜嗤dba幡件毕

53、夸擬秘喘薩匆駅倬啜嗤dba幡件653、械喘議sql購囚忖1处union卦指曾倖臥儂潤惚旺肇茅凪嶄嶷鹸議何蛍62处unionall卦指曾倖臥儂潤惚徽頁旺音肇茅嶷鹸議射村63处intersect卦指曾倖燕嶄慌嗤議佩64处minus卦指及匯倖燕嶄贋壓議徽頁及屈倖燕嶄音贋壓議射村65处betweenand卦指才岻寂議峙毕淫凄円順峙654、械喘議sql匯乂痕方1处add_months(column_name,number_value)壓輝念議晩豚貧奐紗number_value倖埖6廣column_name葎晩豚侏6number_value葎屁侏方峙62处last_day(column_name)卦指輝念

54、埖議恷朔匯爺6廣column_name葎晩豚侏63处months_between(column_a,column_b)卦指曾倖晩豚寂埖芸議倖方64处next_day(column_name,sundaymonday,tuesday,wednesday,thursday,friday,5处lpad(column_name,number_value,fill_character)6处rpad(column_name,number_value,fill_character)7处ltirm(column_name,fill_character)8处rtrim(column_name,fill_character)9处replace(column_name,o