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

oracleÖÐdual±íµÄÓ÷¨

dualÊÇÒ»¸öÐéÄâ±í£¬ÓÃÀ´¹¹³ÉselectµÄÓï·¨¹æÔò£¬oracle±£Ö¤dualÀïÃæÓÀÔ¶Ö»ÓÐÒ»Ìõ¼Ç¼¡£ÎÒÃÇ¿ÉÒÔÓÃËüÀ´×öºÜ¶àÊÂÇ飬ÈçÏ£º
1¡¢²é¿´µ±Ç°Óû§£¬¿ÉÒÔÔÚ SQL PlusÖÐÖ´ÐÐÏÂÃæÓï¾ä select user from dual;
2¡¢ÓÃÀ´µ÷ÓÃϵͳº¯Êý
    select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;--»ñµÃµ±Ç°ÏµÍ³Ê±¼ä
   select SYS_CONTEXT('USERENV','TERMINAL') from dual;--»ñµÃÖ÷»úÃû
    select SYS_CONTEXT('USERENV','language') from dual;--»ñµÃµ±Ç°      locale
select dbms_random.random from dual;--»ñµÃÒ»¸öËæ»úÊý
3¡¢µÃµ½ÐòÁеÄÏÂÒ»¸öÖµ»òµ±Ç°Öµ£¬ÓÃÏÂÃæÓï¾ä
    select your_sequence.nextval from dual;--»ñµÃÐòÁÐyour_sequenceµÄÏÂÒ»¸öÖµ
   select your_sequence.currval from dual;--»ñµÃÐòÁÐyour_sequenceµÄµ±Ç°Öµ
4¡¢¿ÉÒÔÓÃ×ö¼ÆËãÆ÷ select 7*9 from dual;
------
OracleϵͳÖÐdual±íÊÇÒ»¸ö“ÉñÃØ”µÄ±í£¬ÍøÉÏÓкܶàÍøÓѶ¼¶Ô¸Ã±í½øÐÐÁ˲âÊÔ£¬¸Ã±íÖ»ÓÐÒ»ÐÐÒ»ÁУ¬Æäʵ¸Ã±íºÍϵͳÖÐµÄÆäËû±íÒ»Ñù£¬Ò»Ñù¿ÉÒÔÖ´ÐвåÈë¡¢¸üС¢É¾³ý²Ù×÷£¬»¹¿ÉÒÔÖ´ÐÐdrop²Ù×÷¡£µ«ÊDz»ÒªÈ¥Ö´ÐÐdrop±íµÄ²Ù×÷£¬·ñÔò»áʹϵͳ²»ÄÜÓã¬Êý¾Ý¿âÆð²»ÁË£¬»á±¨Database startup crashes with ORA-1092´íÎó¡£´ËʱҲ²»Òª»ÅÂÒ£¬¿ÉÒÔͨ¹ýÖ´ÐÐÒÔϲ½ÖèÀ´½øÐлָ´¡£¿ÉÒÔÓÃsysÓû§µÇ½¡£
SQL> create pfile=’d:pfile.bak’ from spfile
SQL> shutdown immediate
ÔÚd:pfile.bakÎļþÖÐ×îºó¼ÓÈëÒ»Ìõ£º
replication_dependency_tracking = FALSE
ÖØÐÂÆô¶¯Êý¾Ý¿â£º
SQL> startup pfile=’d:pfile.bak’
SQL> create table “sys”.”DUAL”
[an error occurred while processing this directive]
=====
DUAL ? ÓÐʲôÉñÃØµÄ? µ±ÄãÏëµÃµ½ORACLEϵͳʱ¼ä, ¼ò¼òµ¥µ¥ÇÃÒ»ÐÐSQL¡¡²»¾ÍµÃÁËÂð? ¹ÊŪÐþÐé….¡¡
SQL> select sysdate from dual;¡¡
SYSDATE¡¡
---------¡¡
28-SEP-03¡¡
¹þ¹þ, ȷʵDUALµÄʹÓúܷ½±ã. µ«ÊÇ´ó¼ÒÖªµÀDUALµ¹µ×ÊÇʲôOBJECT, ËüÓÐÊ²Ã´ÌØÊâµÄÐÐΪÂð? À´,ÎÒÃÇÒ»Æð¿´Ò»¿´.¡¡Ê×ÏȸãÇå³þDUALÊÇʲôOBJECT :¡¡
SQL> connect system/manager¡¡
Connected.¡¡
SQL> select owner, object_name , object_type from dba_objects where object_name like '%DUAL%';¡¡OWNER O


Ïà¹ØÎĵµ£º

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Ò»)

1.λͼË÷Òý
×î½üÎÒ²ÎÓëÁËÒ»¸öÏîÄ¿¡£¿ª·¢ÈËÔ±Õý±¥ÊÜÐÔÄÜÎÊÌâÖ®¿à£¬¿´ÉÏÈ¥ËûÃǵÄϵͳÖÐÐí¶àÊÂÎñÔÚ´®ÐÐ
½øÐС£ËûÃǵÄ×ö·¨²»ÊÇ´ó¼Ò²¢·¢µØ¹¤×÷£¬¶øÊÇÿ¸öÈ˶¼ÒªÅÅÒ»¸ö³¤³¤µÄ¶Ó£¬¿à¿àµÈ×ÅÇ°ÃæµÄÈËÍê³Éºó²ÅÄÜ
¼ÌÐø¡£Ó¦Óüܹ¹Ê¦ÏòÎÒչʾÁËϵͳµÄÌåϵ½á¹¹£¬ÕâÊǾ­µäµÄÈý²ã·½·¨¡£ËûÃÇÏëÈÃWeb ä¯ÀÀÆ÷ÓëÒ»¸öÔËÐÐJSP
£¨JavaServer Pa ......

oracle asm ´´½¨Óë¹ÜÀí

 
ASM
ASM¿ÉÒÔÌõ´ø»¯ºÍ¾µÏñ´ÅÅÌ£¬Òò´Ë¿ÉÒÔÔÚÊý¾Ý¿â±¸¼ÓÔØµÄÇé¿öÏÂÌí¼Ó¡¢É¾³ý´ÅÅÌ¡¢ÒÔ¼°×Ô¶¯Æ½ºâIO¡£
ASM²»ÊÇÒ»¸öÎļþϵͳ£¬ËùÒÔÎÞ·¨´Ó²Ù×÷ϵͳ·ÃÎÊASM´æ´¢µÄÎļþ£¬¶ÔÓÚʹÓÃASMµÄÊý¾Ý¿âÖ»ÄÜÓÃRMAN½øÐб¸·ÝºÍ»Ö¸´¡£
ASM×÷Ϊµ¥¶ÀµÄORACLEʵÀýʵʩ£¬Ö»ÓÐASMÔËÐÐʱÊý¾Ý¿â²ÅÄÜ·ÃÎÊ¡£
Ò»¡¢´ÅÅÌ×é
ASMÌṩÁËÈýÖдÅÅÌ×éÀà ......

oracleÒþ²Ø²ÎÊý²éѯ

ËäÈ»ÍøÉÏÓкܶ࣬µ«»¹ÊÇÔÚÕâÀï¼ÇÏ·½±ã²éÕÒ£º
SELECT i.ksppinm NAME, i.ksppity TYPE, v.ksppstvl VALUE, v.ksppstdf isdefault
  from x$ksppi i, x$ksppcv v
 WHERE i.indx = v.indx
   AND i.ksppinm LIKE '\_%&par%' ESCAPE '\';
......

½â¾öÐ޸ļÆËã»úÃûOracleÎÞ·¨Æô¶¯µÄÎÊÌâ

°²×°Oracle Database(10.0.2)ºó£¬Èç¹ûÐ޸ĻúÆ÷Ãûºó£¬
»áµ¼Ö¿ØÖÆÃæ°åµÄ·þÎñÖÐÆô¶¯OracleTNSLisener·þÎñÁ¢¿Ì¾ÍÍ£Ö¹¡£
ʹÓÃÃüÁîÐй¤¾ß£¬ÌáʾÈçÏ£º
(»úÆ÷ÃûÔ­À´Îª£ºANSWER-1738E000£¬¸ÄΪ£ºANSWER)
 
½â¾ö·½·¨£º
1>¹Øµô¿ØÖÆÃæ°åÖÐÓйØÓÚ Oracle Database µÄ·þÎñ¡£
2>ÐÞ¸Ä C:\oracle\product\10.2.0\db_1\NE ......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Èý)

 1.¶à°æ±¾£º¶ÁÒ»Ö²éѯ  ·Ç×èÈû²éѯ
Oracle ²ÉÓÃÁËÒ»ÖÖ
¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7 Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£
²»¹ý£¬ÊµÖÊÉϽ²£¬Oracle ÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽá¹û¡£
·Ç×èÈû²éѯ£º²éѯ²»» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ