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

ORACLE OMF½éÉÜ

ÏÈ¿´Oracle ¹Ù·½½âÊÍ
Oracle managed file (OMF)
A file that is created automatically by the Oracle database server when it is needed and automatically deleted when it is no longer needed.
 
ÈçºÎÅжÏÄãµÄÊý¾Ý¿âÊÇ·ñΪ֧³ÖOMF
SQL> show parameter db_create_file_dest;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest                  string
Èç¹ûValue Ϊ¿ÕÔò²»Ö§³Ö£¬ÓÐÖµÔòÖ§³Ö¡£
 
ÈçºÎÉèÖÃDB Ö§³Ö£¿
 
Ð޸ijõʼ»¯²ÎÊýÎļþ
[oracle@itc-test9 dbs]more initOCM.ora
.......
*.user_dump_dest='/disk/oracle/admin/OCM/udump'
 db_create_file_dest = '/disk/oracle/oradata'
ʹÓà ALTER SYSTEM ÃüÁ̬ÉèÖÃ
SQL> alter system set db_create_file_dest='/disk/oracle/oradata ;
 
System altered.
 
OMFÓÐЩÓÃÄØ£¿
ÎÒ´óÌå×ܽáÒ»¸öһϾÍÏÂÃæ¼¸µã£º
 
1£º ´´½¨Tablespace ÊDz»ÐèҪдÊý¾ÝÎļþÃû³ÆºÍ´óС £¨default 100M,×Ô¶¯Ôö³¤£¬Autoextend Ϊunlimited)
 
SQL> create tablespace omf;
Tablespace created.
 
Os:
[oracle@itc-test9 datafile]pwd
/disk/oracle/oradata/OCM/datafile
[oracle@itc-test9 datafile]ll
total 102512
-rw-r-----  1 oracle dba 104865792 Apr 29 16:13 o1_mf_omf_4zj30b2p_.dbf
 
´´½¨Êý¾ÝÎļþÊôÐÔ£º
 
Name  /disk/oracle/oradata/OCM/datafile/o1_mf_omf_4zj30b2p_.dbf
Tablespace  OMF
Status  Online
File Size (KB)  102400
AutoExtend  Yes
Increment  100MB
Maximum File Size  32767MB
 
 
2:  ÏòTablespace Ìí¼ÓÎļþÊÇÖ»ÊÊÓÃadd datafile ¾Í¿ÉÒÔÁË£¬²ÎÊýÈç1.
SQL> alter tablespace omf add datafile;
 
Tablespace altered.
 
Os
 
[oracle@itc-test9 datafi


Ïà¹ØÎĵµ£º

oracle update from ÎÊÌ⣡

  update t_tmprpt_firstreplycosttime t
set (t.firstreplytime,
t.dealstaff,
t.firstreplyfailcontent)
= (select a.suggesttime,
a.suggester,
substr(a.remark,instr(a.remark,'¡¿',1)+2)
from t_wf_suggesthis a
......

oracle ´æ´¢¹ý³Ì

 select myFunc(²ÎÊý1,²ÎÊý2..) to dual; --¿ÉÒÔÖ´ÐÐһЩҵÎñÂß¼­
Ò»:OracleÖеĺ¯ÊýÓë´æ´¢¹ý³ÌµÄÇø±ð:
A:º¯Êý±ØÐëÓзµ»ØÖµ,¶ø¹ý³ÌûÓÐ.
B:º¯Êý¿ÉÒÔµ¥¶ÀÖ´ÐÐ.¶ø¹ý³Ì±ØÐëͨ¹ýexecuteÖ´ÐÐ.
C:º¯Êý¿ÉÒÔǶÈëµ½SQLÓï¾äÖÐÖ´ÐÐ.¶ø¹ý³Ì²»ÐÐ.
ÆäʵÎÒÃÇ¿ÉÒÔ½«±È½Ï¸´ÔӵIJéѯд³Éº¯Êý.È»ºóµ½´æ´¢¹ý³ÌÖÐÈ¥µ÷ÓÃÕâЩº¯Êý.
¶þ:È ......

oracle Æô¶¯¹ÜÀíÆ÷

 emctl start dbconsole ÊÇ10gµÄÆô¶¯console·þÎñµÄÃüÁî
½«OEM·þÎñÍ£Ö¹emctl stop dbconsole
emctl start dbconsoleÆô¶¯EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
emctl stop dbconsoleÍ£Ö¹EM console·þÎñ£¬Ê¹ÓÃǰÐèÒªÏÈÉèÖÃORACLE_SID»·¾³±äÁ¿
¹Ø±ÕÊý¾Ý¿âºóÓ¦¸ÃÊ×ÏÈÓÃsysdbaµÇ½,ÕâÑù¾Í½øÈëÁËsysģʽ. ......

SQLºÍORACLEº¯Êý±È½Ï

 
SQLServerºÍOracleÊÇ´ó¼Ò¾­³£Óõ½µÄÊý¾Ý¿â£¬Ôڴ˸Ðл×÷Õß×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý£º
¡¡1.¾ø¶ÔÖµ
¡¡¡¡ S:SELECT abs(-1) value
¡¡¡¡ O:SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ S:SELECT ceiling(-1.001) value
¡¡¡¡ O:SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£© ......

Oracle:pl/sql Òì³£´¦Àí[ת]


pl/sql ÌṩÁËÇ¿´ó¶øÁé»îµÄÊÖ¶ÎÀ´²¶×½ºÍ´¦Àí³ÌÐò²úÉúµÄÒì³££¬´Ó¶øÊ¹ oracle µÄÓû§Ô¶ÀëһЩÁîÈË·³ÄÕµÄ bug ¡£
 
pl/sql Òì³£´¦ÀíµÄ¸ÅÄîºÍÊõÓï
 
ÔÚ oracle ÖÐËùÓеĴíÎó¶¼±»ÈÏΪÊDz»Ó¦¸Ã·¢ÉúµÄÒì³£¡£Ò»¸öÒì³£¿ÉÄÜÊÇÒÔÏ 3 ÖÖÇé¿öµÄÒ»ÖÖ£º
u       ÓÉϵͳ²úÉúµÄ´íÎó£¨& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ