oracle create 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,
'D:\ORACLE\ORADATA\ORA92\dd.ora'
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......
OracleÊý¾Ý¿â×Ô¶¯Ôö³¤ÁеÄʵÏÖ¹ý³Ì:
¡ô1.´´½¨ÐòÁÐ
-- Create sequence
create sequence INNERID
minvalue 1
maxvalue 99999999999999
start with 1
increment by 1
cache 20
order;
¡ô2.--INNERID.currval Ö¸µ±Ç°ÐòÁÐ
--INNERID.nextval Ö¸Ï ......
ÈçºÎ½â¾öORA-00054×ÊÔ´Õý棬ҪÇóÖ¸¶¨NOWAIT£¿
²éÔÄ´íÎó´úÂëÖ¸ÄϺóÓÐÈçÏÂÌáʾ£º
ORA-00054 resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
Action: Tr ......
1. ×¼±¸ÖªÊ¶£ºORACLEµÄÂß¼´æ´¢¹ÜÀí.
ORACLEÔÚÂß¼´æ´¢ÉÏ·Ö4¸öÁ£¶È:±í¿Õ¼ä,¶Î,ÇøºÍ¿é.
1.1 ¿é:ÊÇÁ£¶È×îСµÄ´æ´¢µ¥Î»,ÏÖÔÚ±ê×¼µÄ¿é´óСÊÇ8K,ORACLEÿһ´ÎI/O²Ù×÷Ò²ÊÇ°´¿éÀ´²Ù×÷µÄ,Ò²¾ÍÊÇ˵µ±ORACLE´ÓÊý¾ÝÎļþ¶ÁÊý¾Ýʱ,ÊǶÁÈ¡¶àÉÙ¸ö¿é,¶ø²»ÊǶàÉÙÐÐ.
1.2 Çø:ÓÉһϵÁÐÏàÁڵĿé¶ø×é³É,ÕâÒ²ÊÇORACLE¿Õ¼ä·ÖÅäµÄ»ù±¾µ¥Î»,¾Ù¸ö ......