¹ØÓÚORACLE¼àÌý·þÎñÎÞ·¨Æô¶¯µÄÎÊÌâ
½ñÌìµçÄÔÄûؼң¬Æô¶¯oracleÊý¾Ý¿âµÄ¼àÌý·þÎñʱ·¢ÏÖÎÞ·¨Æô¶¯¡£¸ø³öµÄ´íÎóÌáʾÊÇ˵£¬Õâ¸ö·þÎñÆô¶¯ÁËÓÖÍ£Ö¹ÁË£¬²»ÖªµÀÊÇΪʲô¡£ÒòΪÔÚѧУµÄʱºòÓÃÊÇûÓÐÎÊÌâµÄ¡£ÎÒÏëÓ¦¸ÃÊÇÒòΪipµÄÊÇÎÊÌâ¡£ÔÚÍøÉϲéÁËһϣºÄãÊÇ·ñÐÞ¸ÄÄãµÄ»úÆ÷Ãû»òIPµØÖ·£¬Èç¹ûÓÐÐ޸ģ¬°ÑORACLE\ora81\network\admin\listener.oraÎļþÖеÄhostÐÞ¸ÄΪлúÆ÷Ãû»òIP¡£ÎÒÓõÄÊÇoracle 10g£¬listener.oraµÄĿ¼ÔÚD:\oracle\product\10.1.0\db_1\NETWORK\ADMINÏ¡£listener.oraÎļþµÄÄÚÈÝÈçÏ£º
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.5)(PORT = 1521))
)
)
)
ÐÞ¸ÄΪ£º
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
Ïà¹ØÎĵµ£º
ORACLEÄÚ²¿º¯Êýƪ
¡¡¡¡ 255. CHARTOROWID(CHAR)
¡¡¡¡ ½«°üº¬ÍⲿÓï·¨ROWIDµÄCHAR»òVARCHAR2Êýֵת»»ÎªÄÚ²¿µÄ¶þ½øÖÆÓï·¨,²ÎÊýCHAR±ØÐëÊÇ°üº¬ÍⲿÓï·¨µÄROWIDµÄ18×Ö·ûµÄ×Ö·û´®.
¡¡¡¡ SELECT NAME from BSEMPMS WHERE ROWID=CHARTOROWID('AAAAfZAABAAACp8AAO');
¡¡¡¡ NAME : LEIXUE
¡¡¡¡ 256. CONVERT(CHAR,DEST_CHA ......
×î½ü×ܽáÁËÒ»ÏÂoracleÖ÷¼üµÄÉèÖ÷½·¨£¬Ìùµ½Õâ±£´æһϰɡ£ ÓÐÁ½ÖÖ·½·¨¿ÉÒÔÉèÖÃÖ÷¼ü£¬Ò»ÖÖÊÇ×ÔÔö³¤Ö÷¼ü£¬ÁíÒ»ÖÖ¾ÍÊÇÉú³ÉΨһÐòÁС£ Ò»¡¢×ÔÔö³¤Ö÷¼ü --Ê×ÏȽ¨Ò»¸ö±íTEST
create tableTEST (
NID int PRIMARY KEY,
test1 varchar2(20),
test2 varchar2(20),
test3 ......
ÔÚÏÖ´úµÄ¶àÓû§¶àÈÎÎñϵͳÖУ¬±ØÈ»»á³öÏÖ¶à¸öÓû§Í¬Ê±·ÃÎʹ²ÏíµÄij¸ö¶ÔÏó£¬Õâ¸ö¶ÔÏó¿ÉÄÜÊÇ±í£¬ÐУ¬»òÕßÄÚ´æ½á¹¹£¬ÎªÁ˽â¾ö¶à¸öÓû§²¢·¢ÐÔ·ÃÎÊ´øÀ´µÄÊý¾ÝµÄ°²È«ÐÔ£¬ÍêÕûÐÔ¼°Ò»ÖÂÐÔÎÊÌ⣬±ØÐëÒªÓÐÒ»ÖÖ»úÖÆ£¬À´Ê¹¶ÔÕâЩ¹²Ïí×ÊÔ´µÄ²¢·¢ÐÔ·ÃÎÊ´®Ðл¯£¬oracleÖеÄËø¾Í¿ÉÒÔÌṩÕâÑùµÄ¹¦ÄÜ£¬µ±ÊÂÎñÔÚ¶Ôij¸ö¶ÔÏó½ ......
winÏÂÿÌì×Ô¶¯±¸·ÝÊý¾Ý¿âÅú´¦ÀíÎļþ£º
(×¢ÒªºÍexpÎļþ·ÅͬһĿ¼£¬È»ºó½¨Á¢Ò»¸öÈÎÎñ¼´¿É)
exp userid=user/pass file=i:\dmpos%date:~0,10%.dmp log=i:\dmpos%date:~0,10%.log
exp userid=user/pass file=/demo/oaback/dmp/dat$tim.dmp
Ò». µ¼³ö¹¤¾ß exp
1. ËüÊDzÙ×÷ϵͳÏÂÒ»¸ö¿ÉÖ´ÐеÄÎļþ ´æ·ÅĿ¼/ORACLE_HO ......