Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

µ¼ÈëOracleʵÀý

--´´½¨Óû§
create user iagent identified by ia
--profile default 
default  tablespace users
temporary tablespace temp;
--account unlock;
 
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
  alter  user  iagent  identified   by ia;
--¸ø´´½¨µÄÓû§ÊÚȨ
grant create user,drop user,alter user,create any view,
drop any view,exp_full_database,imp_full_database,dba,connect,resource,
create session to iagent;
--°Ñ±¸·ÝÎļþ¿½µ½±¾µØÓ²ÅÌ(±¾ÀýÒÔDÅÌΪÀý),È»ºóµ¼ÈëÊý¾Ý¿â
$ imp  file=d:\expdata_iagent_2009-12-07.dmp  ignore=y  indexes=y  grants=y rows=y fromuser=iagent touser=iagent  log=d:impdat_2009-12-07.log 
 
 
ÕâÀïÐèҪעÒâÒ»µã ±¸·ÝÎļþµ¼³öµÄʱºòÓõÄÊÇÄĸöÓû§ µ¼ÈëµÄʱºò¾ÍµÃÓÃÄǸöÓû§(»òÕßÊǾßÓк͵¼³ö±¸·ÝÓû§ÏàͬȨÏÞµÄÆäËûÓû§) £¬´ËÀýÖе¼Èë²ÉÓõÄÊÇÓû§Îªsystem ÃÜÂëΪdbmanagerµÄÓû§ £¬µ¼Èë³É¹¦ºó £¬ÔÚ¿Í»§¶ËÒªÁ¬½Ó´ËORACLE£¬ÐèÒªÐ޸Ŀͻ§¶ËµÄtnsnames.ora Îļþ È磺
IAGENT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.235.128)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = iagent)
    )
  )
HOSTÐ޸ijɷþÎñÆ÷µÄIPµØÖ·»òÕßÊǼÆËã»úÃû  £¬ÕâÑù¿Í»§¶Ë¾Í¿ÉÒÔÁ´½ÓÉÏÁË
 


Ïà¹ØÎĵµ£º

OracleµÄ°æȨÉùÃ÷

   
ÒÔÍù´ÓÀ´Ã»ÓÐÏëÈ¥ÈÏÕæ¶ÁÒ»´ÎOracleµÄ°æȨÉùÃ÷£¬½ñÌì´ò¿ªOracle10gR2µÄÎĵµ£¬ÓÚÊǾÍË÷ÐÔ´ÓÍ·¿ªÊ¼¶ÁÒ»ÏÂÕâƪÎÄÕ¡£
һЩÎÒÏë´ó¼Ò¶¼Ó¦¸ÃÈ¥ÖªµÀµÄ£¬ËäÈ»¹úÄڵİæȨ¸ÅÄîʵÔÚÊDZȽϵ­±¡£¬µ«ÏëÀ´»áÔ½À´Ô½ºÃµÄ¡£
Oracle10g·ÖΪ4¸ö°æ±¾£¬·Ö±ðÊÇ£º
1¡£Oracle Database Standard Edition One£¬×î»ù±¾µÄÉÌÒµ°æ± ......

Oracle¿Í»§¶ËÅäÖñʼÇ

1.½«¿Í»§¶Ë³ÌÐò½âѹµ½µçÄÔÖÐ
2.ÅäÖû·¾³±äÁ¿£º
ORACLE_HOME=F:\instantclient_10_2\client
Path¼ÓÉÏ%ORACLE_HOME%\bin£»
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3.ÐÞ¸Ä
%ORACLE_HOME%\network\adminϵÄtnsnames.oraÎļþ
dev =            &nbs ......

ÔÚdosÏÂ oracle exp/imp and import .sql

1.
¿ªÊ¼-->ÔËÐÐ-->cmd-->
.µ¼³öÊý¾Ý
exp help=y ²é¿´°ïÖú
exp rbt/rbt@ora10 file=c:\db.dmp full=y °´EnterÖ´ÐÐ
 .³É¹¦Ö´ÐС£¡£¡£
.µ¼ÈëÊý¾Ý
imp help=y ²é¿´°ïÖú
impÓÉÓµÓÐDBAȨÏÞµÄÓû§eXPÖ´ÐÐ.
imp kxself2/kxself2@ora10  full=y  file=c:\db.dmp
»ò
Imp username/password file=f ......

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ