Ò»¸öoracleСÎÊÌâ
ÎÒÓиöcontent×ֶΣ¬´æµÄ¶¼ÊÇÖÐÎÄÄÚÈÝ£¬ºÜ¶à£¬ÎÒÓÃvarchar2(4000)ÀàÐÍÒ²²»¹»Óð¡
ÓÐʲô·½·¨¿ÉÒÔ±£´æ´óÁ¿µÄÖÐÎÄÄÚÈÝ£¿¸æËßÎÒÏÂ
ÓÃclobÀàÐÍ×ֶΰÉ
1 LOB£¨CLOB/BLOB£©
2 LONG
3 ·ÖÁÐ
ORACLE½¨ÒéʹÓÃLOB£¬ÁíÍâLONGÀàÐÍÒ»¸ö±íÖ»ÄÜÓÐÒ»ÁС£
Èç¹û8000ÒÔÄÚ£¬½¨Òé·ÖÁ½ÁУ¬LOB¸ø¹ÜÀíºÍÊý¾ÝÇ¨ÒÆ´øÀ´²»±ã
clob ×Ö·ûÐÍ´ó¶ÔÏ󣬿ÉÒÔ´æ´¢Îı¾ÐÍ×Ö·ûÊý¾Ý£¬×î´óÈÝÁ¿¿É´ï4GB
blob ¶þ½øÖÆ´ó¶ÔÏó£¬Ò»°ãÓÃÓڴ洢ͼƬµÈ¶þ½øÖÆÊý¾Ý£¬×î´óÈÝÁ¿¿É´ï4GB
ºÇºÇ£¬ÖªµÀÀ²£¬Ð»Ð»ÄãÃÇ£¬½áÌù
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨
ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12518, TNS:listener could not hand off cli ......