triggers属性错误,如何解决 各位:NT2K,ora9I,用了两年多了,基本上没出现什么大的错误可是最近用户莫名其妙的功能或这或那样的错误,进去triggers一看,发现所有的存贮过程均提示“XXXXXXXXX属性不可用”从未碰到这类问题,看了日志也很正常,没有很奇怪的错误,各位帮忙分析下,谢了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Mon May 07 10:44:48 2007Thread 1 advanced to log sequence 674 Current log# 2 seq# 674 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO02.LOGWed May 09 10:30:39 2007Thread 1 advanced to log sequence 675 Current log# 3 seq# 675 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO03.LOGFri May 11 08:55:15 2007Thread 1 advanced to log sequence 676 Current log# 1 seq# 676 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO01.LOGSat May 12 21:16:42 2007Thread 1 advanced to log sequence 677 Current log# 2 seq# 677 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO02.LOGMon May 14 22:02:59 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS02.ORA' AUTOEXTEND ONMon May 14 22:02:59 2007Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:03:14 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS03.DBF' AUTOEXTEND ONMon May 14 22:03:14 2007Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:03:25 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS04.DBF' AUTOEXTEND ONMon May 14 22:03:25 2007Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:03:33 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS05.DBF' AUTOEXTEND ONCompleted: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:03:41 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS05.DBF' AUTOEXTEND ON MAXSIZE UNLIMITEDCompleted: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEDump file d:\oracle\admin\finance\bdump\alert_finance.logMon May 14 22:18:34 2007ORACLE V9.2.0.1.0 - Production vsnsta=0vsnsql=12 vsnxtr=3Windows 2000 Version 5.0 Service Pack 4, CPU type 586Mon May 14 22:18:34 2007Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0SCN scheme 2Using log_archive_dest parameter default valueLICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 9.2.0.1.0.System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 268435456 sga_max_size = 881926444 large_pool_size = 16777216 java_pool_size = 0 control_files = D:\oracle\oradata\Finance\control01.ctl, D:\oracle\oradata\Finance\control02.ctl, D:\oracle\oradata\Finance\control03.ctl db_block_size = 16384 db_cache_size = 578813952 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = com instance_name = Finance hash_join_enabled = TRUE background_dump_dest = D:\oracle\admin\Finance\bdump user_dump_dest = D:\oracle\admin\Finance\udump core_dump_dest = D:\oracle\admin\Finance\cdump sort_area_size = 524288 db_name = Finance open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 412090368PMON started with pid=2DBW0 started with pid=3LGWR started with pid=4CKPT started with pid=5SMON started with pid=6RECO started with pid=7Mon May 14 22:18:52 2007alter database mount exclusive Mon May 14 22:18:57 2007Successful mount of redo thread 1, with mount id 2442531980.Mon May 14 22:18:57 2007Database mounted in Exclusive Mode.Completed: alter database mount exclusiveMon May 14 22:18:57 2007alter database openMon May 14 22:18:58 2007Beginning crash recovery of 1 threadsMon May 14 22:18:58 2007Started first pass scanMon May 14 22:18:58 2007Completed first pass scan 1772 redo blocks read, 270 data blocks need recoveryMon May 14 22:18:58 2007Started recovery at Thread 1: logseq 677, block 128728, scn 0.0Recovery of Online Redo Log: Thread 1 Group 2 Seq 677 Reading mem 0 Mem# 0 errs 0: D:\ORACLE\ORADATA\FINANCE\REDO02.LOGMon May 14 22:18:58 2007Ended recovery at Thread 1: logseq 677, block 130500, scn 0.43419933 270 data blocks read, 270 data blocks written, 1772 redo blocks readCrash recovery completed successfullyMon May 14 22:18:58 2007Thread 1 advanced to log sequence 678Thread 1 opened at log sequence 678 Current log# 3 seq# 678 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO03.LOGSuccessful open of redo thread 1.Mon May 14 22:18:59 2007SMON: enabling cache recoveryMon May 14 22:18:59 2007Undo Segment 1 OnlinedUndo Segment 2 OnlinedUndo Segment 3 OnlinedUndo Segment 4 OnlinedUndo Segment 5 OnlinedUndo Segment 6 OnlinedUndo Segment 7 OnlinedUndo Segment 8 OnlinedUndo Segment 9 OnlinedUndo Segment 10 OnlinedSuccessfully onlined Undo Tablespace 1.Mon May 14 22:19:00 2007SMON: enabling tx recoveryMon May 14 22:19:00 2007Database Characterset is ZHS16GBKreplication_dependency_tracking turned off (no async multimaster replication found)Completed: alter database openMon May 14 22:42:45 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS01.DBF' AUTOEXTEND ON MAXSIZE UNLIMITEDMon May 14 22:42:45 2007Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:42:51 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS01.DBF' AUTOEXTEND ON MAXSIZE UNLIMITEDCompleted: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:43:28 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS02.ORA' AUTOEXTEND ON NEXT 1024KMon May 14 22:43:28 2007Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:43:40 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS03.DBF' AUTOEXTEND ON NEXT 1024KMon May 14 22:43:40 2007Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:43:45 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS03.DBF' AUTOEXTEND ON NEXT 1024MCompleted: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:43:54 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS02.ORA' AUTOEXTEND ON NEXT 1024MCompleted: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:44:07 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS04.DBF' AUTOEXTEND ON NEXT 1024MMon May 14 22:44:07 2007Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLEMon May 14 22:44:17 2007/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS05.DBF' AUTOEXTEND ON NEXT 1024KCompleted: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLETue May 15 12:25:56 2007/* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERs05.DBF' SIZE 2000MTue May 15 12:25:56 2007ORA-1537 signalled during: /* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAF...Tue May 15 12:26:10 2007/* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERs06.DBF' SIZE 2000MTue May 15 12:26:32 2007Completed: /* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAFTue May 15 12:27:38 2007/* OracleOEM */ ALTER DATABASE TEMPFILE 'D:\ORACLE\ORADATA\FINANCE\TEMP01.DBF' RESIZE 2000MTue May 15 12:27:38 2007Completed: /* OracleOEM */ ALTER DATABASE TEMPFILE 'D:\ORACLEWed May 16 20:38:26 2007Thread 1 advanced to log sequence 679 Current log# 1 seq# 679 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO01.LOG 热备份还原问题 求SQL语句,两张表结果某个字段相加 求解:Pre_Block触发器一般在什么时候被执行 如何获取数据库表 的 列名 一个关于触发器的问题 pro*c编程中,prepare怎么用,谢谢了!^_^ 有一个服务不能启动-oracleorahome81clientcache服务 统计连续次数sql怎么写?谢谢各位大哥啦! snapshot too old (Ora-1555) 新手问题:system,sys,internal帐号的作用及区别? 行列转换的问题 存储过程的结果能输出到C语言变量吗?
Mon May 07 10:44:48 2007
Thread 1 advanced to log sequence 674
Current log# 2 seq# 674 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO02.LOG
Wed May 09 10:30:39 2007
Thread 1 advanced to log sequence 675
Current log# 3 seq# 675 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO03.LOG
Fri May 11 08:55:15 2007
Thread 1 advanced to log sequence 676
Current log# 1 seq# 676 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO01.LOG
Sat May 12 21:16:42 2007
Thread 1 advanced to log sequence 677
Current log# 2 seq# 677 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO02.LOG
Mon May 14 22:02:59 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS02.ORA' AUTOEXTEND ON
Mon May 14 22:02:59 2007
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:03:14 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS03.DBF' AUTOEXTEND ON
Mon May 14 22:03:14 2007
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:03:25 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS04.DBF' AUTOEXTEND ON
Mon May 14 22:03:25 2007
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:03:33 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS05.DBF' AUTOEXTEND ON
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:03:41 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS05.DBF' AUTOEXTEND ON MAXSIZE UNLIMITED
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Dump file d:\oracle\admin\finance\bdump\alert_finance.log
Mon May 14 22:18:34 2007
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Mon May 14 22:18:34 2007
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 268435456
sga_max_size = 881926444
large_pool_size = 16777216
java_pool_size = 0
control_files = D:\oracle\oradata\Finance\control01.ctl, D:\oracle\oradata\Finance\control02.ctl, D:\oracle\oradata\Finance\control03.ctl
db_block_size = 16384
db_cache_size = 578813952
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain = com
instance_name = Finance
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\Finance\bdump
user_dump_dest = D:\oracle\admin\Finance\udump
core_dump_dest = D:\oracle\admin\Finance\cdump
sort_area_size = 524288
db_name = Finance
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 412090368
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon May 14 22:18:52 2007
alter database mount exclusive
Mon May 14 22:18:57 2007
Successful mount of redo thread 1, with mount id 2442531980.
Mon May 14 22:18:57 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon May 14 22:18:57 2007
alter database open
Mon May 14 22:18:58 2007
Beginning crash recovery of 1 threads
Mon May 14 22:18:58 2007
Started first pass scan
Mon May 14 22:18:58 2007
Completed first pass scan
1772 redo blocks read, 270 data blocks need recovery
Mon May 14 22:18:58 2007
Started recovery at
Thread 1: logseq 677, block 128728, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 677 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\FINANCE\REDO02.LOG
Mon May 14 22:18:58 2007
Ended recovery at
Thread 1: logseq 677, block 130500, scn 0.43419933
270 data blocks read, 270 data blocks written, 1772 redo blocks read
Crash recovery completed successfully
Mon May 14 22:18:58 2007
Thread 1 advanced to log sequence 678
Thread 1 opened at log sequence 678
Current log# 3 seq# 678 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO03.LOG
Successful open of redo thread 1.
Mon May 14 22:18:59 2007
SMON: enabling cache recovery
Mon May 14 22:18:59 2007
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon May 14 22:19:00 2007
SMON: enabling tx recovery
Mon May 14 22:19:00 2007
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon May 14 22:42:45 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS01.DBF' AUTOEXTEND ON MAXSIZE UNLIMITED
Mon May 14 22:42:45 2007
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:42:51 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS01.DBF' AUTOEXTEND ON MAXSIZE UNLIMITED
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:43:28 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS02.ORA' AUTOEXTEND ON NEXT 1024K
Mon May 14 22:43:28 2007
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:43:40 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS03.DBF' AUTOEXTEND ON NEXT 1024K
Mon May 14 22:43:40 2007
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:43:45 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS03.DBF' AUTOEXTEND ON NEXT 1024M
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:43:54 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS02.ORA' AUTOEXTEND ON NEXT 1024M
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:44:07 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS04.DBF' AUTOEXTEND ON NEXT 1024M
Mon May 14 22:44:07 2007
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Mon May 14 22:44:17 2007
/* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERS05.DBF' AUTOEXTEND ON NEXT 1024K
Completed: /* OracleOEM */ ALTER DATABASE DATAFILE 'D:\ORACLE
Tue May 15 12:25:56 2007
/* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERs05.DBF' SIZE 2000M
Tue May 15 12:25:56 2007
ORA-1537 signalled during: /* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAF...
Tue May 15 12:26:10 2007
/* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAFILE 'D:\ORACLE\ORADATA\FINANCE\USERs06.DBF' SIZE 2000M
Tue May 15 12:26:32 2007
Completed: /* OracleOEM */ ALTER TABLESPACE "USERS" ADD DATAF
Tue May 15 12:27:38 2007
/* OracleOEM */ ALTER DATABASE TEMPFILE 'D:\ORACLE\ORADATA\FINANCE\TEMP01.DBF' RESIZE 2000M
Tue May 15 12:27:38 2007
Completed: /* OracleOEM */ ALTER DATABASE TEMPFILE 'D:\ORACLE
Wed May 16 20:38:26 2007
Thread 1 advanced to log sequence 679
Current log# 1 seq# 679 mem# 0: D:\ORACLE\ORADATA\FINANCE\REDO01.LOG