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

Oracle±í¿Õ¼äµÄ¹ÜÀí

 Oracle±í¿Õ¼äµÄ¹ÜÀí
1.´´½¨±í¿Õ¼ä
  //´´½¨ÁÙʱ±í¿Õ¼ä
 create temporary tablespace test_temp
 tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
 size 32m
 autoextend on
 next 32m maxsize 2048m
 extent management local;
 //´´½¨Êý¾Ý±í¿Õ¼ä
 create tablespace test_data
 logging
 datafile 'E:\oracle\product\10.2.0\oradata\testserver\test_data01.dbf'
 size 32m
 autoextend on
 next 32m maxsize 2048m
 extent management local;
2.¸øÓû§Ö¸¶¨±í¿Õ¼ä
 //´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä
 create user testserver_user identified by testserver_user
 default tablespace test_data
 temporary tablespace test_temp;
 //¸øÓû§ÊÚÓèȨÏÞ
 grant connect,resource to testserver_user;
3.±í¿Õ¼äǨÒÆ
·½·¨1£º
alter   table   tb_name   move   tablespace   tbs_name;  
  À´¶Ô±í×ö¿Õ¼äǨÒÆʱֻÄÜÒƶ¯·Çlob×Ö¶ÎÒÔÍâµÄÊý¾Ý£¬¶øÈç¹ûÎÒÃÇҪͬʱÒƶ¯lobÏà¹Ø×ֶεÄÊý¾Ý£¬ÎÒÃǾͱØÐèÓÃÈçϵĺ¬ÓÐÌØÊâ²ÎÊý¾ÝµÄÎľäÀ´Íê³É£¬Ëü¾ÍÊÇ£º    
  alter   table   tb_name   move   tablespace   tbs_name   lob(col_lob1,col_lob2)   store   as(tablesapce   tbs_name);
 
·½·¨2£ºÀûÓÃȱʡ±í¿Õ¼ä
  ȱʡÇé¿öÏ£¬µ¼ÈëÊÔͼÔÚÓëµ¼³öÏàͬµÄ±í¿Õ¼äÖд´½¨¶ÔÏó¡£Èç¹ûÓû§²»¾ßÓÐÄǸö±í¿Õ¼äµÄȨÏÞ£¬»òÕßÄǸö±í¿Õ¼ä²»´æÔÚʱ£¬OracleÔÚÓû§ÕÊ»§µÄȱʡ±í¿Õ¼äÖд´½¨Êý¾Ý¿â¶ÔÏó¡£ÕâЩÌØÐÔ¿ÉÒÔÓÃÓÚʹÓõ¼³öÓëµ¼ÈëÔÚ±í¿Õ¼äÖ®¼äÒƶ¯Êý¾Ý¿â¶ÔÏó¡£
 
  ҪΪUSER_A½«TABLESPACE_AµÄËùÓжÔÏóÒƶ¯µ½TABLESPACE_B£¬Ó¦×ñÑ­ÒÔϲ½Ö裺  
   
  £¨1£©   ΪUSER_Aµ¼³öTABLESPACE_AÖеÄËùÓжÔÏó¡£  
   
  £¨2£©   Ö´ÐÐREVOKE   UNLIMITED   TABLESPACE   ON   TABLESPACE_A   from   USER_A;ÒÔÊÕ»ØÈκÎÊÚÓèÓû§ÕÊ»§µ


Ïà¹ØÎĵµ£º

oracle SQLÐÔÄÜÓÅ»¯

£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......

oracle±È½Ï¿ìµÄ·ÖÒ³sql

 ·½°¸1 ÊÊÓÃÓÚoracle9iÒÔÉÏ£¡
select * from
(select row_number() over(order by sendid desc) rn,m.* from xxt_msgreceive m )
where rn <1010 and rn>=1000
·½°¸2
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from xxt_msg where sendstatus=1  order by msgid desc) A WHERE ROWNUM < ......

¼ò±ãʵÏÖOracleÊý¾Ý¿âÎļþÒƶ¯·½·¨

OracleÊý¾Ý¿âÔÚʹÓùý³ÌÖУ¬Ëæ×ÅÊý¾ÝµÄÔö¼ÓÊý¾Ý¿âÎļþÒ²Öð½¥Ôö¼Ó£¬ÔÚ´ïµ½Ò»¶¨´óСºóÓпÉÄÜ»áÔì³ÉÓ²Å̿ռ䲻×ã;ÄÇôÕâʱÎÒÃÇ¿ÉÒÔ°ÑÊý¾Ý¿âÎļþÒƶ¯µ½ÁíÒ»¸ö´óµÄÓ²ÅÌ·ÖÇøÖС£ÏÂÃæÎÒ¾ÍÒÔOracle for Windows°æ±¾ÖаÑCÅ̵ÄÊý¾Ý¿âÎļþÒƶ¯µ½DÅÌΪÀý½éÉÜOracleÊý¾Ý¿âÎļþÒƶ¯µÄ·½·¨ºÍ²½Öè¡£
¡¡¡¡1.ÔÚsqlplusÖÐÁ¬½Óµ½ÒªÒƶ¯ÎļþµÄOr ......

Oracle ¾Û¼¯

¾Û¼¯(cluster)ÊÇ´æ´¢±íÊý¾ÝµÄ¿ÉÑ¡ÔñµÄ·½·¨¡£Ò»¸ö¾Û¼¯ÊÇÒ»×é±í£¬½«¾ßÓÐͬһ¹«¹²ÁÐÖµµÄÐд洢ÔÚÒ»Æ𣬲¢ÇÒËüÃǾ­³£Ò»ÆðʹÓá£ÕâЩ¹«¹²Áй¹³É¾Û¼¯Âë¡£
¾­³£±»Í¬Ê±·ÃÎʵıíÔÚÎïÀíλÖÃÉÏ¿ÉÒÔ´æ´¢ÔÚÒ»Æð¡£ÎªÁ˽«ËüÃÇ´æ´¢ÔÚÒ»Æ𣬾ÍÒª´´½¨Ò»¸ö´Ø( c l u s t e r )À´¹ÜÀíÕâЩ±í¡£±íÖеÄÊý¾ÝÒ»Æð´æ´¢ÔÚ´ØÖУ¬´Ó¶ø×îС»¯±ØÐëÖ´ÐеÄI ......

Oracle AWRËÙ²é

 SQL> SQLPLUS / AS SYSDBA
SQL> exec dbms_workload_repository.create_snapshot
SQL> exec:snap_id:=dbms_workload_repository.create_snapshot
SQL> var snap_id number
SQL> print snap_id
SQL> @?/rdbms/admin/awrrpt.sql
OracleAWRËÙ²é
 
1.²é¿´µ±Ç°µÄAWR±£´æ²ßÂÔ
select * fro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ