Oracle±í¿Õ¼äµÄ½¨Á¢
CREATE TABLESPACE mySpace
datafile
'd:\data\data1.dbf' size 1M reuse
autoextend on next 100k maxsize 2M
'd:\data\data2.dbf' size 1M reuse
online
permanent;
ÆäÖÐonline±íÁª»ú¡£
Áª»úºÍÍÑ»úµÄÇø±ðºÍʹÓÃ
Áª»ú£º ORACLE·þÎñ½ø³Ì¹ØÁªÎļþ¡£¿É¹©oracle¿Í»§¶Ë·ÃÎÊ.Èç¹ûÔÚϵͳÖÐÖ±½Óɾ³ýʱ»áµ¯³öÒì³£¡£
ÍÑ»ú: ²»ÓëORACLE·þÎñÆ÷¹ØÁª,ORACLE¿Í»§¶ËÒ²ÎÞ·¨·ÃÎÊ¡£ÔÚϵͳÖпÉÒÔÖ±½Óɾ³ý¡£ ʹÓó¡ºÏ: ±ÈÈç˵ij¸öÎļþÏÖÔÚ²»ÏëʹÓÃÁË£¬¿ÉÒÔÉèÖÃΪÍÑ»ú¡£µ±ÔÚÐèҪʱÔÚÉè»ØÀ´¡£
Ïà¹ØÎĵµ£º
Oracle´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
1 create or replace procedure NoParPro
2 as ;
3 begin
4 ;
5 exception &nb ......
author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......
Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§
http://ip:5560/isq ......
‘¿ªÊ¼’-->‘ÔËÐÐ’--> ÊäÈë‘cmd’ ´ò¿ªcmd.exe -->ÊäÈë‘cd c:\’ Çл»µ½ c:\>
Æô¶¯Oracle
c:\> svrmgrl
svrmgrl> connect internal/oracle
svrmgrl> startup
svrmgrl> exit
Æô¶¯¼àÌýÆ÷
c:\> lsnrctl start ......
SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO &nbs ......