Oracle 9iµÄÊý¾ÝÀàÐÍ
Oracle 9i¹²ÌṩÁË16ÖÖ±êÁ¿Êý¾ÝÀàÐÍ£¬Èç±í7.4Ëùʾ¡£
±í7.4 Oracle 9iµÄ±êÁ¿Êý¾ÝÀàÐÍ
Ãû³Æ
º¬Òå
Char
ÓÃÓÚÃèÊö¶¨³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
varchar2
ÓÃÓÚÃèÊö±ä³¤µÄ×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=4000×Ö½Ú
nchar
ÓÃÀ´´æ´¢Unicode×Ö·û¼¯µÄ¶¨³¤×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=1000×Ö½Ú
nvarchar2
ÓÃÀ´´æ´¢Unicode×Ö·û¼¯µÄ±ä³¤×Ö·ûÐÍÊý¾Ý£¬³¤¶È<=1000×Ö½Ú
number
ÓÃÀ´´æ´¢ÕûÐÍ»òÕ߸¡µãÐÍÊýÖµ
Date
ÓÃÀ´´æ´¢ÈÕÆÚÊý¾Ý
Long
ÓÃÀ´´æ´¢×î´ó³¤¶ÈΪ2GBµÄ±ä³¤×Ö·ûÊý¾Ý
Raw
ÓÃÀ´´æ´¢·Ç½á¹¹»¯Êý¾ÝµÄ±ä³¤×Ö·ûÊý¾Ý£¬³¤¶È<=2000×Ö½Ú
Long raw
ÓÃÀ´´æ´¢·Ç½á¹¹»¯Êý¾ÝµÄ±ä³¤×Ö·ûÊý¾Ý£¬³¤¶È<=2GB
rowid
ÓÃÀ´´æ´¢±íÖÐÁеÄÎïÀíµØÖ·µÄ¶þ½øÖÆÊý¾Ý£¬Õ¼Óù̶¨µÄ10¸ö×Ö½Ú
Blob
ÓÃÀ´´æ´¢¶à´ï4GBµÄ·Ç½á¹¹»¯µÄ¶þ½øÖÆÊý¾Ý
Clob
ÓÃÀ´´æ´¢¶à´ï4GBµÄ×Ö·ûÊý¾Ý
nclob
ÓÃÀ´´æ´¢¶à´ï4GBµÄUnicode×Ö·ûÊý¾Ý
Bfile
ÓÃÀ´°Ñ·Ç½á¹¹»¯µÄ¶þ½øÖÆÊý¾Ý´æ´¢ÔÚÊý¾Ý¿âÒÔÍâµÄ²Ù×÷ϵͳÎļþÖÐ
urowid
ÓÃÀ´´æ´¢±íʾÈκÎÀàÐÍÁеØÖ·µÄ¶þ½øÖÆÊý¾Ý
float
ÓÃÀ´´æ´¢¸¡µãÊý
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1. ÒýÑÔ
2. ´¥·¢Æ÷µÄ¸ÅÄîºÍÀàÐÍ
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ËüÔÚ²åÈ룬ɾ³ý»òÐÞ¸ÄÌض¨±íÖеÄÊý¾Ýʱ´¥·¢Ö´ÐУ¬Ëü±ÈÊý¾Ý¿â±¾Éí±ê×¼µÄ¹¦ÄÜÓиü¾«Ï¸ºÍ¸ü¸´ÔÓµÄÊý¾Ý¿ØÖÆÄÜÁ¦¡£Êý¾Ý¿â´¥·¢Æ÷ÓÐÒÔϵÄ×÷Óãº
* °²È«ÐÔ¡£¿ÉÒÔ»ùÓÚÊý¾Ý¿âµÄÖµ ......
ͨ¹ýoracle 11g Á¬½Ómssql 2005 ±¨ÏÂÃæµÄ´íÎó
select * from maintanance@mssql
*
µÚ 1 ÐгöÏÖ´íÎó:
ORA-28545: Á¬½Ó´úÀíʱ Net8 Õï¶Ïµ½´íÎó
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: ½ô½Ó×Å 2 lines (Æð×Ô MSSQL)
oracle 11g listener.oraÅäÖÃÈçÏ£º
# listener.ora Network Configurati ......
OracleûÓÐ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐÍ£¬ÎÒÃÇÐèÒª½¨Á¢Ò»¸ö×Ô¶¯Ôö³¤µÄÐòÁкţ¬²åÈë¼Ç¼ʱҪ°ÑÐòÁкŵÄÏÂÒ»¸öÖµ¸³ÓÚ´Ë×ֶΣ¡
create sequence type_id increment by 1 start with 1;
Õâ¾äÖУ¬type_idΪÐòÁкŵÄÃû³Æ£¬Ã¿´ÎÔö³¤Îª1£¬ÆðʼÐòºÅΪ1¡£
Èç¹ûҪɾ³ýÐòÁУ¬ÓÃdrop sequence ÐòÁÐÃû¾Í¿ÉÒÔÁË£¡£¡
ÐòÁпÉÒÔ±£Ö¤¶à¸öÓû§¶ÔÍ¬Ò»Õ ......
OracleжÔØж²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
OracleжÔØж²»¸É¾»£¬Oracle³¹µ×ɾ³ýµÄ°ì·¨(winxp)
ÓÃoracleµÄжÔسÌÐò²¢²»ÄÜÍêȫжÔظɾ»¡£Èç֮ǰµÄÃüÃûµÄoracle sid ²»ÄÜÔÙʹÓ᣻áÌáʾsid´æÔÚ¡£ÏÂÃæÊÇÔÚwinxpÏÂÍêȫжÔØoracleµÄ·½·¨¡£
1¡¢¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ
&nbs ......