Oracle 10g Êý¾Ý¿â°²×°¼°ÅäÖÃ
1¡¢°²×°
2¡¢´´½¨“±¾µØNet·þÎñÃû”
3¡¢PLSQL Developer Á¬½Ó²âÊÔ
4¡¢´´½¨±í¿Õ¼ä
1.´ò¿ªsqlplus¹¤¾ß£º
sqlplus /nolog
2. Á¬½ÓÊý¾Ý¿â£º
conn /as sysdba
3. ´´½¨±í¿Õ¼ä£º
create tablespace camds datafile 'D:\oracle\product\10.2.0\oradata\camds\camds.dbf' size 200m autoextend on next 10m maxsize unlimited;
OracleÊý¾Ý¿â°²×°¼°ÅäÖã¨Ò»£©
²Î¿¼http://www.javaeye.com/topic/493585
OracleÊý¾Ý¿â°²×°¼°ÅäÖ㨶þ£©
²Î¿¼http://www.javaeye.com/topic/493595
Ïà¹ØÎĵµ£º
·ÖÒ³µÄ×ÚÖ¼ÊÇ¿ØÖƲéѯ³öÀ´µÄÊý¾Ý¸öÊý£¬ÏÂÃæÕâÌõÓï¾ä¶ÔÓÚOracle·ÖÒ³ÒѾ×ã¹»ÁË¡£
£¨×¢£º¸ÃÓï¾äÖ»ÄÜÓÃÓÚOracle£©
SELECT * from (SELECT temp.*, ROWNUM RN from (SELECT * from USERS ORDER BY ID DESC) temp) WHERE RN > 0 AND RN <= 10
SELECT *
from (SELECT AA.*, ROWNUM RN ......
ÊÓͼµÄ¸ÅÄî
ÊÓͼÊÇ»ùÓÚÒ»Õűí»ò¶àÕűí»òÁíÍâÒ»¸öÊÓͼµÄÂß¼±í¡£ÊÓͼ²»Í¬ÓÚ±í£¬ÊÓͼ±¾Éí²»°üº¬ÈκÎÊý¾Ý¡£±íÊÇʵ¼Ê¶ÀÁ¢´æÔÚµÄʵÌ壬ÊÇÓÃÓÚ´æ´¢Êý¾ÝµÄ»ù±¾½á¹¹¡£¶øÊÓͼֻÊÇÒ»ÖÖ¶¨Ò壬¶ÔÓ¦Ò»¸ö²éѯÓï¾ä¡£ÊÓͼµÄÊý¾Ý¶¼À´×ÔÓÚijЩ±í£¬ÕâЩ±í±»³ÆΪ»ù±í¡£Í¨¹ýÊÓͼÀ´²é¿´±í£¬¾ÍÏñÊÇ´Ó²»Í¬µÄ½Ç¶ÈÀ´¹Û²ìÒ»¸ö(»ò¶à¸ö)±í¡£
Ê ......
Ò».ÅäÖñ¾µØNet·þÎñÃûÊǸÉʲôÓõģ¿
Èç¹ûҪͨ¹ýÍøÂç·ÃÎÊOracleÊý¾Ý¿â»òÆäËû·þÎñ£¬¾Í»áÓõ½Net·þÎñÃû¡£Oracle Net
Configuration AssistantÔÊÐíʹÓÃÓɱ¾µØÃüÃû½âÎöµÄÍøÂç·þÎñÃû¡£
¶þ.ÔõÑùÅäÖñ¾µØNet·þÎñÃû£¿
1.´ò¿ª->³ÌÐò/Oracle - OraClient10g_home1/ÅäÖúÍÒÆÖ²¹¤¾ß/Net
Configuration Assistant´ò¿ªNet Co ......
1.1.1 °²×°OracleÊý¾Ý¿â·þÎñ¶Ë
°´ÕÕ°²×°Ïòµ¼£¬ÕýÈ·°²×°Oracle 9i¡£
°´ÕÕĬÈÏÑ¡Ïµã»÷ÏÂÒ»²½£¬¼´¿É¡£
ͼ 2 2 Oracle °²×°Ïòµ¼ - »¶ÓʹÓÃ
ͼ 2 3 Oracle °²×°Ïòµ¼ - Îļþ¶¨Î»
ÕâÀÐè×¢ÒâOracleµÄ°²×°Îļþ·¾¶²»ÄÜ°üº¬¿Õ¸ñºÍÖÐÎÄÃû¡£Ä¬ÈÏ°²×°Â·¾¶ÊÇD:\oracle\ora92,ÕâÀィÒéʹÓÃÕâ¸ö°²×°Â·¾¶¡££¨°²×°£© ......