Errors in clear_vir01, file-03, and Oracle alert log
- Article Type: General
- Product: Aleph
- Product Version: 20
Problem Symptoms:
1. clear_vir01 and file-03 ((Export Database Tables) take 8 minutes (rather than a single minute)
2. clear_vir01 has the following errors:
identifier 'F1_Z52' must be declared
object F1_Z52 does not exist
Username:SQL*Loader-350: Syntax error at line 1.
Expecting keyword LOAD, found "*".
3. file-03 has the following error:
identifier 'DUMP_DLM_TABLE_1_Z305' must be declared
4. Error in Oracle alert log:
ORA-1654: unable to extend index SYS.I_WARNING_SETTINGS by 8 in tablespace
SYSTEM
Cause:
As seen in util o/14/1:
TABLESPACE_WITHOUT_FREE_SPACE
------------------------------
SYSTEM
Resolution:
Add datafile to SYSTEM tablespace using util o/13/3 (or directly in Oracle).
Additional Information
1. The complete clear_vir01 log shows the following errors:
vir01@ALEPH20> > > > > 2 begin f1_Z52; end;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'F1_Z52' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
No errors.
1* begin f1_Z52; end;
drop procedure f1_Z52
*
ERROR at line 1:
ORA-04043: object F1_Z52 does not exist
2 begin f2_Z52; end;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'F2_Z52' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
<etc.>
2. file-03 log showing errors:
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DUMP_DLM_TABLE_1_Z305' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
No errors.
1* begin dump_dlm_table_1_Z305; end;
2 begin dump_dlm_table_2_Z305; end;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DUMP_DLM_TABLE_2_Z305' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
<etc.>
Category: System Management (500)
Subject: Oracle (500)
- Article last edited: 10/8/2013