mig_bf_to_sf.sql
Oracle 学习资料库
-- run this script as SYS
connect / as sysdba
set serveroutput on
set lines 200
set pause off
/*== Check the current segment type of the LOB ==*/
/*== Note that the segment subtype for
/*== BasicFile LOB storage is ASSM
SELECT segment_name, segment_type, segment_subtype
FROM dba_segments
WHERE tablespace_name = 'OBE_TBS1'
AND segment_type = 'LOBSEGMENT'
pause Press [Enter] to continue...
set pause on
/*== Create the interim table for online redefinition ==*/
/*== Note that the recommended practice is to enable
/*== COMPRESSION and DEDUPLICATION at table createion ==*/
/*== time. Also, the ALTER TABLE SHRINK operation is
/*== not yet supported for SecureFiles LOBs in
/*== release 1 of Oracle Database 11g.
CREATE TABLE sf_demo.resumes_interim
(id NUMBER, first_name VARCHAR2(15),
last_name VARCHAR2 (40), resume BLOB)
LOB (resume) STORE AS SECUREFILE
(TABLESPACE obe_tbs2
COMPRESS HIGH
DEDUPLICATE)
pause Press [Enter] to continue...
/*== Perform the online redefinition ==*/
error_count PLS_INTEGER := 0;
DBMS_REDEFINITION.START_REDEF_TABLE
('sf_demo', 'resumes', 'resumes_interim',
'id id, first_name first_name, last_name last_name, resume resume',
OPTIONS_FLAG =& DBMS_REDEFINITION.CONS_USE_ROWID);
DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS
('sf_demo', 'resumes', 'resumes_interim',
1, true,true,true,false, error_count);
DBMS_OUTPUT.PUT_LINE('Errors := ' || TO_CHAR(error_count));
DBMS_REDEFINITION.FINISH_REDEF_TABLE
('sf_demo', 'resumes', 'resumes_interim');
pause Press [Enter] to continue...
/*== Drop the interim table ==*/
DROP TABLE sf_demo.resumes_interim
pause Press [Enter] to continue...
set pause off
/*== Check the segment type of the migrated LOB ==*/
/*== Note that the segment subtype for
/*== SecureFiles LOB storage is SECUREFILE
SELECT segment_name, segment_type, segment_subtype
FROM dba_segments
WHERE tablespace_name = 'OBE_TBS2'
AND segment_type = 'LOBSEGMENT'
pause Press [Enter] to continue...
set pause off
/*== Check the DBA_LOBS data dictionary view for ==*/
/*== information on the SecureFiles COMPRESSION
/*== and DEDUPLICATION settings
SELECT column_name, segment_name,
compression, deduplication, securefile
FROM dba_lobs
WHERE owner = 'SF_DEMO' and table_name = 'RESUMES'
更多融合中间件下载
客户与活动
电子邮件订阅
服务与商店
***: 800-810-8-6698【sql_sf】。。。。。。。。可耐的sfMM，来抱抱，不哭。。。。。。。。。。。。。。。。。。。。。。。。。。。。-中国学网-中国IT综合门户网站-提供健康,养生,留学,移民,创业,汽车等信息
【sql_sf】。。。。。。。。可耐的sfMM，来抱抱，不哭。。。。。。。。。。。。。。。。。。。。。。。。。。。。
来源：互联网 更新时间： 12:26:10 责任编辑：鲁晓倩字体：
用户提出问题:【sql_sf】。。。。。。。。可耐的sfMM，来抱抱，不哭。。。。。。。。。。。。。。。。。。。。。。。。。。。。,具体如下:
通过互联网整理获得以下解决方法:=================1楼=====================
小爱RP爆涨啊&&
少赚1.5W，第1节看到形势不对押了马刺1.5W多中国学网
=================2楼=====================
觉得小爱应该给小F开专场，你懂不
=================3楼=====================
恭喜小爱，恭喜大版！！
=================4楼=====================
小爱赢大了
=================5楼=====================
引用&2&楼&&的回复:觉得小爱应该给小F开专场，你懂不
直接10000可用分。专场就不需要了
=================6楼=====================
=================7楼=====================
大版居然两头都押！真是分多啊
=================8楼=====================
引用&2&楼&&的回复:觉得小爱应该给小F开专场，你懂不
这个必须得，F姐姐无敌
=================9楼=====================
本帖最后由 roy_88 于
11:58:05 编辑=================10楼=====================
只能说大版犀利
=================11楼=====================
=================12楼=====================
引用&10&楼&&的回复:只能说大版犀利
这场没赢到分分啊，求包养或赞助
相关文章：
上一篇文章：下一篇文章：
最新添加资讯
24小时热门资讯
Copyright © 2004- All Rights Reserved. 中国学网 版权所有
京ICP备号-1 京公网安备02号