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

oracle Êý¾Ý×ÖµäÊÓͼ֮ DICT / DICTIONARY

1.µ±ÄãÃÍÈ»¼äÍü¼Çͨ¹ýʲôÊÓͼ¿ÉÒԲ鿴procedureÄÚÈÝʱ£¬ÒþÔ¼¼ÇµÃËùÐèµÄÊÓͼ°üº¬“SOUR”×ֶΣ¬´Ëʱ²éѯdict/dictionaryÊÓͼÊÇ×îºÃµÄÑ¡Ôñ
sys@ora10g> col COMMENTS for a78
sys@ora10g>select * from dict where TABLE_NAME like '%SOUR%';
TABLE_NAME                     COMMENTS
------------------------------ -----------------------------------------------------------
USER_RESOURCE_LIMITS           Display resource limit of the user
ALL_SOURCE_TABLES              Source tables available for Change Data Capture
DBA_SOURCE_TABLES              Source tables available for Change Data Capture
USER_SOURCE_TABLES             Source tables available for Change Data Capture
USER_SOURCE                    Source of stored objects accessible to the user
ALL_SOURCE                     Current source on stored objects that user is allowed to create
DBA_SOURCE                     Source of all stored objects in the database
DBA_TSM_SOURCE                 Transparent session migration source session statistics
DBA_HIST_RESOURCE_LIMIT        Resource Limit Historical Statistics Information
DBA_RESOURCE_INCARNATIONS      Resource incarnations that are running or eligible for HA status notification
RESOURCE_C


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle 9iÖеÄflash back ²éѯ


Óï·¨:
select *
from [TABLE] as of timestamp
to_timestamp('ʱ¼ä', ’ʱ¼ä¸ñʽ')
 
×÷Óãº
²éѯij¸öʱ¼äµãµÄÊý¾Ý£¬ÔÚÕâ¸öʱ¼äµãÖ®ºó£¬Êý¾Ý¸ü¸ÄÒѾ­Ìá½»ÁË¡£
¿ÉÒÔÓÃÀ´¸üÕýÓû§¶ÔÊý¾ÝµÄÎó²Ù×÷
¿ÉÒÔÓÃÀ´»ñÈ¡Êý¾ÝµÄ¸ü¸ÄÇé¿ö£¬±ÈÈçÆµÂʵÈ
 
Ô­Àí£º
µ±Êý¾Ýupdate»òdeleteʱ£¬Ô­À´µÄÊý¾Ý ......

OracleÖÐDelete²Ù×÷µÄÁ÷³Ì

¸Õ²ÅÔÚEYGLEµÄ²©¿ÍÖп´µ½Ò»ÆªÌû×Ó£¬½²µÄÊÇDELETEµÄ²Ù×÷Á÷³Ì£¬ºÜ¼ò¶Ì£¬Í¬Ê±Ò²¾«±Ù¡£
===================================================================================
OracleÖУ¬Ò»¸öDelete²Ù×÷µÄÁ÷³Ì
ɾ³ý(DELETE)
1.Oracle¶ÁBlockµ½Buffer Cache(Èç¹û¸ÃBlockÔÚBufferÖв»´æÔÚ)
2.ÔÚredo log bufferÖмǼdelet ......

LinuxÏÂÆô¶¯Oracle·þÎñºÍ¼àÌý³ÌÐò(»ù´¡ÖªÊ¶)

 
oracleÊý¾Ý¿âÊÇÖØÁ¿¼¶µÄ£¬Æä¹ÜÀí·Ç³£¸´ÔÓ£¬½«ÆäÔÚlinuxƽ̨ÉÏµÄÆô¶¯ºÍ¹Ø±Õ²½ÖèÕûÀíһϡ£
°²×°Íê±ÏoracleÒÔºó£¬ÐèÒª´´½¨oracleϵͳÓû§£¬
²¢ÔÚ/home/oracleÏÂÃæµÄ.bash_profileÌí¼Ó¼¸¸ö»·¾³±äÁ¿£º
ORACLE_SID,ORACLE_BASE,ORACLE_HOME¡£
±ÈÈ磺
export ORACLE_SID=test export ORACLE_BASE=oracle_install_di ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ