ORA-39135: SYS schema cannot read data using specific SCNs

Question Posted / guest

1 Answers
8022 Views
I also Faced
E-Mail Answers

ORA-39135: SYS schema cannot read data using specific SCNs..

Answer / guest

Cause: The user was operating under the SYS schema and
either explicitly specified an SCN via the FLASHBACK_SCN or
FLASHBACK_TIME or TABLE_CONSISTENCY parameters or the job
required that a specific SCN be used because of streams or
logical replication activity.

Action: Do not perform Data Pump jobs using the SYS schema
or 'AS SYSDBA'.

Please add more information about this Error

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More Oracle Errors Interview Questions

LPX-00608: Repeated declaration of '~1S' in element '~2S'.

1 Answers

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...

0 Answers IBM,

ORA-07849: sllfsk: $GET failure

1 Answers

ORA-31464: target table for the change table no longer exists

1 Answers

NNO-00253: administrative region parameter string length string exceeds maximum of string

1 Answers

ORA-31050: Access denied

1 Answers

ORA-35078: (QFHEAD05) An EIF extension file header for string is not in the correct format.

1 Answers

ORA-00070: command string is not valid