ORA-26027: unique index string.string partition string
initially in unusable state
6137
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...
2243
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.
2316
ORA-26076: cannot set or reset value after direct path
structure is allocated
1457
ORA-26030: index string.string had string partitions made
unusable due to:
1540
ORA-07497: sdpri: cannot create trace file 'string'; errno =
string.
2299
ORA-16627: No standby databases support the overall
protection mode.
3531
ORA-16516: The current state is invalid for the attempted
operation.
8044
[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
2269
ORA-26095: unprocessed stream data exists
2754
IMP-00070: Lob definitions in dump file are inconsistent
with database.
1269
ORA-26094: stream format error: input column overflow
2232
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...
2123
IMP-00064: Definition of LOB was truncated by export
5865
NZE-28868: Peer certificate chain check failed.
2250