Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

ORA-01556: MINEXTENTS for rollback segment must be greater than 1

1 3447

ORA-01557: rollback segment extents must be at least string blocks

1 3484

ORA-01558: out of transaction ID's in rollback segment string

1 4414

ORA-01559: MAXEXTENTS for rollback segment must be greater than 1

1 3007

ORA-01560: LIKE pattern contains partial or illegal character

2 6232

ORA-01561: failed to remove all objects in the tablespace specified

1 9910

ORA-01562: failed to extend rollback segment number string

1 4760

ORA-01563: rollback segment is PUBLIC, need to use the keyword PUBLIC

1 3933

ORA-01564: rollback segment is not PUBLIC

1 3643

ORA-01565: error in identifying file 'string'

1 6068

ORA-01566: file specified more than once in DROP LOGFILE

1 3545

ORA-01567: dropping log string would leave less than 2 log files for instance string (thread string)

1 10283

ORA-01568: cannot set space quota on PUBLIC

1 3584

ORA-01569: data file too small for system dictionary tables

1 3545

ORA-01570: MINEXTENTS must be no larger than the string extents currently allocated

1 4005

Un-Answered Questions { Database Errors }

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

2670

What is Mutex error in Triggers?

3132

ORA-16516: The current state is invalid for the attempted operation.

8883

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6723

What severity level errors are managed in TRY-CATCH block?

2269

IMG-02003: 2FF03 - incorrect color histogram feature specification

1769

What is SCD (Slowly Changing Dimensions)? What are its types?

2723

ORA-26079: file "string" is not part of table string.string

2008

ORA-26032: index string.string loading aborted after string keys

2183

RMAN-05017: no copy of datafile number found to recover

2471

ORA-16626: failed to enable specified object

2278

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1671

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2779

ORA-26084: direct path context already finished

2001

what is new g/l functionality

2681

For More Un-Answered { Database Errors } Questions Click Here