Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©


Oracle½âËøÓë¼ÓËø£¨hrÓû§ÎªÀý£©
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
SQL> conn sys/sys as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> desc dba_users
 Name &nbs ......

Oracle ʵÏÖÐÐÁÐת»»

SQL> DESC TEST  ²âÊÔ±í:        Name    Type            Nullable    Default Comments
       ----     ------------ &# ......

oracleÌåϵ½á¹¹¶þÖ®±í¿Õ¼ä¡¢·½°¸¡¢¶Î¡¢Çø¡¢¿é

     Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÊÇÊý¾Ý¿âÖÐ×îÖØÒªµÄÎļþ¡£ËüÃÇÊÇÊý¾Ý´æ´¢µÄµØ·½¡£Ã¿¸öÊý¾Ý¿âÖÁÉÙÓÐÒ»¸öÓëÖ®Ïà¹ØµÄÊý¾ÝÎļþ£¬Í¨³£Çé¿öϲ»Ö»Ò»¸ö£¬ÓкܶࡣÊý¾ÝÔÚÊý¾ÝÎļþÖÐÊÇÈçºÎ×éÖ¯µÄ£¿ÒªÁ˽âÕâЩÄÚÈÝÎÒÃÇÊ×ÏȱØÐëÀí½âʲôÊDZí¿Õ¼ä£¨tablespace£©¡¢¶Î£¨segment£©¡¢Çø£¨extent£©¡¢¿é£¨block£©£¬ÕâЩ¶¼ÊÇoracl ......

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

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

ʹÓÃimp/exp½øÐÐORACLEÊý¾Ý¿â±¸·ÝÓë»Ö¸´

 OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ