• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 413
  • Last Modified:

How can I get rid of ORA-08103 Error?

Dear Experts,

I sometimes get ORA-08103 error for the following PL/SQL code. Could you please help me?

Best Regards.

DECLARE
[There is Single Line Declaration]
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET db_file_multiblock_read_count=16';
INSERT  /*+ APPEND PARALLEL NOLOGGING */  INTO MAINTABLE (<Column List>) SELECT (<Column List>) FROM TMP_TABLE;
COMMIT;
EXECUTE IMMEDIATE 'TRUNCATE TABLE TMP_TABLE DROP STORAGE';
END;

ORA-08103: at line 5. object no longer exists
ORA-06512: at line 3. Sql: DECLARE
0
GurcanK
Asked:
GurcanK
  • 3
1 Solution
 
slightwv (䄆 Netminder) Commented:
My guess is that some other process has dropped TMP_TABLE before this code has completed the run.
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
1. Can you give us the line what is in the declare section as well.. may be you could change the name of the variable/mask it accordingly.

2. Also could you please help to add an exception handling section to your plsql block to trap the errors as shown below.

DECLARE
 [There is Single Line Declaration]
 BEGIN
 EXECUTE IMMEDIATE 'ALTER SESSION SET db_file_multiblock_read_count=16';
 INSERT  /*+ APPEND PARALLEL NOLOGGING */  INTO MAINTABLE (<Column List>) SELECT (<Column List>) FROM TMP_TABLE;
 COMMIT;
 EXECUTE IMMEDIATE 'TRUNCATE TABLE TMP_TABLE DROP STORAGE';
Exception
when others then
dbms_output.put_line('In exception section:' );
dbms_output.put_line('sqlcode:' || sqlcode );
dbms_output.put_line(sqlerr:' || sqlerrm );
 END;
0
 
GurcanKAuthor Commented:
Thnaks everyone, Slightwv was right, I revealed that another user drops.
0
 
slightwv (䄆 Netminder) Commented:
Glad to help.  Don't forget to close out the question.
0
 
slightwv (䄆 Netminder) Commented:
GurcanK,

Can I ask why there was an even split of points here?  I don't see how http:#a40521104 helped answer the question.

I don't have  a problem if you wanted to offer some points as an assist for exception handling but that has nothing to do with what was generating the error.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now