Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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×îÐÂÈÏÖ¤Ìâ¿â×ÊÁÏÏÂÔØ

Oracle×îÐÂÈÏÖ¤Ìâ¿â×ÊÁÏÏÂÔØ
Actualtests Oracle 1Z0-200 V11.07.08
Actualtests Oracle 1Z0-211 V11.10.08
Actualtests Oracle 1Z0-212 V11.07.08
Actualtests Oracle 1Z0-213 V11.07.08
Actualtests Oracle 1Z0-101 V11.07.08
Actualtests Oracle 1Z0-132 V11.07.08
Actualtests Oracle 1Z0-140 V11.21.08
Actual ......

Oracle JOB Ó÷¨Ð¡½á£¨×ªÔØ£©

 Oracle JOB Ó÷¨Ð¡½á
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡ ......

Oracle·ÖÒ³´æ´¢¹ý³Ì¼°javaµÄ¾ßÌåµ÷Ó÷½·¨

--°ü
create or replace package pkg_query as
  type cur_query is ref cursor;
end pkg_query;
--¹ý³Ì
CREATE OR REPLACE  PROCEDURE "PRC_QUERY" (p_tableName  
        in  varchar2,   --±íÃû
      & ......

Oracle ¶Î Çø ¿é

ÔĶÁoracleÎĵµµÄb10743£¬¡¶conceps¡·¡£Õâ±¾±»oracle¹«Ë¾µÄ´óʦ¼¶µÄÈËÎïMichele CyranµÈÅ£ÈËËùд£¬ÕæÊÇÒ»±¾²»´íµÄÊé¼®¡£¿É̾ӢÎIJ»Ì«ºÃ£¬µ«Å¬Á¦£¬×Ü»áÓÐÊÕ»ñµÄ¡£»¹ÊÇ´ÓËûµÄÊý¾Ý¼Ü¹¹À´Ëµ°É£¡
 £¨Ò»£©Data blocks £¬Extents£¬Segment
    Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼­½á¹¹¡£
    ÏÈ¿´Data blo ......

sdeÓëoracleµÄ°æ±¾ÎÊÌâ

1.ʹÓòúÆ·£ºarcsde 9.3+oracle 10.2.0.1
2.ÎÊÌâÃèÊö£ºÓÃarcmap·ÃÎÊ¿Õ¼äÊý¾Ý£¬²Ù×÷¼¸·ÖÖÓ£¬arcmapÎÞ·´Ó¦£¬Êý¾Ý¿â·þÎñÆ÷¶ËcpuÕ¼ÓÐÂÊ100%£¬gsrvr.exe½ø³ÌÊý10+¡£
3.½â¾ö°ì·¨£ºÉý¼¶oracle°æ±¾´Ó10.2.0.1Éý¼¶µ½10.2.0.3»òÕß.2.0.4¡£
4.Ô­Òò£º¾Ýesri¹¤³ÌʦËù³Æ£¬oracle10.2.0.1°æ±¾´æÔÚÓëarcgis²»¼æÈݵÄÎÞ·¨µ÷½ÚµÄbug¡£Ä¿Ç°Éý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ