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=file= d:datanewsmgnt.dmp ignore=y
ÉÏÃæ¿ÉÄÜÓеãÎÊÌ⣬ÒòΪÓеıíÒѾ´æÔÚ£¬È»ºóËü¾Í±¨´í£¬¶Ô¸Ã±í¾Í²»½øÐе¼Èë¡£
ÔÚºóÃæ¼ÓÉÏ ignore=y ¾Í¿ÉÒÔÁË¡£
2 ½«d:daochu.dmpÖеıítable1 µ¼Èë
imp system/manager@TEST file=d:daochu.dmp tables=(table1)
»ù±¾ÉÏÉÏÃæµÄµ¼Èëµ¼³ö¹»ÓÃÁË¡£²»ÉÙÇé¿öÒªÏÈÊǽ«±í³¹µ×ɾ³ý£¬È»ºóµ¼Èë¡£
×¢Ò⣺
²Ù×÷ÕßÒªÓÐ×ã¹
Ïà¹ØÎĵµ£º
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String URL=dbmes.url;
Connection con = DriverManager.getConnection(URL,dbmes.usrname,dbmes.pwd);
try{
// ×¼±¸Óï¾äÖ´ÐжÔÏó
String bh=request.getParameter("dwmc");
Statement stmt = con.createStatement() ......
INSERT /*+APPEND */ INTO employee (empno,ename,sal,deptno)
SELECT empno,ename,sal,deptno from emp
WHERE deptno=20;
µÚ¶þÌõÓï¾äʹÓÃ/*+APPEND */À´±íʾ²ÉÓÃÖ±½Ó×°ÔØ·½Ê½£¬µ±Òª×°ÔØ´óÅúÁ¿Êý¾Ýʱ£¬²ÉÓõڶþÖÖ·½·¨×°ÔØÊý¾ÝµÄËÙ¶ÈÒªÔ¶Ô¶ÓÅÓÚµÚÒ»ÖÖ·½·¨¡£
ʹÓöà±í²åÈëÊý¾Ý
ʹÓÃALL²Ù×÷·ûÖ´Ðжà±í²åÈëʱ£¬ÔÚÿ¸öÌõ¼þ× ......
oracle ´æ´¢¹ý³ÌºÍº¯Êýѧϰ±Ê¼Ç
1¡¢´´½¨¹ý³ÌµÄÓï·¨£º
Code
create [or replace] procedure procedure_name
[(argument[{in|out|in out}] type,
argument[{in|out|in out}] type)]&n ......
½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.3£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
SQL ÓïÑÔ·ÖÀࣺ
1 DDL£¨Êý¾Ý¶¨Òå £©ÓÃÓÚ´´½¨ºÍ¶¨ÒåÊý¾Ý¿â¶ÔÏ󣬲¢ÇÒ½«¶ÔÕâЩ¶ÔÏóµÄ¶¨Òå±£´æÔÚÊý¾Ý×ÖµäÖС£
creat table ´´½¨±í
alter table ÐÞ¸ ......
create or replace procedure p //ÓоÍÌæ»»£¬Ã»Óоʹ´½¨
is
cursor c is
select * from emp for update;
begin
for v_emp in c loop
if (v_emp.deptno =10) then
&nb ......