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Óû§ÎªÀý£©
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 ......
SQL> DESC TEST ²âÊÔ±í: Name Type Nullable Default Comments
---- ------------ ......
Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÊÇÊý¾Ý¿âÖÐ×îÖØÒªµÄÎļþ¡£ËüÃÇÊÇÊý¾Ý´æ´¢µÄµØ·½¡£Ã¿¸öÊý¾Ý¿âÖÁÉÙÓÐÒ»¸öÓëÖ®Ïà¹ØµÄÊý¾ÝÎļþ£¬Í¨³£Çé¿öϲ»Ö»Ò»¸ö£¬ÓкܶࡣÊý¾ÝÔÚÊý¾ÝÎļþÖÐÊÇÈçºÎ×éÖ¯µÄ£¿ÒªÁ˽âÕâЩÄÚÈÝÎÒÃÇÊ×ÏȱØÐëÀí½âʲôÊDZí¿Õ¼ä£¨tablespace£©¡¢¶Î£¨segment£©¡¢Çø£¨extent£©¡¢¿é£¨block£©£¬ÕâЩ¶¼ÊÇoracl ......
ÔÚÒ»¸ö»ùÓÚTCP/IPÐÒéµÄÍøÂç»·¾³ÖУ¬oracleÊý¾Ý·þÎñÆ÷ÔÚһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÔÚÁíÍâһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÒªÁ¬½Óµ½oracle·þÎñÆ÷ÎÒÃǾ³£»áÊäÈ룺"C£º\sqlplus scott/tiger@shanghai"£¬ÕâÊÇoracle¿Í»§¶ËÁ¬½Ó·þÎñÆ÷ʱʹÓõÄÁ¬½ÓÃüÁÆäÖÐsqlplusÊÇoracle¿Í»§¶Ë³ÌÐò£¬scott/tigerÊǵǽ·þ ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......