ORACLE Óë mysql µÄÇø±ð
1.ÔÚORACLEÖÐÓÃselect * from all_usersÏÔʾËùÓеÄÓû§£¬¶øÔÚMYSQLÖÐÏÔʾËùÓÐÊý¾Ý¿âµÄÃüÁîÊÇshow databases¡£¶ÔÓÚÎÒµÄÀí½â£¬ORACLEÏîÄ¿À´ËµÒ»¸öÏîÄ¿¾ÍÓ¦¸ÃÓÐÒ»¸öÓû§ºÍÆä¶ÔÓ¦µÄ±í¿Õ¼ä£¬¶øMYSQLÏîÄ¿ÖÐÒ²Ó¦¸ÃÓиöÓû§ºÍÒ»¸ö¿â¡£ÔÚORACLE(db2Ò²Ò»Ñù)Öбí¿Õ¼äÊÇÎļþϵͳÖеÄÎïÀíÈÝÆ÷µÄÂß¼±íʾ£¬ÊÓͼ¡¢´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÒ²¿ÉÒÔ±£´æÔÚ±í¿Õ¼äÖС£¶øMYSQL²¢Ã»ÓÐʹÓñí¿Õ¼äÀ´½øÐйÜÀí¡£
2.²éѯµ±Ç°ËùÓÐµÄ±í¡£ORACLE£º select * from tab£¬MYSQL£ºshow tables¡£
3.¸Ä±äÁ¬½ÓÓû§(¿â)¡£ORACLE£ºconn Óû§Ãû/ÃÜÂë@Ö÷»ú×Ö·û´®£¬MYSQL£ºuse ¿âÃû¡£
4.ÏÔʾµ±Ç°Á¬½ÓÓû§(¿â)¡£ORACLE£ºshow user£¬MYSQL£ºconnect¡£
5.Ö´ÐÐÍⲿ½Å±¾ÃüÁî¡£ORACLE£º@a.sql£¬MYSQL£ºsource a.sql¡£
±È°æ±¾
Personal Oracle 10
mysql 5.1
ĬÈÏ°²×°Ä¿Â¼
¿ÉÑ¡Ôñ
C:\program files\MYSQL
¸÷ÖÖʵÓóÌÐòËùÔÚĿ¼
¿ÉÑ¡Ôñ
C:\program files\\BIN
¿ØÖÆ̨¹¤¾ß
SVRMGR.EXE
SVRMGR23.EXE
mysqladmin.exe
Êý¾Ý¿âÆô¶¯³ÌÐò
0start73.exe screen
mysqld-shareware.exe
¹Ø±ÕÊý¾Ý¿âÃüÁî
ostop73.exe
mysqladmin.exe -u root shutdown
¿Í»§³ÌÐò
SQL*Plus
mysql
Æô¶¯ÃüÁî
c:\orawin95\bin\sqlplus.exe
c:\mysql\bin\mysql.exe
´øÓû§Æô¶¯·½Ê½
£¨Ö±½ÓÁ¬¿â·½Ê½£©
c:\orawin95\bin\sqlplus.exe system/manager@TNS
c:\mysql\bin\mysql.exe test
c:\mysql\bin\mysql.exe -u root test
°²×°ºóϵͳĬÈÏÓû§£¨¿â£©
sys
system
scott
mysql
test
ÏÔʾËùÓÐÓû§£¨¿â£©
SQL >select * from all_users;
C:\mysql\bin>mysqlshow
C:\mysql\bin>mysqlshow --status
mysql> show databases;
Í˳öÃüÁî
SQL> exit
SQL> quit
mysql> exit
mysql> quit
¸Ä±äÁ¬½ÓÓû§£¨¿â£©
Ïà¹ØÎĵµ£º
ÔÚArcGISÖÐͨ¹ýSDE´æ´¢¿Õ¼äÊý¾Ýµ½OracleÖÐÓжàÖÖ´æ´¢·½Ê½£¬·Ö±ðÓУº¶þ½øÖÆLong Raw ¡¢ESRIµÄST_GeometryÒÔ¼°»ùÓÚOracle SpatialµÄSDO_GeometryµÈµÈ¡£
¹ØÓÚÕ⼸ÖÖ·½Ê½µÄ¸÷×ÔµÄÓÅȱµã²»ÊÇÖ÷ÒªµÄ̽Ìֵķ½Ïò£¬ÕâЩÎÒÃÇ¿ÉÒÔͨ¹ýArcGISÖеÄArcGIS Server HelpµÃµ½Ïà¹ØµÄ°ïÖú¡£ÕâÀïÖ÷Ò ......
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)))'; ......
2010-03-02 16:12:01,515 ERROR (Prototyper.java:105) - Prototype
java.sql.SQLException: Io Òì³£: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(Da ......
Linux ƽ̨ÏÂOracle Silent Installations(¾²Ä¬°²×°)£¬Ò»Ö±¶¼Ã»Óг¢ÊÔ¹ýÓÃÕâÖÖ·½·¨À´×°Êý¾Ý¿â¡£ ÒòΪÓи߼¶µÄ¹¤¾ß£¬¾ÍûÓбØÒªÔÚÀ´ÓÃÕâÖÖ·½·¨ÁË£¬Oracle µÄ½çÃ滹ÊDZȽϷ½±ã£¬¶øÇÒÎÒÃÇ»¹ÓÐXmanager ¹¤¾ß£¬ËùÒÔÔÚlinux ÏÂ×°Èí¼þ£¬»¹ÊǺܷ½±ãµÄ¡£
Òò´ËÒ²¾ÍûÓÐÌ«ÔÚÒâÕ ......
##/etc/my.cnf:
# [mysql]
# default-character-set=utf8
# [mysqld]
# character-set-server=utf8
# collation-server=utf8_general_ci
# [client]
# default-character-set=utf8
/etc/init.d/mysqld stop
/etc/init.d/mysqld start
# dump db
mysqldump -u dbuser -pdbpass --opt --skip-set-charset --defaul ......