- 博客(23)
- 收藏
- 关注
RSS订阅转载 ORA-23515: 实体化视图和/或它们的索引存在于表空间中
第 1 行出现错误:ORA-23515: 实体化视图和/或它们的索引存在于表空间中1、查这个表空间有哪些mview的语句：select table_name, tablespace_name from dba_tableswhe...
2012-08-02 15:47:10
1265
转载 EXP-00083: 调用 SYS.LT_EXPORT_PKG.schema_info_exp
正在导出pre-schema过程对象和操作EXP-00008:遇到ORACLE错误6550ORA-06550:line1,column13:PLS-00201:identifier'SYS...
2012-08-02 15:21:08
448
转载 rac 缺失本地节点node1的信息
rac 缺失本地节点node1的信息问题原因:public网卡和private网卡设置反了会出现这个问题要修改网卡的优先级，public的高于private的，具体步骤就是：右键网络邻居－》选择属性－》进入后选择windows菜...
2010-08-05 14:21:16
241
转载 ORA-01287 from a different database incarnation
SQL> execute dbms_logmnr.add_logfile('/opt/oracle/oradata/archive/1_53_724790729.dbf',dbms_logmnr.removefile);P...
2010-07-22 11:00:25
399
转载 ORA-07445: exception encountered: [Address not mapped to object]
ORA-07445: exception encountered: core dump [krvrdegsFF()+21] [SIGSEGV] [Address not mapped to object] 未解决，记录一下SQL...
2010-07-21 16:28:09
372
转载 ORA-06544: PL/SQL: internal error, arguments: [56319]
数据库恢复后错误：SQL> create user testuser identified by testuser;create user testuser identified by testuser...
2010-07-21 10:15:30
357
转载 ORA-01031 insufficient privileges
SQL> conn sys/xxxdb@xxxdb as sysdbaERROR:ORA-01031: insufficient privileges原因：没有密码文件orapwd oracle@standby:~/pro...
2010-07-21 10:08:08
109
转载 ORA-00314: log 2 of thread 1, expected sequence# 53 doesn't match 2
SQL> host oerr ora 31400314, 00000, "log %s of thread %s, expected sequence# %s doesn't match %s"// *Cause: T...
2010-07-19 15:52:30
219
转载 ORA-00600: internal error code, arguments: [4193],
Sun Jul 18 21:47:20 2010Errors in file /opt/oracle/admin/xxxdb/bdump/xxxdb_j000_4337.trc:ORA-00600: internal error...
2010-07-19 14:56:45
422
转载 ORA-00313: open failed for members of log group
ORA-00313: open failed for members of log group 4 of thread 0ORA-00312: online log 4 thread 0: '/opt/oracle/oradat...
2010-07-16 14:51:06
327
转载 ORA-01552: cannot use system rollback segment
SQL> conn testhotback/testhotback;Connected.SQL> create table test (id number,name varchar2(10));create tab...
2010-07-16 13:43:17
232
转载 set serveroutput on
使用set serveroutput on 命令设置环境变量serveroutput为打开状态，从而使得pl/sql程序能够再SQL*plus和SQL*plus中输出结果set serveroutput on--set serv...
2008-08-04 10:49:46
191
转载 7 PL/SQL单行函数和组函数详解
参见:http://dev.yesky.com/SoftChannel/72342371928965120/20021014/1634646_1.shtmlLTRIM(c1,c2) 把c1中最左边的字符去掉，使其第一个字符...
2008-08-01 17:04:02
85
转载 6 error 待查
SQL> CREATE OR REPLACE PROCEDURE COUNT_EMP 2 ( 3 reccount OUT NUMBER 4 ) 5 IS 6 BEGIN 7 SELEC...
2008-08-01 16:15:37
103
转载 5 plsql 控制结构
plsql 控制结构参见：http://www.programbbs.com/doc/73.htm语法和用途 IF..THEN 语法：IF condition THEN Statements 1; Stat...
2008-08-01 16:03:06
92
转载 4 execute procedure （在另一个命名程序块或匿名程序块中执行这个程序，那么就不需要EXECUTE关进字。）...
在另一个命名程序块或匿名程序块中执行这个程序，那么就不需要EXECUTE关进字。SQL> conn scott/tiger已连接。SQL> declare 2 v_dept number; 3 begin ...
2008-08-01 15:44:04
290
转载 关于 oracle select into
select..into is part of PL/SQL language which means you have to use itinside a PL/SQL block. You can not use it ...
2008-08-01 15:32:13
94
转载 3 execute procedure
SQL> select sal,comm from emp where deptno=10; SAL COMM---------- ---------- 2450 24500...
2008-08-01 15:13:34
429
转载 2 create or replace procedure
SQL> create or replace procedure update_commission 2 (v_dept in number,v_pervent in number default 10) i...
2008-08-01 15:01:34
1447
转载 1 简单的plsql
SQL> select comm from emp where deptno=10; COMM----------SQL> declare 2 v_comm_percent constant num...
2008-08-01 14:49:05
124
转载 开始学习 pl/sq
开始学习 pl/sql计划2周时间，学习简单的pl/sql；相关资料：http://www.programbbs.com/doc/71.htmL/SQL教程http://www.oracle.com/technology/glo...
2008-08-01 14:19:54
92
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人