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

tabÊý¾Ýת»»µ½oracle spatial

1£ºmapinfoµÄtab¸ñʽÊý¾Ý£¬µ¼Èëµ½oracle spatial
 ´ò¿ªmapinfo £¬
µã»÷¹¤¾ß---¹¤¾ß¹ÜÀíÆ÷
 
¹´Ñ¡easyloader
´ò¿ªeasyloader
ÔÚ¹¤¾ß²Ëµ¥ÉϾͿÉÒÔ¿´µ½easyloader
 µã»÷odbc
µã»÷»úÆ÷Êý¾ÝÔ´£ºÏÂÒ»²½
 
Ñ¡Ôñoralce
 
Êý¾ÝÔ´Ãû³Æ£º×îºÃ¶¼oracle sidÒ»Ñù
ÃèÊö¿ÉÒÔ²»Ð´
Óû§Ãû³Æ£ºoracle user
·þÎñÆ÷£º²»ÊÇip£¬Ìîдoracle ·þÎñÃû
 È»ºóÔÚµã»÷oracle spatial
Óû§id£ºoracle user
¿ÚÁoracle password
·þÎñÆ÷ ¾ÍÊÇÉÏÃæÌîдµÄ·þÎñÃû
È·¶¨ºó»á³öÏÖÈçϽçÃæ£º
Ñ¡ÔñÔ´±í.tab,Ìîд±íÃ÷£¬×îºÃ²»ÒªÓÃÖÐÎÄ
È»ºóÉÏ´«¾ÍÐÐÁË


Ïà¹ØÎĵµ£º

oracleÌåϵ½á¹¹Ò»

        oracleÊÇÒ»ÖÖ´óÐ͵ġ¢¿ÉÒÆÖ²µÄ¶ÔÏó¹ØÏµÐÍÊý¾Ý¿â¡£ËüÔÚÏà¹ØµÄÿһ¸öƽ̨É϶¼¿ÉÒÔÔËÐУ¬Òò´ËoracleµÄÌåϵ½á¹¹ÔÚ²»Í¬µÄ²Ù×÷ϵͳÉÏÊÇÓÐËù²»Í¬µÄ¡£±ÈÈçÔÚUNIXϵͳÉÏ£¬ÒòΪUNIXϵͳÊǹ¤×÷ÔÚ¶à½ø³ÌµÄ»ù´¡ÉÏ£¬ËùÒÔoracleÔËÐÐʱÌåÏÖΪ¶à¸ö½ø³ÌÔÚÔËÐС£È»¶øÔÚwindowsϵͳÉÏ£¬windowsÏµÍ³Ê ......

oracleÁ¬½Ó×Ö·û´®½âÎö

      ÔÚÒ»¸ö»ùÓÚTCP/IPЭÒéµÄÍøÂç»·¾³ÖУ¬oracleÊý¾Ý·þÎñÆ÷ÔÚһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÔÚÁíÍâһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÒªÁ¬½Óµ½oracle·þÎñÆ÷ÎÒÃǾ­³£»áÊäÈ룺"C£º\sqlplus scott/tiger@shanghai"£¬ÕâÊÇoracle¿Í»§¶ËÁ¬½Ó·þÎñÆ÷ʱʹÓõÄÁ¬½ÓÃüÁÆäÖÐsqlplusÊÇoracle¿Í»§¶Ë³ÌÐò£¬scott/tigerÊǵǽ·þ ......

Oracle×ܽá


Oracle
Ò»¡¢Êý¾Ý¿âÓïÑÔ£º
DCL:Êý¾Ý¿â¿ØÖÆÓïÑÔ(ÈçÊÂÎñ...)
DQL:Êý¾Ý¿â²éѯÓïÑÔ(select...)
DDL:Êý¾Ý¿â¶¨ÒåÓïÑÔ(create)
DML:Êý¾Ý¿â²Ù×÷ÓïÑÔ(¸üÐÂ....)
¶þ¡¢Oracle°æ±¾£º
Oracle8I   i£º»¥ÁªÍø
Oracle10g g£ºÍø¸ñ£º°Ñ¸´ÔÓµÄÎÊÌâ·Ö²¼´¦Àí£¬×îºó°Ñ½á¹û×ۺϳÉ×î×ܽá¹û
°Ñ¸´ÔÓµÄÎÊÌâ·Ö²¼´¦Àí£¬×îºó°Ñ½á¹û×Ûº ......

ORACLE ´´½¨Êý¾Ý¿âÁ¬½ÓDBLink

CREATE PUBLIC DATABASE LINK ASXT_LINK ;
CONNECT TO ASXT IDENTIFIED BY PASSWORD ;
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = AAA)))'; ......

oracle Ë÷ÒýµÄÀàÐÍÏà¹Ø

Ò»¡¢Ë÷ÒýÀàÐͼ°½á¹¹£º
 
oracleµÄË÷Òý·ÖΪ5ÖÖ:ΨһË÷Òý£¬×éºÏË÷Òý£¬·´Ïò¼üË÷Òý£¬Î»Í¼Ë÷Òý£¬»ùÓÚº¯ÊýµÄË÷Òý
 
Âß¼­ÉÏ£º
Single column µ¥ÁÐË÷Òý
Concatenated ¶àÁÐË÷Òý
Unique ΨһË÷Òý
NonUnique ·ÇΨһË÷Òý
Function-basedº¯ÊýË÷Òý
Domain ÓòË÷Òý
ÎïÀíÉÏ£º
Partitioned ·ÖÇøË÷Òý
NonPartitioned ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ