-
编辑 删除
netbackup备份错误1
配置好了后开始做备份。WIN平台上的NETBACKUP报错。RMAN-10035 ORA-19557。。。[@more@]RMAN-03022: compiling command: allocateRMAN-03023: executing command: allocateRMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03007: retryable error occurred during execution of command: allocateRMAN-07004: unhandled exception during command execut
-
编辑 删除
1z0-007 18:Advanced Subqueries
高级子查询[@more@]SQL> select ename,sal,deptno from emp e 2 where sal>(select avg(sal) from emp where deptno=e.deptno);ENAME SAL DEPTNO---------- ---------- ----------ALLEN 1600 30JONES 2975 20BLAKE 2850 30SCOTT 3000 20KING 5000 10FORD 3000 20已選取 6 個資料列.外查询中的行每被处理一次，内查询就求值一次.=======================================================
-
编辑 删除
1z0-007 20:9iExtensions to DDL&DML statements
PART20--9i extensions to ddl&dml statements objectives1,多表插入的類型: 無條件insert 重點insert 條件all insert 條件first insert2,創建和使用外部表3,創建constrance時name index [@more@]1 無條件insert allexample:insert allinto copy_table_emp1 values(ename,sal)into copy_table_emp2 values(ename,sal)select ename,sal from emp where sal>1000;2,條件insert allexample:insert allwhen sal>3000 then into copy_table_emp1 values(ename,sal)when sal<3000 then into copy_table_emp2 values(ena
-
编辑 删除
分析函數的學習
分析函数[@more@]普通的sql匯總數據:SQL> SELECT job,sum(sal) from emp group by job 2 union all 3 select '合計' job,sum(sal) from emp;JOB SUM(SAL)--------- ----------ANALYST 6000CLERK 4150MANAGER 8275PRESIDENT 5000SALESMAN 5600合計 29025autot: 6 consistent gets使用rollup統計函數:SQL> select nvl(job,'合計') job,sum(sal) 2 from emp 3 group by rollup (job);JOB SUM(SAL)--------- ----------ANALYST 6000CLERK
-
编辑 删除
第3章:调整redo buffer cache
调整redo buffer cache[@more@]设置初始参数，不能动态修改SQL> alter system set log_buffer=128000 scope=spfile;系统已更改。SQL> show parameter log_bufferNAME TYPE VALUE------------------------------------ ----------- --------log_buffer integer 524288SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> startupORACLE 例程已经启动。Total System Global Area 118098724 bytesFixed Size 453412 bytesVariable Size 104857600 bytesDatabase Buffers 12582912 bytesRedo Buff
-
编辑 删除
启动OEM时关于ora-00942：table or view does not exist的处理
今天同事用普通用户scott去连接Enterprise Manager Console ，显示ora-00942：table or view does not exist.换sys用户登陆没问题，scott赋予了select any table的系统权限。换pl/sql sqlplus都可以登陆。登陆的环境是9I.[@more@]解决方法:最简单的方法是把O7_DICTIONARY_ACCESSIBILITY参数设置为TRUE。当然很不好了。以下可以利用SQL_TRACE跟踪用户找到错误处：1，alter system set sql_trace=true scpoe=spfile;2，对产生的用户trace进行文件转换tkprof D:oracleadminORCLudumporcl_j000_5.trc d:1.txt找到Error encountered: ORA-00942
