Run Time error 40002. ORA-01013

|
laurent
|
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 20 years ago (Thread Starter)
|
|
About laurent |
|
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=8276
Last Reply Posted 9/19/2001 11:46:00 PM)
|
|
|
Location=-- USA
|
|
 |
|
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 20 years ago
|
|
About pedrogato |
|
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
|
|
 |
Most Recent Post
|
laurent
|
Thanks Pedro! I have found a solution. I have just added after the SELECT /+ * ALL_ROWS */ and the query works fine
|
Posted 20 years ago (Thread Starter)
|
|
About laurent |
|
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
|
|
Revive Thread!
Add a comment to revive this old thread and make this archived thread more useful.
Thread #3754 Counter |
8276 |
Since 4/2/2008
|
|
|
|