Solved

How can I get rid of ORA-08103 Error?

Posted on 2014-12-28
5
341 Views
Last Modified: 2015-01-08
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
Comment
Question by:GurcanK
  • 3
5 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40520988
My guess is that some other process has dropped TMP_TABLE before this code has completed the run.
0
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 40521104
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
 

Author Comment

by:GurcanK
ID: 40521388
Thnaks everyone, Slightwv was right, I revealed that another user drops.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40522793
Glad to help.  Don't forget to close out the question.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40528488
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to free up undo space? 3 50
SYS password changed. Now can't log in as SYS 27 28
Fill Null values 5 28
Read XML values 8 41
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question