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

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


ÇëÎʸ÷룬ÊÇÄĸöÖµÉèÖÃСÁË£¬»¹ÊÇÄÄÀï³ö´íÁË¡£


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ