local : oracle9.2.0.1remote: oracle9.2.0.6SQL> SET AUTOTRACE TRACEONLYSQL> insert into T_ZYTJ_LS2(swjg, jls, je, nsrs, lb)3select A.zsjg_dm swjg, count(*) jls, sum(a.sj_je) je, '02', '01'4from A@NM A ,B@NM B5where a.xg_sj >= to_date('20080422', 'YYYYMMDD')6and a.xh_xh =B.XH_XH7AND B.xhxt_sj >= to_date('20080422', 'YYYYMMDD')8and a.zsxm_dm not in ('66', '68', '97', '65')9and a.zf_bj = '0'10group by

环境 hp-ux11 + oracle9206 + veritas2年前曾经进行过数据库的数据文件，删除了1个数据文件，是从操作系统上删除的，于是目前数据库中dba_data_files中存在dev/rdsk/rlvol40 状态为空的条目，而每次veritas 备份的日志中总是有这样的错误： /dev/rdsk/rlvol40找不到， 但是最后总是提示backup success!目前想进行数据库的完全恢复，但是restore database 的时候 ，却报RMAN-03002: failure of restore command at 06/1/2008 01:19:01RMAN-06026: some targets not found - aborting restoreRMAN-06023: no backup or copy of

如题！

关于查询重写的问题oracle9.2.0.6SQL> desc T1NameTypeNullable Default Comments------------- ------------- -------- ------- ----------------------------------------------------------------------------ZSJG_DMVARCHAR2(11)YGLJG_DMVARCHAR2(11)YDJGLJG_DMVARCHAR2(11)YHSJG_DMVARCHAR2(11)YJCJG_DM