sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔÀí£¿
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáʾµÄ»°£¬±¾È˽«Öطָм¤£¡
sqlplus ¾ÍÒ»¹¤¾ß£¬ËüÄÜÁ¬½Óµ½Êý¾Ý¿â²¢½øÐÐÏàÓ¦µÄ²Ù×÷¡£¼ÈÈ»Êǹ¤¾ß£¬ÎÒÃÇÖªµÀÔõôÓúÃËü¾Í¿ÉÒÔÁË£¬Ã»±ØÒªÈ¥Ñо¿ËüµÄÔÀí¡£µ±È»Èç¹ûÊÇ×öÕâ¿é¹¤¾ßÑо¿µÄ³ýÍâ.
ÄѲ»³ÉÂ¥Ö÷ҲҪдһ¸öÕâÀàÐ͵Ť¾ß?
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/architecture.htm#i1040997
這個連½Ó¿ÉÄÜÓÐ幫Öú
SQL code:
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
ÄǾÍÄÃÄãÕâ¸öÀý×ÓÀ´Ëµ°É
sqlplus /nolog Äã¿ÉÒÔÀí½âΪ¾ÍÊÇÔÚ²Ù×÷ϵͳÉÏÔËÐÐÁËSQLPLUSÕâ¸öÓ¦ÓóÌÐò ÒòΪ´Ëʱ²¢Ã»ÓÐÁ¬½Óµ½Êý¾Ý¿â
conn system/oracle Õâ¾ä»°¾ÍÊÇÖ´ÐÐÁ¬½ÓÁË
ORACLEµÄÁ¬½Ó·ÖÁ½ÖÖ·½Ê½ SHARED SERVER ºÍDEDICATED SERVER
Èç¹ûÊÇSHARED SERVER ·½Ê½Ï ÄÇô¿Í»§¶Ë·¢ÆðÒ»¸öÁ¬½ÓÇëÇó ·þÎñÆ÷¶ËµÄLISTENER»á¼àÌýµ½Á¬½ÓÇëÇó ½ÓÏÂÀ´°ÑÓû§Á¬½Óת½Óµ½Ò»¸ö½ÐDISPATCHERÉÏÈ¥ Ö®ºó¿Í»§¶Ë½ø³ÌºÍSERVER PROCESSµÄ½»»¥¾Íͨ¹ýÕâ¸öDISPATCHERÀ´½øÐÐ
Èç¹ûÊÇDEDICATED SERVER·½Ê½ ÄÇôµ±¿Í»§¶Ë·¢ÆðÒ»¸öÁ¬½ÓÇëÇóʱ ·þÎñÆ÷¶ËµÄLISTENER»áÅÉÉú³öÒ»¸öרÓнø³ÌÓë¿Í»§¶Ë½øÐнøÐн»»¥(´Ë´¦Ö®ËùÒÔ˵רÓÐÊǺÍǰһÖÖģʽSHARED SERVER ¶Ô±È¶øÑÔ ¡£ÒòΪһ¸öDISPATCHER¿ÉÒÔ·þÎñ¶à¸ö¿Í»§¶Ë½ø³Ì)
¸üÏêϸµÄ¹Ù
Ïà¹ØÎÊ´ð£º
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£
ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º
IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......