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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Óï·¨:
select *
from [TABLE] as of timestamp
to_timestamp('ʱ¼ä', ’ʱ¼ä¸ñʽ')
×÷Óãº
²éѯij¸öʱ¼äµãµÄÊý¾Ý£¬ÔÚÕâ¸öʱ¼äµãÖ®ºó£¬Êý¾Ý¸ü¸ÄÒѾÌá½»ÁË¡£
¿ÉÒÔÓÃÀ´¸üÕýÓû§¶ÔÊý¾ÝµÄÎó²Ù×÷
¿ÉÒÔÓÃÀ´»ñÈ¡Êý¾ÝµÄ¸ü¸ÄÇé¿ö£¬±ÈÈçÆµÂʵÈ
ÔÀí£º
µ±Êý¾Ýupdate»òdeleteʱ£¬ÔÀ´µÄÊý¾Ý ......
¸Õ²ÅÔÚEYGLEµÄ²©¿ÍÖп´µ½Ò»ÆªÌû×Ó£¬½²µÄÊÇDELETEµÄ²Ù×÷Á÷³Ì£¬ºÜ¼ò¶Ì£¬Í¬Ê±Ò²¾«±Ù¡£
===================================================================================
OracleÖУ¬Ò»¸öDelete²Ù×÷µÄÁ÷³Ì
ɾ³ý(DELETE)
1.Oracle¶ÁBlockµ½Buffer Cache(Èç¹û¸ÃBlockÔÚBufferÖв»´æÔÚ)
2.ÔÚredo log bufferÖмǼdelet ......
oracleÊý¾Ý¿âÊÇÖØÁ¿¼¶µÄ£¬Æä¹ÜÀí·Ç³£¸´ÔÓ£¬½«ÆäÔÚlinuxƽ̨ÉÏµÄÆô¶¯ºÍ¹Ø±Õ²½ÖèÕûÀíһϡ£
°²×°Íê±ÏoracleÒÔºó£¬ÐèÒª´´½¨oracleϵͳÓû§£¬
²¢ÔÚ/home/oracleÏÂÃæµÄ.bash_profileÌí¼Ó¼¸¸ö»·¾³±äÁ¿£º
ORACLE_SID,ORACLE_BASE,ORACLE_HOME¡£
±ÈÈ磺
export ORACLE_SID=test export ORACLE_BASE=oracle_install_di ......