µ¼Èë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µÄ°æȨÉùÃ÷£¬½ñÌì´ò¿ªOracle10gR2µÄÎĵµ£¬ÓÚÊǾÍË÷ÐÔ´ÓÍ·¿ªÊ¼¶ÁÒ»ÏÂÕâƪÎÄÕ¡£
һЩÎÒÏë´ó¼Ò¶¼Ó¦¸ÃÈ¥ÖªµÀµÄ£¬ËäÈ»¹úÄڵİæȨ¸ÅÄîʵÔÚÊDZȽϵ±¡£¬µ«ÏëÀ´»áÔ½À´Ô½ºÃµÄ¡£
Oracle10g·ÖΪ4¸ö°æ±¾£¬·Ö±ðÊÇ£º
1¡£Oracle Database Standard Edition One£¬×î»ù±¾µÄÉÌÒµ°æ± ......
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 ......
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 ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸ö ......