ORA-13707: Either the start snapshot string or the end
snapshot string is incomplete or missing key statistics.
- 1 Answers
- 3301 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Cause: Either the start or the end snaphots was missing or
purged or had encountered errors while creating them.
Action: Verify that AWR is done taking these two snapshots,
or Look in DBA_HIST_SNAP_ERROR to find what tables are
missing in the start/end snapshots. Use the ERROR_NUMBER
column in that view together with the alert log to identify
the reason for failure and take necessary action to prevent
such failures in the future. Try running ADDM on a different
snapshot range that has valid start and end snapshots.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.
ORA-26095: unprocessed stream data exists
NZE-28890: Entrust Login Failed
ORA-26032: index string.string loading aborted after string keys
NZE-28868: Peer certificate chain check failed.
ORA-16516: The current state is invalid for the attempted operation.
IMG-02003: 2FF03 - incorrect color histogram feature specification
Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...
ORA-26027: unique index string.string partition string initially in unusable state
Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...
ORA-26082: load of overlapping segments on table string.string is not allowed
When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............
ORA-26079: file "string" is not part of table string.string
IMP-00070: Lob definitions in dump file are inconsistent with database.
ORA-26076: cannot set or reset value after direct path structure is allocated
