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

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´æ´¢¹ý³Ì°üº¬Èý²¿·Ö£º¹ý³ÌÉùÃ÷£¬Ö´Ðйý³Ì²¿·Ö£¬´æ´¢¹ý³ÌÒì³£¡£
Oracle´æ´¢¹ý³Ì¿ÉÒÔÓÐÎÞ²ÎÊý´æ´¢¹ý³ÌºÍ´ø²ÎÊý´æ´¢¹ý³Ì¡£ 
Ò»¡¢Î޲γÌÐò¹ý³ÌÓï·¨
 
1 create or replace procedure NoParPro
2 as  ;
3 begin
4 ;
5 exception  &nb ......

oracleË÷ÒýË鯬

author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......

oracle 10g em¡¢isqlplus·ÃÎʲ»Á˵ÄÎÊÌâ½â¾ö

Èç¹ûweb·½Ê½µÄem£¬isqlplus·ÃÎʲ»ÁË¡£
1. ¼ì²éÖ÷»úÃû/IP¡¢¶Ë¿ÚÊÇ·ñÕýÈ·
°²×°Ê±µÄÖ÷»úÃû/IP¡¢¶Ë¿Ú¼Ç¼ÔÚ$ORACLE_HOME/install/portlist.ini ÎļþÖС£
ȱʡÊÇ£º
Ò»°ãÓû§                    
http://ip:5560/isq ......

oracleÃüÁî²Ù×÷

‘¿ªÊ¼’-->‘ÔËÐÐ’--> ÊäÈë‘cmd’ ´ò¿ªcmd.exe -->ÊäÈë‘cd c:\’ Çл»µ½ c:\>
Æô¶¯Oracle
c:\> svrmgrl
svrmgrl> connect   internal/oracle
svrmgrl> startup
svrmgrl> exit
Æô¶¯¼àÌýÆ÷
c:\> lsnrctl   start ......

ORACLEº¯Êý´óÈ«


SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
        A         A      ZERO   &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ