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

oracle±í¿Õ¼äºÍÓû§´´½¨

 1. ´´½¨±í¿Õ¼äʾÀýÈçÏÂ
CREATE TABLESPACE "SAMPLE"
    LOGGING
    DATAFILE 'D:\ORACLE\ORADATA\ORA92\LUNTAN.ora' SIZE 5M
REUSE AUTOEXTEND
ON NEXT 51200K MAXSIZE 3900M
EXTENT    MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO 
ÉÏÃæµÄÓï¾ä·ÖÒÔϼ¸²¿·Ö£º
µÚÒ»: CREATE TABLESPACE "SAMPLE" ¡¡´´½¨Ò»¸öÃûΪ "SAMPLE" µÄ±í¿Õ¼ä.
    ¶Ô±í¿Õ¼äµÄÃüÃû,×ñÊØOracle µÄÃüÃû¹æ·¶¾Í¿ÉÁË.
   ORACLE¿ÉÒÔ´´½¨µÄ±í¿Õ¼äÓÐÈýÖÖÀàÐÍ:
(1)TEMPORARY: ÁÙʱ±í¿Õ¼ä,ÓÃÓÚÁÙʱÊý¾ÝµÄ´æ·Å;
´´½¨ÁÙʱ±í¿Õ¼äµÄÓï·¨ÈçÏÂ:
CREATE TEMPORARY TABLESPACE "SAMPLE"......
   (2)UNDO : »¹Ô­±í¿Õ¼ä. ÓÃÓÚ´æÈëÖØ×öÈÕÖ¾Îļþ.
´´½¨»¹Ô­±í¿Õ¼äµÄÓï·¨ÈçÏÂ:
CREATE UNDO TABLESPACE "SAMPLE"......
(3)Óû§±í¿Õ¼ä: ×îÖØÒª,Ò²ÊÇÓÃÓÚ´æ·ÅÓû§Êý¾Ý±í¿Õ¼ä
    ¿ÉÒÔÖ±½Óд³É: CREATE TABLESPACE "SAMPLE"
TEMPORARY ºÍ UNDO ±í¿Õ¼äÊÇORACLE ¹ÜÀíµÄÌØÊâµÄ±í¿Õ¼ä.Ö»ÓÃÓÚ´æ·ÅϵͳÏà¹ØÊý¾Ý.
µÚ¶þ:   LOGGING
ÓÐ NOLOGGING ºÍ LOGGING Á½¸öÑ¡Ïî,
      NOLOGGING: ´´½¨±í¿Õ¼äʱ,²»´´½¨ÖØ×öÈÕÖ¾.
     LOGGING ºÍNOLOGGINGÕýºÃÏà·´, ¾ÍÊÇÔÚ´´½¨±í¿Õ¼äʱÉú³ÉÖØ×öÈÕÖ¾.
ÓÃNOLOGGINGʱ,ºÃ´¦ÔÚÓÚ´´½¨Ê±²»ÓÃÉú³ÉÈÕÖ¾,ÕâÑù±í¿Õ¼äµÄ´´½¨½Ï¿ì,µ«ÊÇûÄÜÈÕÖ¾,Êý¾Ý¶ªÊ§ºó,²»Äָܻ´,µ«ÊÇÒ»°ãÎÒÃÇÔÚ´´½¨±í¿Õ¼äʱ,ÊÇûÓÐÊý¾ÝµÄ,°´Í¨³£µÄ×ö·¨,Êǽ¨Íê±í¿Õ¼ä,²¢µ¼ÈëÊý¾Ýºó,ÊÇÒª¶ÔÊý¾Ý×ö±¸·ÝµÄ,ËùÒÔͨ³£²»ÐèÒª±í¿Õ¼äµÄ´´½¨ÈÕÖ¾,Òò´Ë,ÔÚ´´½¨±í¿Õ¼äʱ,Ñ¡Ôñ NOLOGGING,ÒÔ¼Ó¿ì±í¿Õ¼äµÄ´´½¨ËÙ¶È.
µÚÈý: DATAFILE ÓÃÓÚÖ¸¶¨Êý¾ÝÎļþµÄ¾ßÌåλÖúʹóС.
Èç: DATAFILE 'D:\ORACLE\ORADATA\ORA92\LUNTAN.ora' SIZE 5M
˵Ã÷ÎļþµÄ´æ·ÅλÖÃÊÇ 'D:\ORACLE\ORADATA\ORA92\LUNTAN.ora' , ÎļþµÄ´óСΪ5M.
Èç¹ûÓжà¸öÎļþ,¿ÉÒÔÓöººÅ¸ô¿ª:
DATAFILE 'D:\ORACLE\ORADATA\ORA92\LUNTAN.ora' SIZE 5M,
    'D:\ORACLE\ORADATA\ORA92\dd.ora' SIZE 5M
µ«ÊÇÿ¸öÎļþ¶¼ÐèÒªÖ¸Ã÷´óС.µ¥Î»ÒÔÖ¸¶¨µÄµ¥Î»Îª×¼Èç 5M »ò 500K.
¶Ô¾ßÌåµÄÎļþ,¿ÉÒÔ¸ù¾Ý²»Í¬µÄÐèÒª,´æ·Å´ó²»Í¬µÄ½éÖÊÉÏ,Èç´ÅÅÌÕóÁÐ,ÒÔ¼õÉÙIO¾¹Õù.
Ö¸¶¨ÎļþÃûʱ,±ØÐëΪ¾ø¶ÔµØÖ·,²»ÄÜʹÓÃÏà¶ÔµØÖ·.
REUSE±íʾÎļþÊÇ·ñ±»ÖØÓÃ
AUTOEXTEND±í


Ïà¹ØÎĵµ£º

oracle sqlplus ³£ÓÃÃüÁî´óÈ«

showºÍsetÃüÁîÊÇÁ½ÌõÓÃÓÚά»¤SQL*Plusϵͳ±äÁ¿µÄÃüÁî
SQL> show all --²é¿´ËùÓÐ68¸öϵͳ±äÁ¿Öµ
SQL> show user --ÏÔʾµ±Ç°Á¬½ÓÓû§
SQL> show error¡¡¡¡ --ÏÔʾ´íÎó
SQL> set heading off --½ûÖ¹Êä³öÁбêÌ⣬ĬÈÏֵΪON
SQL> set feedback off --½ûÖ¹ÏÔʾ×îºóÒ»ÐеļÆÊý·´À¡ÐÅÏ¢£¬Ä¬ÈÏֵΪ"¶Ô6¸ö» ......

oracle job½â¾öÎÊÌâ»ã×Ü

Ò»¡£jobµÄÔËÐÐÆµÂÊÉèÖÃ
1.ÿÌì¹Ì¶¨Ê±¼äÔËÐУ¬±ÈÈçÔçÉÏ8:10·ÖÖÓ£ºTrunc(Sysdate+1) + (8*60+10)/24*60
2.ToadÖÐÌṩµÄ£º
ÿÌ죺trunc(sysdate+1)
ÿÖÜ£ºtrunc(sysdate+7)
ÿÔ£ºtrunc(sysdate+30)
ÿ¸öÐÇÆÚÈÕ£ºnext_day(trunc(sysdate),'SUNDAY')
ÿÌì6µã£ºtrunc(sysdate+1)+6/24
°ë¸öСʱ£ºsysdate+30/1440
3.ÿ¸ö ......

oracle ÈÕÆÚ¹ÜÀíº¯Êý

oracle ÈÕÆÚº¯Êý
 
ÔÚoracleÊý¾Ý¿âµÄ¿ª·¢ÖУ¬³£ÒòΪʱ¼äµÄÎÊÌâ´ó·ÑÖÜÕ£¬ËùÒÔÌØµØ½«ORACLEÊý¾ÝµÄÈÕÆÚº¯ÊýÊÕ²ØÖ´ˡ£Ä˹©
ËûÈÕËù²éÒ²¡£
  add_months(d,n) ÈÕÆÚd¼Ón¸öÔÂ
  last_day(d) °üº¬dµÄÔÂ?µÄ×îºóÒ»ÌìµÄÈÕÆÚ
  new_time(d,a,b) a?ÇøµÄÈÕÆÚºÍ??dÔÚb?ÇøµÄÈÕÆÚºÍ??
  next_day(d,day) ±È ......

[Oracle]varchar2Ìæ»»Îªclob(¸Ã×Ö¶ÎÖÐÒÑÓдóÁ¿Êý¾Ý)

alter   table     t_att_over_haul_safe_pres   add   c   clob;  
update   t_att_over_haul_safe_pres   set   c=prt_precautions;  
alter   table   t_att_over_haul_safe_p ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ