ITPub博客

CREATE OR REPLACE FUNCTION f_str2tab(p_str IN VARCHAR2 --传入的字符串,格式为1,2,3,4,5) RETURN type_varc IS/******************************************************************Ver1.0 Created by xsb on 2008-04-14把字符串(1,2,3,4,5)转换为内存表形式create or replace type type_varc is table of varchar2(1000);测试用例:SELECT * FROM TABLE(f_str2tab('a,s,d,12,3,4,5'));******************************************************************/[@more@]v_str VARCHAR2(4000) := p_str || ',';v_cnt NUMBER := length(v_st

Solution1:source：windows2003 32bit,oracle10g 10.2.0.2target:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASMSolution2:source：HP UX 64bit,oracle10g 10.2.0.3,RAC,ASMtarget:IBM aix 64bit,oracle10g 10.2.0.3,RAC,ASM[@more@]Solution1:source：windows2003 32bit,oracle10g 10.2.0.2GRANT DBA TO xsb IDENTIFIED BY xsb;CREATE TABLESPACE xsbtest_ts DATAFILE 'D:ORACLEPRODUCT10.2.0ORADATACSLSCxsbtest_ts01.DBF' SIZE 5m;SELECT * FROM v$datafile;CREATE TABLE xsb.t1 TABLESPACE xsbtest_ts AS SELECT * FROM dba_users;SELECT

HP UX,Oracle10g 10.2.0.3,RAC,ASM[@more@]alter tablespace ro_2006_ts read only;rman target /run {allocate channel c1 type disk;backup as compressed backupset(tablespace RO_2006_TS format "/u01/app/oradata/clct_1_arch2/rman2tape/RO_2006_TS_CLCT.RMAN");release channel c1;}show all;CONFIGURE EXCLUDE FOR TABLESPACE RO_2006_TS;run {sql 'alter system archive log current';allocate channel c1 type disk;backup full as compressed backupset(database format "/u01/app/oradata/clct_1_arch2/rman2

Oracle 9i & 10g编程艺术数据库体系结构 [zt][@more@]

高级复制中mlog$表的HWM过高可能会导致性能问题。停止快照端的刷新作业，手工刷新一次同步后，检查业务处理端的mlog$表，确保这些表为空，然后truncate mlog$表，恢复同步作业，最后恢复业务处理端的客户连接。[@more@]