oracleÊý¾Ý¿âµ¼Èëµ¼³ö
¸ù¾ÝÓû§µ¼³öÓï¾ä£º
1.Êý¾Ý¿âµ¼³ö
exp system/jade@JADE_166.111.134.26 file=d:\jade.dmp statistics=none
˵Ã÷£º
systeÊÇÓû§Ãû
jadeÊÇÃÜÂë
JADE_166.111.134.26ÊÇSID±êʾ
file=d:\jade.dmp Êǵ¼³öÎļþµÄ·¾¶¼°ÎļþÃû
2.Êý¾Ý¿âµ¼Èë
imp system/jade@JADE_166.111.134.26 file=d:\jade.dmp fromuser=system touser=alen
˵Ã÷£º
systeÊÇÓû§Ãû
jadeÊÇÃÜÂë
JADE_166.111.134.26ÊÇSID±êʾ
file=d:\jade.dmp Ö¸¶¨µ¼ÈëÎļþµÄ·¾¶
fromuser=system touser=alen ´ÓÓû§systemµ¼ÈëalenÓû§
¸½£ºoracleµ¼³ö²ÎÊýÏê½â
ͨ¹ýÊäÈë EXP ÃüÁîºÍÓû§Ãû/¿ÚÁÄú¿ÉÒÔ
ºó½ÓÓû§Ãû/¿ÚÁîµÄÃüÁî:
Àý³Ì: EXP SCOTT/TIGER
»òÕߣ¬ÄúÒ²¿ÉÒÔͨ¹ýÊäÈë¸úÓи÷ÖÖ²ÎÊýµÄ EXP ÃüÁîÀ´¿ØÖÆ“µ¼³ö”
°´ÕÕ²»Í¬²ÎÊý¡£ÒªÖ¸¶¨²ÎÊý£¬Äú¿ÉÒÔʹÓùؼü×Ö:
¸ñʽ: EXP KEYWORD=value »ò KEYWORD=(value1,value2,...,valueN)
Àý³Ì: EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
»ò TABLES=(T1: P1,T1: P2)£¬Èç¹û T1 ÊÇ·ÖÇø±í
USERID ±ØÐëÊÇÃüÁîÐÐÖеĵÚÒ»¸ö²ÎÊý¡£
¹Ø¼ü×Ö ËµÃ÷(ĬÈÏ) ¹Ø¼ü×Ö ËµÃ÷(ĬÈÏ)
--------------------------------------------------------------------------
USERID Óû§Ãû/¿ÚÁî FULL µ¼³öÕû¸öÎļþ (N)
BUFFER Êý¾Ý»º³åÇø´óС OWNER ËùÓÐÕßÓû§ÃûÁбí
FILE Êä³öÎļþ (EXPDAT.DMP) TABLES ±íÃû³ÆÁбí
COMPRESS µ¼Èëµ½Ò»¸öÇø (Y) RECORDLENGTH IO ¼Ç¼µÄ³¤¶È
GRANTS µ¼³öȨÏÞ (Y) INCTYPE ÔöÁ¿µ¼³öÀàÐÍ
INDEXES µ¼³öË÷Òý (Y) RECORD ¸ú×ÙÔöÁ¿µ¼³ö (Y)
DIRECT Ö±½Ó·¾¶ (N) TRIGGERS  
Ïà¹ØÎĵµ£º
Ô·¢±íÓÚhttp://saharabear.javaeye.com
ºÍhttp://www.haulynjason.net(Ó¢)
ͬʱ·¢±íÔÚÕâÀï.
´óÔ¼°ëÄêÇ°£¬Oracle¹«Ë¾Ðû²¼£¬ËüÏëÊÕ¹ºSun£¬×òÌìµÄʱºò,Oracle¹«Ë¾Ðû²¼Íê³É¶ÔSun΢ϵͳµÄÊÕ¹º¡£×÷ΪJava³ÌÐòÔ±£¬ÎÒÃÇ´ó¼Ò¶¼·Ç³£¹Ø
ÐĵÄÊÇSun²úÆ·£¬°üÀ¨Java£¬Netbeans£¬Glassfish£¬Solaris/
OpenSolaris£¬OpenOffice£¬ ......
Ô·¢±íÓÚhttp://saharabear.javaeye.com
ͬʱ·¢±íÔÚÕâÀï.
²»ÐèÒªÏàÐÅÉÌÒµÉϵÄÈκγÐŵ,²»¹ýÈκεĹٷ½FAQ¶¼»áÓвο¼¼ÛÖµ,ÕâÀï
ÊÇOracle·¢²¼µÄÕë¶ÔSunµÄ¸÷Ïî²úÆ·µÄһЩ˵Ã÷µÄFAQ,»ù±¾ÉÏÃèÊöÁ˶ÔGlassfish¼ÌÐøÖ§³Ö,¶ÔNetbeans¼ÌÐø¿ª·¢µÄ̬¶È,²»¹ý,kenai.com,ΰ´óµÄ"ÎÒÃDz»½ö½öÊÇ´úÂëÍйÜ"µÄÉç½»ÐÔ¿ª·¢Õ¾µã,»ù± ......
SQL> select * from ta;
ID NAME
---------- --------------------
1 gorey
2 gorey2
SQL> select * from tb;
I ......
create or replace procedure getok
as
cursor mycur is select ids,name from aaa where name not in (select names from ok);
vempno aaa.ids%type;
vename aaa.name%type;
begin
open mycur;
loop
fetch mycur into vempno,vename;
exit when mycur%notfound;
if mycur%found then
insert ......
TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar
month spelled out march
Year:
yy two digits 98  ......