http://muyeqing.itpub.net Sat,20 03 2010 00:34:31 http://www.plogworld.net 1 nocatalog mode例：target database: gate234rman target sys/guanliyuan@gate234 nocatalog2 catalog mode例：target database: gate234 catalog database: gatewayrman target sys/guanliyuan@gate234 catalog rman/guanliyuan@gateway http://muyeqing.itpub.net/post/6950/45811 http://muyeqing.itpub.net/post/6950/45811 http://muyeqing.itpub.net/post/6950/45811 muyeqing rman Mon,14 11 2005 13:35:31 muyeqing CREATE TYPE recordDev AS OBJECT (dev_id NUMBER, dev_name varchar2(100)); / CREATE TYPE tableDev AS TABLE OF recordDev / create or replace function returndevdata(p_dg_id number) return tabledev isv_record_temp recorddev := recorddev(null,null); v_loc_temp_table tabledev; BEGIN v_loc_temp_table := tabledev(null); v_loc_temp_table.Trim; for c in (SELECT d.dev_id AS dev_id,g.DG_NAME||'/'||d.dev_name AS group_and_dev_name FROM DEVICECONFIG d, DEVICEGROUPASSIGNMENT a,DEVICEGROUPCONFIG g WHERE a.dga_dg... http://muyeqing.itpub.net/post/6950/44114 http://muyeqing.itpub.net/post/6950/44114 http://muyeqing.itpub.net/post/6950/44114 muyeqing Oracle Thu,27 10 2005 13:23:14 muyeqing import带有blob字段的表到不同的表空间会报错： ora-00959 表空间不存在FIX：1. 将该表在要导入的数据库中先先建好2. 导入时选择参数ignore=y3. 导入该表 http://muyeqing.itpub.net/post/6950/39889 http://muyeqing.itpub.net/post/6950/39889 http://muyeqing.itpub.net/post/6950/39889 muyeqing Oracle Fri,02 09 2005 14:49:49 muyeqing 连接数据库的时候报错：关闭的连接FIX: 使用以下方法连接数据库<username>/<pwd>@<host>:1521:<sid>参考metalink254587.1 http://muyeqing.itpub.net/post/6950/39146 http://muyeqing.itpub.net/post/6950/39146 http://muyeqing.itpub.net/post/6950/39146 muyeqing 数据仓库 Fri,26 08 2005 10:18:34 muyeqing 1. stop所有的distribution, iis和oracle服务, 如果还是不行重启机器再关服务2. 安装patch3. 启动数据库, migrate模式startup migrate4. 运行catpatch.sql (%ORACLE_HOME%rdbmsadmin) http://muyeqing.itpub.net/post/6950/38388 http://muyeqing.itpub.net/post/6950/38388 http://muyeqing.itpub.net/post/6950/38388 muyeqing install and upgrade Wed,24 08 2005 00:00:28 muyeqing 解决ora-28575的问题(参考METALINK 70638.1):引起该错误的原英:1) 数据库不能建立到到external procedure listener的连接数据库使用tnsnames.ora文件中的extproc_connection_data服务名连接external_procedure_listener2) 或者external procedure listener不能执行extproc agentexternal procedure listener启动一个external procedure agent进程为external procedure execution请求服务解决方法: 正确地配置listener.ora和tnsnames.ora文件1)listener.ora文件, 在文件中增加下面两段内容CALLOUT_LISTENER = (ADDRESS_LIST = (ADDRESS = (... http://muyeqing.itpub.net/post/6950/38265 http://muyeqing.itpub.net/post/6950/38265 http://muyeqing.itpub.net/post/6950/38265 muyeqing Oracle Tue,16 08 2005 13:48:10 muyeqing 1 初始化设置1) 设置UTL_FILE_DIR2) 设置DATABASE运行在ARCHIVE_LOG模式下2 以SYSDBA登陆3 生成字典文件, 在运行dbms_logmnr.start_logmnr时会用到dbms_logmnr_d.build(dictionary_filename-> ?supplemental logging?4 dbms_logmnr.add_logfile 增加一个LOG文件到待处理列表中例: execute dbms_logmnr.add_logfile(logfilename => 'D:oracleoradatatvsnbbcarcharch_133.arc',options => dbms_logmnr.new);5 dbms_logmnr.start_logmnr(dictfilename, options)例: execute dbms_logmnr.start_logmnr(dictfilename => 'd:ora_fileminer_0801.... http://muyeqing.itpub.net/post/6950/37743 http://muyeqing.itpub.net/post/6950/37743 http://muyeqing.itpub.net/post/6950/37743 muyeqing Oracle Wed,10 08 2005 14:30:28 muyeqing OLTP - online transaction processingOLAP - online analytical processing设计OLTP和OLAP时的区别OLTP: 1. 设置较多但较小的回滚段2. PCTFREE 高3. SHARED POOL大4. 较大的日志文件5. MTS6. db_block_size大: 16KOLTP1. 设置较少但较大的回滚段2. PCTFREE = 03. 设置较大的BUFFER_CACHE4. 较小的日志文件5. 较大的SORT_AREA_SIZE6. db_block_size小: 2k或4k http://muyeqing.itpub.net/post/6950/36873 http://muyeqing.itpub.net/post/6950/36873 http://muyeqing.itpub.net/post/6950/36873 muyeqing Oracle Sun,31 07 2005 08:59:37 muyeqing An interval specifies a period of time. interval_year_to_monthINTERVAL 'integer [- integer]' { YEAR | MONTH } [( precision )] [TO { YEAR | MONTH }]Examples: INTERVAL '123-2' YEAR(3) TO MONTHAn interval of 123 years, 2 months. You must specify the leading field precision if it is greater than the default of 2 digits.INTERVAL '123' YEAR(3)An interval of 123 years 0 months.INTERVAL '300' MONTH(3)An interval of 300 months.INTERVAL '4' YEARMaps to INTERVAL '4-0' YEAR TO MONTH and indicates 4 years.IN... http://muyeqing.itpub.net/post/6950/36726 http://muyeqing.itpub.net/post/6950/36726 http://muyeqing.itpub.net/post/6950/36726 muyeqing Oracle Fri,29 07 2005 16:19:37 muyeqing 1 related parametersUNDO_MANAGEMENT = AUTOset UNDO_TABLESPACE to provide an undo tablespaceUNDO_RETENTION2 grant flashback to 3 query use "as of" clauseExample1 query by timestamp: select * from emp as of timestamp (systimestamp - interval '6' minute)where ename='Miller';Example2 query by SCN (query SCN， select dbms_flashback.get_system_change_number from dual；）select *from empas of SCN 3297508where ename='Miller';aaa http://muyeqing.itpub.net/post/6950/36668 http://muyeqing.itpub.net/post/6950/36668 http://muyeqing.itpub.net/post/6950/36668 muyeqing Oracle Fri,29 07 2005 12:59:02 muyeqing