OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
DOSÖпÉÒÔÖ´ÐÐʱÓÉÓÚ ÔÚoracle 8i ÖÐ °²×°Ä¿Â¼ora81BIN±»ÉèÖÃΪȫ¾Ö·¾¶£¬
¸ÃĿ¼ÏÂÓÐEXP.EXEÓëIMP.EXEÎļþ±»ÓÃÀ´Ö´Ðе¼Èëµ¼³ö¡£
oracleÓÃjava±àд£¬SQLPLUS.EXE¡¢EXP.EXE¡¢IMP.EXEÕâÁ½¸öÎļþÓпÉÄÜÊDZ»°ü×°ºóµÄÀàÎļþ¡£
SQLPLUS.EXEµ÷ÓÃEXP.EXE¡¢IMP.EXEËù°ü¹üµÄÀ࣬Íê³Éµ¼Èëµ¼³ö¹¦ÄÜ¡£
ÏÂÃæ½éÉܵÄÊǵ¼Èëµ¼³öµÄʵÀý¡£
Êý¾Ýµ¼³ö£º
1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:daochu.dmpÖÐ
exp system/manager@TEST file=d:daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíinner_notify¡¢notify_staff_relatµ¼³ö
exp aichannel/aichannel@TESTDB2 file= d:datanewsmgnt.dmp tables=(inner_notify,notify_staff_relat)
4 ½«Êý¾Ý¿âÖеıítable1ÖеÄ×Ö¶Îfiled1ÒÔ"00"´òÍ·µÄÊý¾Ýµ¼³ö
exp system/manager@TEST file=d:daochu.dmp tables=(table1) query=" where filed1 like '00%'"
ÉÏÃæÊdz£Óõĵ¼³ö£¬¶ÔÓÚѹËõ£¬¼ÈÓÃwinzip°ÑdmpÎļþ¿ÉÒԺܺõÄѹËõ¡£
Ò²¿ÉÒÔÔÚÉÏÃæÃüÁîºóÃæ ¼ÓÉÏ compress=y À´ÊµÏÖ¡£
Êý¾ÝµÄµ¼Èë
1 ½«D:daochu.dmp ÖеÄÊý¾Ýµ¼Èë TESTÊý¾Ý¿âÖС£
imp system/manager@TEST file=d:daochu.dmp
imp aichannel/aichannel@HUST full=y file=d:datanewsmgnt.dmp ignore=y
ÉÏÃæ¿ÉÄÜÓеãÎÊÌ⣬ÒòΪÓеıíÒѾ´æÔÚ£¬È»ºóËü¾Í±¨´í£¬¶Ô¸Ã±í¾Í²»½øÐе¼Èë¡£
ÔÚºóÃæ¼ÓÉÏ ignore=y ¾Í¿ÉÒÔÁË¡£
2 ½«d:daochu.dmpÖеıítable1 µ¼Èë
imp system/manager@TEST file=d:daochu.dmp tables=(table1)
»ù±¾ÉÏÉÏÃæµÄµ¼Èëµ¼³ö¹»ÓÃÁË¡£²»ÉÙÇé¿öÒªÏÈÊǽ«±í³¹µ×ɾ³ý£¬È»ºóµ¼Èë¡£
×¢Ò⣺
²Ù×÷ÕßÒªÓÐ×ã¹»µÄȨÏÞ£¬È¨ÏÞ²»¹»Ëü»áÌáÊ
Ïà¹ØÎĵµ£º
Oracle±íµÄ¹ÜÀí
±íÃûºÍÁÐÃûµÄÃüÃû¹æÔò£º
1±ØÐëÒÔ×Öĸ¿ªÍ·
2³¤¶È²»Äܳ¬¹ý30¸ö×Ö·û
3²»ÄÜʹÓÃOracleµÄ±£Áô×Ö
4Ö»ÄÜʹÓÃÈçÏÂ×Ö·û£ºA-Z,a-z,0-9,$,#µÈ
OracleÖ§³ÖµÄÊý¾ÝÀàÐÍ£º
1char ¶¨³¤£¬×î´ó2000×Ö·û
Àý×Ó£ºchar(10) ‘Ïþ»Ô’ ǰËĸö×Ö·û·Å’Ïþ»Ô’£¬ºóÌíÁù¸ö¿Õ¸ñ²¹È«
2varchar2(20) ±ä³¤£¬×î´ ......
±íµÄ²éÕÒ£º
select * from emp where (sal>500 or job='MANAGER') and ename like 'J%';
ÒýºÅÀï±ßµÄ×Ö·ûÊÇÇø·Ö´óСдµÄ¡£
²éÕÒÖ®ºó°Ñ½á¹ûÅÅÐò£º
select * from emp order by sal asc;
ascÊÇÉýÐò£¬descÊǽµÐò
¶ÔÁÐÖØÃüÃû£¬Ö»Òª´ò¸ö¿Õ¸ñ£¬ºó¸úÐÂÁÐÃû¾Í¿ÉÒÔ
select ename,sal*12+nvl(comm,0)*12 "Äêн" from ......
ÈçºÎ±¸·ÝOracleÊý¾Ý¿â£º
MD F:\DB_BAK\%date:~0,10%
EXP userid=bszlhr/bszlhr@ORCL_14 file=F:\DB_BAK\%date:~0,10%\bszlhr%date:~0,10%.dmp log=f:\DB_BAK\%date:~0,10%\log_bszlhr_%date:~0,10%.log
buffer=64000 owner=bszlhr
-----´´½¨ÐÅÓÃÐÅÏ¢µÄ±í----------
create table GCCredit(
itemID numb ......
×î½üÔÚʹÓÃOracle×öÎļþÉÏ´«£¬ÒªÇó½«ÎļþÊý¾Ý±£´æµ½Êý¾Ý¿âÖС£OracleÌṩÁËBlobÓÃÀ´´æ´¢¶þ½øÖÆ´ó¶ÔÏóÊý¾Ý£¬¿ÉÊÇËüºÍJava.sqlÀïÃæµÄBlob²»¼æÈÝ£¬¾³£µ¼ÖÂBlob×Ö¶ÎÎÞ·¨Ëø¶¨»òÕß²Ù×÷ʧ°Ü¡£ÓÉÓÚÒÔǰûÓÐ×ö¹ýÕâÑùµÄÀý×Ó£¬ËùÒÔ»¨Á˲»ÉÙʱ¼ä²Å½â¾ö¡£
ÎÒʹÓõÄÊÇstruts2.1.8+spring2.5+hibernate3.2£¬ÏÂÃæÊÇÏà¹Ø´úÂ룺
springÅäÖÃ ......
¡¡¡¡OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓÃ……
¡¡¡¡OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏàµ±Ó ......