Oracle鏁版嵁搴撱€佸疄渚嬨€佺敤鎴枫€佽〃绌洪棿銆佽〃涔嬮棿鐨勫叧绯?
鏁版嵁搴擄細
Oracle鏁版嵁搴撴槸鏁版嵁鐨勭墿鐞嗗瓨鍌ㄣ€傝繖灏卞寘鎷紙鏁版嵁鏂囦欢ORA鎴栬€匘BF銆佹帶鍒舵枃浠躲€佽仈鏈烘棩蹇椼€佸弬鏁版枃浠讹級銆傚叾瀹濷racle鏁版嵁搴撶殑姒傚康鍜屽叾瀹冩暟鎹簱涓嶄竴鏍凤紝杩欓噷鐨勬暟鎹簱鏄竴涓搷浣滅郴缁熷彧鏈変竴涓簱銆傚彲浠ョ湅浣滄槸Oracle灏卞彧鏈変竴涓ぇ鏁版嵁搴撱€?
瀹炰緥锛?nbsp;
涓€涓狾racle瀹炰緥锛圤racle Instance锛夋湁涓€绯诲垪鐨勫悗鍙拌繘绋嬶紙Backguound Processes)鍜屽唴瀛樼粨鏋勶紙Memory Structures)缁勬垚銆備竴涓暟鎹簱鍙互鏈塶涓疄渚嬨€?
鐢ㄦ埛锛?
鐢ㄦ埛鏄湪瀹炰緥涓嬪缓绔嬬殑銆備笉鍚屽疄渚嬪彲浠ュ缓鐩稿悓鍚嶅瓧鐨勭敤鎴枫€?
琛ㄧ┖闂达細
琛ㄧ┖闂存槸涓€涓敤鏉ョ鐞嗘暟鎹瓨鍌ㄩ€昏緫姒傚康锛岃〃绌洪棿鍙槸鍜屾暟鎹枃浠讹紙ORA鎴栬€匘BF鏂囦欢锛夊彂鐢熷叧绯伙紝鏁版嵁鏂囦欢鏄墿鐞嗙殑锛屼竴涓〃绌洪棿鍙互鍖呭惈澶氫釜鏁版嵁鏂囦欢锛岃€屼竴涓暟鎹枃浠跺彧鑳介毝灞炰竴涓〃绌洪棿銆?
鏁版嵁鏂囦欢锛坉bf銆乷ra锛夛細
鏁版嵁鏂囦欢鏄暟鎹簱鐨勭墿鐞嗗瓨鍌ㄥ崟浣嶃€傛暟鎹簱鐨勬暟鎹槸瀛樺偍鍦ㄨ〃绌洪棿涓殑锛岀湡姝ｆ槸鍦ㄦ煇涓€涓垨鑰呭涓暟鎹枃浠朵腑銆傝€屼竴涓〃绌洪棿鍙互鐢变竴涓垨澶氫釜鏁版嵁鏂囦欢缁勬垚锛屼竴涓暟鎹枃浠跺彧鑳藉睘浜庝竴涓〃绌洪棿銆備竴鏃︽暟鎹枃浠惰鍔犲叆鍒版煇涓〃绌洪棿鍚庯紝灏变笉鑳藉垹闄よ繖涓枃浠讹紝濡傛灉瑕佸垹闄ゆ煇涓暟鎹枃浠讹紝鍙兘鍒犻櫎鍏舵墍灞炰簬鐨勮〃绌洪棿鎵嶈銆?
娉細
琛ㄧ殑鏁版嵁锛屾槸鏈夌敤鎴锋斁鍏ユ煇涓€涓〃绌洪棿鐨勶紝鑰岃繖涓〃绌洪棿浼氶殢鏈烘妸杩欎簺琛ㄦ暟鎹斁鍒颁竴涓垨鑰呭涓暟鎹枃浠朵腑銆傜敱浜巓racle鐨勬暟鎹簱涓嶆槸鏅€氱殑姒傚康锛宱racle鏄湁鐢ㄦ埛鍜岃〃绌洪棿瀵规暟鎹繘琛岀鐞嗗拰瀛樻斁鐨勩€備絾鏄〃涓嶆槸鏈夎〃绌洪棿鍘绘煡璇㈢殑锛岃€屾槸鐢辩敤鎴峰幓鏌ョ殑銆傚洜涓轰笉鍚岀敤鎴峰彲浠ュ湪鍚屼竴涓〃绌洪棿寤虹珛鍚屼竴涓悕瀛楃殑琛紒杩欓噷鍖哄垎灏辨槸鐢ㄦ埛浜嗭紒


鐞嗚В1锛?
Oracle鏁版嵁搴撳彲浠ュ垱寤哄涓疄渚嬶紝姣忎釜瀹炰緥鍙互鍒涘缓澶氫釜琛ㄧ┖闂达紝姣忎釜琛ㄧ┖闂翠笅鍙互鍒涘缓澶氫釜鐢ㄦ埛锛堝悓鏃剁敤鎴蜂篃灞炰簬琛ㄧ┖闂村搴旂殑瀹炰緥锛夊拰鏁版嵁搴撴枃浠讹紝鐢ㄦ埛鍙互鍒涘缓澶氫釜琛紙姣忎釜琛ㄩ殢鏈哄瓨鍌ㄥ湪涓€涓垨澶氫釜鏁版嵁搴撴枃浠朵腑锛夛紝濡備笅鍥撅細

鐞嗚В2锛?
鐞嗚В1MS鏈夎銆?
瀹炰緥涓嬫湁鍜岋紝鎺堟潈璁块棶锛屾槸绠＄悊鐨勶紝缁忔巿鏉冨湪涓垱寤猴紝闅忔満瀛樺偍鍒颁笉鍚岀殑涓€?

鎿嶄綔1锛?
瀹夎Oracle鍚庝細鏈夐粯璁ょ殑瀹炰緥锛屽嵆ORCL銆備竴鑸笉鍒涘缓澶氫釜瀹炰緥锛屽湪榛樿瀹炰緥涓嬪垱寤鸿〃绌洪棿鍜岀敤鎴风瓑銆?
1锛岃繍琛孋MD杩涘叆DOS鐣岄潰锛岄鍏堣緭鍏ワ細sqlplus锛屽洖杞︼紱鍐嶈緭鍏ワ細sys/sys as sysdba锛屽洖杞︼紝鍗宠繘鍏モ€淪QL銆夆€濇搷浣滅姸鎬併€?
2锛岃緭鍏ワ細CREATE TABLESPACE 琛ㄧ┖闂村悕绉?LOGGING DATAFILE 'c:\琛ㄧ┖闂存暟鎹枃浠?ora' SIZE 500M autoextend on next 200m maxsize 2048m;锛岃〃绌洪棿鍒涘缓瀹屾垚銆?
3锛岃緭鍏ワ細CREATE USER 鐢ㄦ埛鍚嶇О PROFILE default IDENTIFIED BY 鐢ㄦ埛瀵嗙爜 DEFAULT TABLESPACE 鎺堟潈璁块棶鐨勮〃绌洪棿鍚嶇О TEMPORARY TABLESPACE temp ACCOUNT UNLOCK;锛岀敤鎴峰垱寤哄畬鎴愶紝骞舵巿鏉冪敤鎴疯闂煇琛ㄧ┖闂淬€?


鎿嶄綔2锛?
鍒涘缓琛ㄥ拰鎻掑叆鏁版嵁锛屽苟鏌ヨ娴忚鎻掑叆鐨勬暟鎹€?
1锛屽垱寤鸿〃锛岃緭鍏ワ細
create table 琛ㄥ悕(
瀛楁鍚嶇О1 瀛楁绫诲瀷,
瀛楁鍚嶇О2 瀛楁绫诲瀷,
瀛楁鍚嶇О3 瀛楁绫诲瀷
);锛屽洖杞︺€?
2锛屾彃鍏ユ暟鎹紝杈撳叆锛歩nsert into 琛ㄥ悕(瀛楁1,瀛楁2,瀛楁3) VALUES(鍊?,鍊?,鍊?);锛屽洖杞︺€?
3锛屾煡璇㈡暟鎹紝杈撳叆锛歴elect * from 琛ㄥ悕;锛屽洖杞︺€?