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×îÐÂÈÏÖ¤Ìâ¿â×ÊÁÏÏÂÔØ
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 ......
·½°¸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 < ......
--°ü
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Êý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл ......
OracleÊý¾Ý¿âÔÚʹÓùý³ÌÖУ¬Ëæ×ÅÊý¾ÝµÄÔö¼ÓÊý¾Ý¿âÎļþÒ²Öð½¥Ôö¼Ó£¬ÔÚ´ïµ½Ò»¶¨´óСºóÓпÉÄÜ»áÔì³ÉÓ²Å̿ռ䲻×ã;ÄÇôÕâʱÎÒÃÇ¿ÉÒÔ°ÑÊý¾Ý¿âÎļþÒƶ¯µ½ÁíÒ»¸ö´óµÄÓ²ÅÌ·ÖÇøÖС£ÏÂÃæÎÒ¾ÍÒÔOracle for Windows°æ±¾ÖаÑCÅ̵ÄÊý¾Ý¿âÎļþÒƶ¯µ½DÅÌΪÀý½éÉÜOracleÊý¾Ý¿âÎļþÒƶ¯µÄ·½·¨ºÍ²½Öè¡£
¡¡¡¡1.ÔÚsqlplusÖÐÁ¬½Óµ½ÒªÒƶ¯ÎļþµÄOr ......