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

oracle¶àʵÀý£¿¶àÊý¾Ý¿â£¿

ÎÒÓÃdbca½¨Á¢ÁËÁ½¸öÊý¾Ý¿â£¬ÄÇô»ú×ÓÉϾʹæÔÚÁ½¸öʵÀýÁË£¬ÊÇÕâÑùµÄô£¿

Èç¹ûÊÇÕâÑù£¬ÕâÁ½¸öʵÀý¿ÉÒÔͬʱÔËÐÐô£¿Ò²¾ÍÊÇÄÜ·ñͬʱ֧³ÖÁ½¸öÓ¦Óã¿

ÎÒ²âÊÔÁËһϣ¬ÕâÁ½¸öÊý¾Ý¿âºÃÏñ¿ÉÒÔÓÃͬһ¸ö¼àÌý£¿ÄѵÀÁ½¸öʵÀýÓÃͬ¸ö¶Ë¿Ú£¿

ÄÄλ¿ÉÒÔ¸úÎÒ˵˵¶àʵÀýµÄÎÊÌâ°¡£¿Ð»Ð»À²¡­¡­

ÒýÓÃ
ÎÒÓÃdbca½¨Á¢ÁËÁ½¸öÊý¾Ý¿â£¬ÄÇô»ú×ÓÉϾʹæÔÚÁ½¸öʵÀýÁË£¬ÊÇÕâÑùµÄô£¿
yes

Èç¹ûÊÇÕâÑù£¬ÕâÁ½¸öʵÀý¿ÉÒÔͬʱÔËÐÐô£¿Ò²¾ÍÊÇÄÜ·ñͬʱ֧³ÖÁ½¸öÓ¦Óã¿
¿ÉÒÔͬ時運ÐУ¬Ö»ÓÐÄãµÄ計Ëã機µÄ資Ô´×ã夠£»¿ÉÒÔͬ時Ö§³Ö兩個應ÓÃ

ÎÒ²âÊÔÁËһϣ¬ÕâÁ½¸öÊý¾Ý¿âºÃÏñ¿ÉÒÔÓÃͬһ¸ö¼àÌý£¿ÄѵÀÁ½¸öʵÀýÓÃͬ¸ö¶Ë¿Ú£¿
listener¿ÉÒÔÓÃͬһ個¶Ë¿Ú£¬²»ÊÇ說兩個實ÀýʹÓÃͬһ個¶Ë¿Ú¡£


ÄÇôÇëÎÊһϣ¬ÊÇÓÃͬ¸öʵÀýÖ§³Ö¶à¸öÓ¦Óú㬻¹ÊÇÿ¸öÓ¦ÓÃʹÓÃÒ»¸öʵÀýºÃÄØ£¿

這個問題µÄ±È較²»ºÃ說£¬Òò爲沒ÓÐ試過¡£
²»¿¼慮資Ô´問題µÄ話£¬Ã¿個應ÓÃʹÓÃÒ»個實ÀýºÃ£º
Èç¹ûÓÉì¶應ÓÃa¶øÐèÒªÖØÆð實Àý£¬¾Í²»會Ó°響µ½ÆäËû實Àý¡£

ÒýÓÃ
這個問題µÄ±È較²»ºÃ說£¬Òò爲沒ÓÐ試過¡£
²»¿¼慮資Ô´問題µÄ話£¬Ã¿個應ÓÃʹÓÃÒ»個實ÀýºÃ£º
Èç¹ûÓÉì¶應


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ