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

¡¾×ª¡¿Oracle Tablespace´´½¨

 Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
  ·ÖÅä´æ´¢£¬¾ÍÒª´´½¨±í¿Õ¼ä£º¡¡¡¡
  ´´½¨±í¿Õ¼äʾÀýÈçÏ£º
  CREATE TABLESPACE "SAMPLE"
    LOGGING
    DATAFILE 'D:\ORACLE\ORADATA\ORA92\LUNTAN.ora' SIZE 5M
    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,
  &nbs


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

Oracle ÓëÔÚJavaÖеÄÁ´½Ó

תÌû´¦£ºhttp://dong-java.javaeye.com/blog/375150 
1¡£ÍƼöʹÓÃOralce±È½ÏеÄ10.2.0.3 JDBC Drivers¡£Õâ¸ö°æ±¾¶Ô±È9.2µÄ×î´óµÄºÃ´¦ÊÇDriverManager.setLoginTimeoutº¯ÊýÊÇÆð×÷Óõġ£ÉèÖÃÁËÕâ¸ö²ÎÊý£¬ÔÚ¶ñÁÓµÄÍøÂç»·¾³ÖоͲ»»áÓÐÁ¬½ÓÊý¾Ý¿âµÄº¯Êý³¤Ê±¼ä²»·µ»ØµÄÇé¿ö¡£
2¡£JDBC Developer!ˉs Guide and Refer ......

½éÉÜORACLE DATA GUARD

¡¾IT168¼¼ÊõÎĵµ¡¿
     DATA GUARDµÄ×îÖ÷ÒªµÄ¹¦ÄÜÊÇÈßÔÖ¡£µ±È»¸ù¾ÝÅäÖõIJ»Í¬£¬DATA GUARD»¹¿ÉÒԾ߱¸ÒÔÏÂÌØµã£º¸ß¿ÉÓá¢ÐÔÄÜÌáÉý¡¢Êý¾Ý±£»¤ÒÔ¼°¹ÊÕϻָ´µÈ¡£
    DATA GUARD¿ÉÒÔ·ÖΪÎïÀíSTANDBYºÍÂß¼­STANDBYÁ½ÖÖ¡£¶þÕßµÄ×î´ó²î±ðÔÚÓÚ£¬ÎïÀíSTANDBYÓ¦ÓõÄÊÇÖ÷¿âµÄ¹éµµÈÕÖ¾£¬¶øÂ ......

OracleϵÁУºLOB´ó¶ÔÏó´¦Àí

 OracleϵÁУºLOB´ó¶ÔÏó´¦Àí
 Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£
 Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
 
Ò»£¬OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
 1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
  ¢Ù×Ö·ûÀàÐÍ£º
 &nbs ......

¡¾×ª¡¿oracle ȨÏÞ¹ÜÀíÏà¹ØÃüÁî

Ò»¡¢ÏµÍ³µÄĬÈÏÓû§
Java´úÂë
sys;//ϵͳ¹ÜÀíÔ±£¬ÓµÓÐ×î¸ßȨÏÞ     
system;//±¾µØ¹ÜÀíÔ±£¬´Î¸ßȨÏÞ     
scott;//ÆÕͨÓû§£¬ÃÜÂëĬÈÏΪtiger,ĬÈÏδ½âËø  
¶þ¡¢µÇ½
Java´úÂë
sqlplus conn / as sysdba;//µÇ½sysÕÊ»§     ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ