I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardOracle Topic   Print This     

Run Time error 40002. ORA-01013

Run Time error 40002. ORA-01013 in Oracle topic (part of our DBA, Databases, & Data group).

Quick Search: Run Time   Run Time error   40002 ORA  
laurent
-- USA
I have a run-time error 40002 when running an application (VB5). This is the following message I have when a selection query (with 9 joins):S1T00:[Oracle][ODBC]ORA-01013: user requested cancel of current operation.
The query takes, wheter with ODBC test or Sql+, 5 minutes to be executed. This is too long for a user who is waiting for a result. was wondering if there are otpions to set, or optimization rules or paramters to set.
Thanks for any answer.
Laurent
 Posted 18 years ago (Thread Starter)
Comment Quote
About laurent -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #3754, 2 replies
Thread Started 9/14/2001 1:55:00 AM
View Counter=7997
Last Reply Posted 9/19/2001 11:46:00 PM)
Location=-- USA 
Joined=18 years ago   MB Posts=4  
pedrogato
 (Inactive)
Lisboa,Portugal
If have 9 joins , thus that means you are using 9 tables in your select ? If so i recomend you to create at least one index on at least one of the fields for each table used in the select clause 'WHERE'.

Remember to create your index files in another tablespace .

I hope this will help you .
 Posted 18 years ago
Comment Quote
About pedrogato -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #3757 (Level 1.1)  Reply to 3754
Thread Started 9/14/2001 4:21:00 AM
View Counter=2
Location=Lisboa,Portugal  
Joined=19 years ago   MB Posts=35  
Most Recent Post
laurent
-- USA
Thanks Pedro! I have found a solution. I have just added after the SELECT /+ * ALL_ROWS */ and the query works fine
 Posted 18 years ago (Thread Starter)
Comment Quote
About laurent -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #3810 (Level 1.2)  Reply to 3754
Reply Posted 9/19/2001 11:46:00 PM
Location=-- USA 
Joined=18 years ago   MB Posts=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1242A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #3754 Counter
7997
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech