oracleÒì¹¹Á¬½Ómysql²éѯ³ö´í
ÏÖÔÚÏëÒªÓÃoracleÁ¬½ÓÒ»¸ömysqlÊý¾Ý¿â£¬ÏÖÔÚÒѾÅäÖóɹ¦£¬µ«ÊÇÔÚ²éѯmysqlÊý¾Ý¿âµÄÊý¾Ýʱ£¬ÓдíÎó£º
oracleÓëmysqlÔÚͬһ̨·þÎñÆ÷ÉÏhp 11.23 64λ
oracle:oracle 10.2.0.1 64λ
mysql:4.0 64λ
ÎÊÌ⣺
ÔÚ²éѯmysqlÊý¾Ý¿âÖеÄÊý¾Ýʱ£¬µ±²éѯһ¸öÊý¾ÝÁ¿±È½Ï´óµÄ±í£¨20ÒÚÌõ¼Ç¼ÒÔÉÏ£©£¬µÚÒ»´Î²éѯ²»»á³öÏÖ´íÎ󣬵«ÊÇÔÚ¼ä¸ôʱ¼ä±È½Ï¶Ì£¨10ÃëÒÔÄÚ£©£¬ÔÙÓÃͬһÌõSQLÓï¾äÈ¥²éѯmysqlʱ£¬¾Í»á³öÏÖÒÔÏ´íÎó£º
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][MySQL][ODBC 3.51
Driver][mysqld-4.0.24.4(+)-log]ÎÞ·¨´ò¿ªÎļþ: './test/test123.frm'
(´íÎóºÅ: 24) (SQL State: S0002; SQL Code: 1017)
ORA-02063: preceding 2 lines from DDD
ÇëÎʸ÷룬ÊÇÄĸöÖµÉèÖÃСÁË£¬»¹ÊÇÄÄÀï³ö´íÁË¡£
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......