升级过程和无效组件处理参考:How to Clean Up Duplicate Objects Owned by SYS and SYSTEM Schema (Doc ID 1030426.6)How To Manually Install Oracle OLAP In 9i, 10g Or 11g Database After The DB Has Been Created [296187.1]http://blog.csdn.net/tianlesoftware/article/details/7339998 环境:主机...【阅读全文】
Oracle冷备脚本: set feedback off set heading off set verify off set trimspool off set echo off set time off set timing off set pagesize 0 set linesize 200 define dir='/backup/cold/mike'; define diroutmike='/u01/scripts/c...【阅读全文】
1.日志挖掘1.1补充日志命令(日志中有了rowid)alter databaseadd supplemental logdata;1.2基于DML的日志挖掘例子:SCOTT下UPDATE某记录,我想挖掘出这个操作的时间以及SCN,如update emp set sal=9000;步骤:1.2.1查看当前redo日志col member for a40 select v1.group#,v1.sequence#,v...【阅读全文】
数据库的启动和关闭startup openshutdown immediate创建用户 create user xxx IDENTIFIED BY xxx;删除用户 drop user xxx cascade;赋权限 grant 权限 to user;收回权限 REVOKE 权限 ON table FROM 用户查看权限&n...【阅读全文】
1.什么是数据字典缓存 |what is data dictionary cache什么是数据字典?数据字典包含:● 数据库中每个schema对象(tables, indexes, sequences, and database links)的定义● schema对象分配空间总和及当前使用量● oracle数据库的用户名、权限、角色赋予及审计信息A memory area in the shared pool that holds d...【阅读全文】