Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ´´½¨Óû§


oracle10g´´½¨Óû§
Oracle10g µÄ´´½¨Óû§Ãû
1¡¢   linux Ï oracle µÄÆô¶¯
ÒÔ oracle Éí·ÝµÇ¼  
Æô¶¯    lsnrctl start
µÇ¼    sqplus /nolog
Á¬½ÓÊý¾Ý¿â    connect  /as   sysdba
Æô¶¯Êý¾Ý¿â    startup
¹Ø±ÕÊý¾Ý¿â    s ......

¿ª»úʱOracle agntsrvc.exe±¨ÄÚ´æ³ö´í

ÎҵĻúÆ÷¸ÄÁ˼ÆËã»úÃû³Æ£¬ÔÙ¿ª»úʱ£¬oracle³öÏÖÎÊÌ⣬¿ª»úʱÀÏÊDZ¨“agntsrvc.exe³ö´í”£¬¾­¹ýËÑË÷·¢ÏÖÊÇÏÂÁÐÎÊÌ⣺
1.agntsrvc.exeÊÇOracle Intelligent Agent·þÎñ¶ÔÓ¦µÄ³ÌÐò¡£
2.Òò´Ë·þÎñÊÇ×Ô¶¯Æô¶¯µÄ£¬ËùÒÔÒ»°ã¶àÔÚµçÄÔÆô¶¯Ê±µ¯³öϵͳ´íÎó¡£
3.ÎÊÌâ´¦Àí£º£¨±¾±¸·ÝÑø³Éϰ¹ßŶ£©
¡¡É¾³ýÁË %ORACLE_HOME%/ora ......

ORACLE LOB´ó¶ÔÏó´¦Àí

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

½éÉÜORACLE DATA GUARD

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