OracleÖÐÊý¾Ý¿âÓû§ºÍ±í¿Õ¼ä¹Øϵ
Ò»¸öÓû§¿ÉÒÔʹÓÃÒ»¸ö»ò¶à¸ö±í¿Õ¼ä£¬Ò»¸ö±í¿Õ¼äÒ²¿ÉÒÔ¹©¶à¸öÓû§Ê¹Óá£Óû§ºÍ±í¿Õ¼äûÓÐÁ¥Êô¹Øϵ£¬±í¿ÕÊÇÒ»¸öÓÃÀ´¹ÜÀíÊý¾Ý´æ´¢Âß¼¸ÅÄ±í¿Õ¼äÖ»ÊǺÍÊý¾ÝÎļþ·¢Éú¹Øϵ£¬Êý¾ÝÎļþÊÇÎïÀíµÄ£¬Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾ÝÎļþ£¬¶øÒ»¸öÊý¾ÝÎļþÖ»ÄÜÁ¥ÊôÒ»¸ö±í¿Õ¼ä¡£
Óû§ÊôÓÚÊý¾Ý¿âʵÀýµÄ£¬ÔÚÒ»¸öʵÀýϲ»ÄÜͬÃûÓû§¡£µ«ÔÚÒ»oracle·þÎñÆ÷£¬¿ÉÒÔ´´½¨¶à¸öʵÀý£¬Ö»ÒªÄãµÄ»úÆ÷ÅäÖù»ÓþͿÉÒÔ¡£ÒòΪһ¸öʵÀýÆô¶¯ÆðÂëÐèÒª100¶àÕ×ÄÚ´æµÄ¡£ËùÒÔÔÚÒ»oracle·þÎñÆ÷ÉÏ¿ÉÒÔ´æÔÚ¶à¸öͬÃûÓû§£¬ËûÃÇÊÇÊôÓÚ²»Í¬Êý¾Ý¿âʵÀý£¬ËûÃǶÔӦʹÓõıí¿Õ¼äÔÚ²»Í¬µÄʵÀýÉÏ¡£
²éѯ±í¿Õ¼äºÍÓû§Ö®¼äµÄ¹Øϵ£º
SELECT from DBA_SEGMENTS WHERE TABLESPACE_NAME=?
FAQ:
ÔÚOracleÖн¨Á¢ÁËÒ»¸öÓû§UB£¬ËüµÄĬÈϱí¿Õ¼äÊÇTSA£¬ÔÚÊý¾Ý¿âÓÃÁËÒ»¶Îʱ¼äºó£¬·¢ÏÖÔÀ´¸ã´íÁË£¬°ÑĬÈϱí¿Õ¼ä¸Ä³ÉTSB¡£ÏÖÔÚÏëÎʼ¸¸öÎÊÌâ:
1.Êý¾Ý¾¿¾¹·ÅÔÚÄǸö±í¿Õ¼äÉÏÁË£¿
¸ü¸ÄÒÔÇ°µÄ·ÅÔÚtsaÀïÃ棬ºóÀ´µÄ·ÅÔÚtsbÀïÃæ
2.ÎÒÏë°ÑÊý¾Ý¶¼·Å»Ø±í¿Õ¼äTSBÉÏ¿ÉÒÔÂð£¿
½«±íb´æ·ÅÔÚtsaÀïÃæ --alter table b move tablespace tsb;
3.ÔõÑù²ÅÖªµÀÊý¾Ý±í·ÅÔÚÄĸö±í¿Õ¼äÉÏ£¿
select table_name,TABLESPACE_NAME from user_tables;
4.ÎÒÓÃExp À´µ¼³öUBÕâ¸öÓû§£¬ÄÜ°ÑËüËùÓÐÊý¾Ý¶¼µ¼³öÂð£¿
¿ÉÒÔ¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Oracle/PLSQL: Lpad Function£º
http://www.techonthenet.com/oracle/functions/lpad.php
RPAD and LPAD [Oracle SQL]£º
http://www.adp-gmbh.ch/ora/sql/rpad.html
ÒýÊö
In Oracle/PLSQL, the lpad function pads the left-side of a string with a specific set of characters.
The syntax for the lpad funct ......
µÚÒ»²½:ÏÂÔØ°²×°Oracle 10g Release 2 ¿Í»§¶ËÈí¼þ,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
ÏÂÔغó°²×°
µÚ¶þ²½:ÏÂÔØ°²×°Oracle ODAC,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/other/ole-oo4o/ODAC1020221.exe
µÚÈý²½: ÖØÆôMS SQ ......
¡¡¡¡OracleÊý¾Ý¿âÖУ¬±íÊÇ×î»ù±¾µÄÄÚÈÝ¡£¿ÉÒÔ˵£¬±íÉè¼ÆµÄºÃ»µÖ±½Ó¸úÊý¾Ý¿âµÄÐÔÄÜÏà¹Ø¡£ËùÒÔ£¬ÔÚÉè¼Æ±íµÄʱºò£¬³ýÁËÒª×ñÑÆä¹ÌÓеÄÊý¾Ý¿â×¼ÔòÖ®Í⣬»¹ÐèÒª¿´¸öÈ˵ÄÊý¾Ý¿â¹ÜÀí¾Ñé¡£ÏÂÃæÎҾͰÑÕâЩ¾Ñé·ÖÏíһϣ¬»òÐí¶Ô´ó¼ÒÓÐËù°ïÖú¡£
¡¡¡¡Ò»¡¢ ±í¸Ã´æ·ÅÔÚÄÄÀï?
¡¡¡¡ÎÒÃǶ¼ÖªµÀ£¬ÔÚOracleÊý¾Ý¿âÖУ¬Ê¹ÀûÓÿռäÕâ¸ö¸ÅÄîÀ´¹Ü ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿â
ϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQL
µÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
j8m ......