RT
¶ÔsqlserverÎÒÊǷdz£ÊìϤµÄ£¬SQLÓï¾äҲûÎÊÌ⣬×î½ü¹«Ë¾ÐèÒª½¨Êý¾Ý¿âÒƵ½oracleÉÏ
¾ÍÊÇûʹÓùýoracle£¬¸üÏëÁ˽âoracleÊÇÈçºÎʹÓõģ¬µ±È»ÎÒÒ²ÏëÖªµÀ¸üÉî²ãµÄÔÀí£¬Ï£ÍûÓÐʵÓõÄÊé¼®¿ÉÒԲο¼£¬×îºÃÊǵç×ÓÎĵµ»òÕßÍøÕ¾£¨¸öÈ˱ȽÏϲ»¶£¬Êé¼®¿´µÄʱºò²»Òª×ö¶Ô±È£¬²éÕÒ£©
06/17/2008 09:37 AM 9,934,690 Addis ......
¸÷λÅóÓÑ£º
OracleÊý¾Ý¿âĬÈϵÄÁ´½Ó¶Ë¿ÚÊÇ1521£¬Èç¹ûÒªÐ޸ģ¬¸ÃÔõôÐ޸ģ¿
±»Ð޸ĺó£¬ÈçºÎ²é¿´Êý¾Ý¿âµ±Ç°Á´½ÓµÄÊÇÄĸö¶Ë¿ÚÄØ£¿
ÐÞ¸ÄÕìÌýÎļþlistener.ora,ÕÒµ½ÎļþÄÚÈÝPORT = 1521,°Ñ1521Ð޸ijÉÄãÐèÒªµÄ¶Ë¿Ú,ÖØÐÂÆô¶¯ÕìÌý·þÎñ.
лл£¬ÎÒÊÇÐÂÊÖ£¬ÕìÌýÎļþlistener.oraµÄλÖÃÔÚÄÄ£¿ÈçºÎÆô¶¯ÕìÌý·þÎñ£¿
°²×°ºó£¬ÅäÖù ......
ÓÐÒ»ÕűíA,ÊôÐÔid,name,extend,ÆäÖÐextend×Ö¶ÎΪ¿Õ£¬Ò»ÕűíC,ÊôÐÔid ,extend,c.extend²»Îª¿Õ,
ÆäÖбíC.idÊDZíA.id×Ó¼¯¡£ÏÖÔÚÐèҪʹÓÃSQLʵÏÖÕâÑùµÄ¹¦ÄÜ
Èç¹ûA.id = C.id ÄÇô a.extend = c.extend ·ñÔò a.extend = 0 £¿
select a.id,a.name,a.extend
from a,c
where a.id=c.id and a.extend = c.extend
union all
......
жÔØÁËoracle 9i£¬È»ºóÖØ×°oracle 9i,µ±Ò»¿ªÊ¼¼Ó²Ã²úÆ·µ½91%ʱͣס²»»á¶¯ÁË£¬ÊÔÁ˼¸´Î¶¼ÕâÑù£¬Ôõô½â¾ö
Jar class loader: oracle.sysman.oii.oiix.OiixJarClassLoader@770d2e
Locale: null
className: Components.oracle.server.v9_2_0_1_0.resources.CompRes
Error InvocationTargetException: java.util.MissingRe ......
ÒÔÏÂÊǽØÈ¡oracle´æ´¢¹ý³ÌµÄÒ»¸öƬ¶Î
tablename :='CLTX_'||cur_dt1||mm1;
dbms_output.put_line(tablename);
execute immediate 'select count(*) into '|| temp3||' from USER_TABLES where table_name='||tablename;
dbms_output.put_line('tem ......
ÇëÎʺó׺ΪdumpµÄÎļþºÍºó׺ΪdmpµÄÎļþÊÇÒ»ÑùµÄÂð£¬windowsϵͳÉϵÄoracleÄÜÓÃdumpºó׺µÄÎļþ×öimpÂð£¿
DMPÊÇOracleϵͳÖеÄת´¢Îļþ¡£
dmp ÊÇÂß¼±¸·ÝµÄµ¼³öÎļþ..
ûÓÐdump¸ñʽµÄÎļþ
oracleÖÐimp/expµ¼ÈëºÍµ¼³ö¶¼Ö§³Ödmp¸ñʽµÄÎļþ
ÒýÓÃ
ÇëÎʺó׺ΪdumpµÄÎļþºÍºó׺ΪdmpµÄÎļþÊÇÒ»ÑùµÄÂð£¬windowsϵͳÉÏ ......