无码人妻少妇色欲av一区二区,亚洲av本道一区二区三区四区,五月色丁香婷婷网蜜臀av

oracle 11.2.0.4甯哥敤鎿嶄綔璇存槑涔?PDF 涓嬭澆

鏈珯鏁寸悊涓嬭澆錛?/strong>

閾炬帴錛?a target="_blank">https://pan.baidu.com/s/1cUBWXEntLzeEyyUzN6krDw

鎻愬彇鐮侊細(xì)vw6m

鐩稿叧鎴浘錛?/strong>

涓昏鍐呭錛?/strong>

1.鏃ュ父榪愮淮綾?/div>
1.1澶囦喚 Backup 錛坋xp&imp錛?/div>
1.1.1 exp瀵煎嚭澶囦喚

[璇存槑]

澶囦喚閲嶄簬涓€鍒囷紒澶囦喚閲嶄簬涓€鍒囷紒澶囦喚閲嶄簬涓€鍒囷紒

[閫傜敤鑼冨洿]

Oracle鍗曟満鍜孯AC

[SQL璇彞]

[windows瀹㈡埛绔痌

鎸夌敤鎴峰鍑猴細(xì)exp test/test@test file=d:\daochu.dmp log=d:\daochu.log owner=user1,user2

[Linux鏈嶅姟鍣ㄤ笂exp瀵煎嚭]

鎸夌敤鎴峰鍑猴細(xì)exp test/test file=/home/oracle/daochu.dmp log=/home/oracle/daochu.log owner=user1,use2

1.1.2 imp瀵煎叆

[璇存槑]

鑻ョ幇鍦ㄥ凡緇忔湁涓€浠芥垚鍔熷鍑虹殑dmp澶囦喚鏂囦歡錛岄渶瑕佹仮澶嶆垨鑰呰縼縐繪暟鎹紝寰€寰€浣跨敤imp鍛戒護(hù)瀵煎叆

[閫傜敤鑼冨洿]

Oracle鍗曟満鍜孯AC

[SQL璇彞]

[windows瀹㈡埛绔痌

瀵煎叆鍗曞紶琛細(xì)imp test/test@test file=d:\daoru.dmp log=d:\daoru.log tables=(test)

A鐢ㄦ埛鐨勫鍑烘枃浠訛紝闇€瑕佸鍏ョ敤鎴稡錛?/div>
imp userB/userB file=d:\daoru.dmp log=d:\daoru.log fromuser=userA touser=userB

[Linux鏈嶅姟鍣ㄤ笂imp 瀵煎叆]

1銆乨mp鏂囦歡涓婁紶鍒?u01鐩綍涓?渚嬪test.dmp)

2銆佺敤root鐢ㄦ埛ssh鐧誨綍涓繪満

cd /u01

chown oracle:oinstall test.dmp

chmod 775 test.dmp

3銆佺幆澧冨彉閲忚緗?/div>
su - oracle

export LANG=ZH_CN.GB18030 (鍙互閬垮厤瀵煎叆鍚庯紝瀛楁娉ㄩ噴鍜岃〃娉ㄩ噴涔辯爜)

4銆佸鍏?/div>
imp test/test file=/u01/test.dmp log=/home/oracle/test.log full=Y

5銆佹煡鐪嬫棩蹇?/div>
涓嬭澆/home/oracle/test.log錛岃瀵熷鍏ユ槸鍚︽垚鍔熴€?/div>

1.2琛ㄧ┖闂?Tablespace

1.2.1琛ㄧ┖闂翠嬌鐢ㄧ巼鏌ヨSQL

[璇存槑]

琛ㄧ┖闂村垎綾伙細(xì)緋葷粺琛ㄧ┖闂達(dá)紙SYSTEM錛孲YSAUX錛孶NDO錛孴EMP錛孶SER錛?涓氬姟琛ㄧ┖闂達(dá)紙璀錛歓F琛ㄧ┖闂達(dá)級(jí)

[閫傜敤鑼冨洿]

Oracle鍗曟満鍜孯AC

[SQL璇彞]

SELECT DF.TABLESPACE_NAME,

COUNT(*) DATAFILE_COUNT,

ROUND(SUM(DF.BYTES) / 1048576 / 1024, 2) SIZE_GB,

ROUND(SUM(FREE.BYTES) / 1048576 / 1024, 2) FREE_GB,

ROUND(SUM(DF.BYTES) / 1048576 / 1024 -

SUM(FREE.BYTES) / 1048576 / 1024,

2) USED_GB,

ROUND(MAX(FREE.MAXBYTES) / 1048576 / 1024, 2) MAXFREE,

100 - ROUND(100.0 * SUM(FREE.BYTES) / SUM(DF.BYTES), 2) PCT_USED,

ROUND(100.0 * SUM(FREE.BYTES) / SUM(DF.BYTES), 2) PCT_FREE

FROM DBA_DATA_FILES DF,

(SELECT TABLESPACE_NAME,

FILE_ID,

SUM(BYTES) BYTES,

MAX(BYTES) MAXBYTES

FROM DBA_FREE_SPACE

WHERE BYTES > 1024 * 1024

GROUP BY TABLESPACE_NAME, FILE_ID) FREE

WHERE DF.TABLESPACE_NAME = FREE.TABLESPACE_NAME(+)

AND DF.FILE_ID = FREE.FILE_ID(+)

GROUP BY DF.TABLESPACE_NAME

ORDER BY 8;

亚洲精品92内射,午夜福利院在线观看免费 ,亚洲av中文无码乱人伦在线视色,亚洲国产欧美国产综合在线,亚洲国产精品综合久久2007

鏈€鏂癑ava鍏ㄦ爤灝變笟瀹炴垬璇劇▼(鍏嶈垂)

AI浜哄伐鏅鴻兘瀛︿範(fàn)澶хぜ鍖?/h2>
IDEA姘鎬箙嬋€媧?/h2>

IDEA姘鎬箙嬋€媧?/h2>

66濂梛ava瀹炴垬璇劇▼鏃犲璺鍙?/h2>
閿嬪摜寮€濮嬫敹Java瀛﹀憳鍟︼紒

Python瀛︿範(fàn)璺嚎鍥?/h2>

閿嬪摜寮€濮嬫敹Java瀛﹀憳鍟︼紒

Python瀛︿範(fàn)璺嚎鍥?/h2>

oracle 11.2.0.4甯哥敤鎿嶄綔璇存槑涔?PDF 涓嬭澆

Java1234瀹樻柟緹?5錛?/td>
Java1234瀹樻柟緹?5錛?/td>	838462530