ORA-ERR
文章平均质量分 51
风之子ADAM
这个作者很懒,什么都没留下…
展开
-
ora-03297处理
1.先查看下表空间的使用情况,如果使用了1G,要resize到800M,当然是不行的。使用如下脚本--------------------------------------------------------------------------------------------- SCRIPT: DF.SQL-- PURPOSE: Show Oracle tablespace fre原创 2014-02-21 14:55:22 · 1601 阅读 · 0 评论 -
SQL 列转行/list agg 列超长处理方法
CREATE USER tester IDENTIFIED BY tester ;grant dba,resource,connect to tester; conn tester/testercreate table t24(num number,a varchar2(30));beginfor i in 1.. 1000loopinsert into原创 2014-05-14 20:21:33 · 3197 阅读 · 0 评论 -
ORA-01110: data file
测试场insert 操作时报错。ORA-01110: data file 4: '/home/XXX/data/XXX_01.dbf'。先查看了下DB状态,是OPEN。DF,看空间大小,也没满。从dba_data_files中找出这个DBF对应的TABLESPACE,去dba_tablespaces中看了下它的状态。为READ ONLY!有点慌。。快速查看了所有的表空间哪些是REA原创 2014-03-05 13:50:00 · 5506 阅读 · 0 评论 -
ORA-32773: operation not supported for smallfile tablespace
想把TABLESPACE从autoextend on改成autoextend off,使用以下语句就会报错:alter tablespace TEST_DATA autoextend off;要从DATAFILE 那里改:alter database datafile‘XXXXXXXXXX/XX/A.DBF’autoextend off;批量使用se原创 2014-03-26 19:58:59 · 1476 阅读 · 0 评论 -
ORA-28000: the account is locked
找出被锁的用户然后,解锁。SELECT a.session_id, s.SERIAL#,a.oracle_username, a.os_user_name, s.machine, b.object_name FROM v$locked_object a, all_objects b, v$session sWHERE a.object_id = b.object_id and a.SESS原创 2014-03-26 09:16:24 · 727 阅读 · 0 评论 -
ORA-00911: 无效字符,PL/SQL: ORA-01790 表达式必须具有与对应表达式相同的数据类型
ORA-00911: 无效字符SET SERVEROUTPUT ON beginexecute immediate 'select * from dual;';end;/动态拼出来的SQL,加了分号后,比较容易出这个问题。改成execute immediate 'select * from dual'; 就OKPL/SQL: ORA-01790: 表达式必须原创 2014-05-07 07:44:35 · 9296 阅读 · 0 评论 -
ORA-03113 end-of-file on communication channel 问题解决
SQL> startup forceORACLE instance started.Total System Global Area 2672361472 bytesFixed Size 2256232 bytesVariable Size 1392509592 bytesDatabase Buffers原创 2014-03-11 11:38:15 · 1137 阅读 · 0 评论 -
IMP-00013: 只有 DBA 才能导入由其他 DBA 导出的文件
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit ProductionWith the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via convent原创 2014-03-13 14:29:40 · 1075 阅读 · 0 评论 -
ora-00918
ORA-00918: column ambiguously defined这个说明选择的列可能在多个表中存在,需要指明是哪张表。如T1,T2都有NAME这个列,以下SQL就会报这个错。select NAME from T1,T2 where XXXXXXXXX;这时需要指明NAME具体是T1,或是T2中的。改成select t1.name from T1,T2 where XX原创 2014-03-06 08:09:20 · 1368 阅读 · 0 评论 -
ORA-39250
使用transport tablespace从11.2.0.0到10.2.0.5,加version参数后,有这个错误。查证为ORACLE Bug 10297446。直接用DBLINK +DATAPUMP没啥问题,只能回避用TRANSPORT TABLESPACE.原创 2014-03-03 18:01:44 · 811 阅读 · 0 评论 -
ora-39002 invalid operation
使用expdp导出时遇到如下错误:ORA-39002: invalid operationORA-39070: Unable to open the log file.ORA-29283: invalid file operationORA-06512: at "SYS.UTL_FILE", line 475ORA-29283: invalid file operation原创 2014-02-19 13:58:26 · 2291 阅读 · 0 评论 -
ORA-00257解决
ORA-00257: archiver error.Connect internal only, until freed. Cause: Thearchiver process received an error while trying to archive a redo log. If theproblem is not resolved soon, the database will原创 2014-02-18 09:59:17 · 837 阅读 · 0 评论 -
ORA-01157: cannot identify/lock data file
删除了DBF文件,遇到ORA-01157: cannot identify/lock data file 101 – see DBWR trace fileORA-01110: data file 101: ‘xxxx.dbf’使用以下方式可以进到到OPEN 状态alter database datafile 101 offline drop;SQL> startup原创 2014-02-27 17:02:23 · 611 阅读 · 0 评论 -
ORACLE 存储过程权限问题
create user tester identified by tester; grant connect ,dba to tester; create user tester2 identified by tester; grant connect,resource to tester2; conn tester2/tester create table t1(aa原创 2014-05-28 07:20:04 · 791 阅读 · 0 评论