Home » RDBMS Server » Server Administration » ora-01008 not all variables bound (oracle 10.2.0.3)
ora-01008 not all variables bound [message #314416] Wed, 16 April 2008 11:39 Go to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
Hello,

I have just started receiving an error from a job that has been running for quite a long time. We are testing 10.2.0.3. The job issues the stmt:

begin
dbms_stats.gather_table_stats('SCH', 'TABONE',
granularity=> 'ALL', estimate_percent=>10,
cascade=TRUE);
end;

it is failing with ora_01008 not all variable bound.

If I issue the stmt"

begin
dbms_stats.gather_table_stats('SCH', 'TABONE',
granularity=>'SUBPARTITION', partname=>'SP1',
estimate_percent=>10, cascade=TRUE);

it works.

If I specify granularity=> 'PARTITION' and provide a partition name it works.

If I only specify schema owner and table_name it fails on the ora_01008.

Has anybody experienced this in 10.2? Can you provide any insight in what is happening here. This is running in our production system which is 9.2.0.7. We are trying to upgrade to 10.2.0.3, but keep running into things like this?

Appreciate any help you can provide,

Bill
Re: ora-01008 not all variables bound [message #314424 is a reply to message #314416] Wed, 16 April 2008 11:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
known bug. Forgot the exact bug#/details. Please check metalink.
Seems the issue is something to do with the cascade option.
Re: ora-01008 not all variables bound [message #314426 is a reply to message #314424] Wed, 16 April 2008 11:53 Go to previous messageGo to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
Thank You Mahesh. I'll check metalink for cascade.

Bill
Re: ora-01008 not all variables bound [message #315072 is a reply to message #314426] Fri, 18 April 2008 18:58 Go to previous messageGo to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
well, I checked metalink and couldn't find anything that related to this issue. i opened a tar with support and they are looking into it. ( I'm not holding my breath ). Just for fun I ran the same dbms_stats against a table that is list partitioned and it worked just fine. The table that is failing is composite (range-list) partitioned . Then I tried another table that is composite partitiioned and it failed. It seems like this just doesn't work on composite partitioned tables.
Re: ora-01008 not all variables bound [message #315226 is a reply to message #315072] Sun, 20 April 2008 02:31 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Oracle 10.2.0.3 seems to be having lot of bugs.. I am atleast waiting for 10.2.0.4 on Sparc ..
Re: ora-01008 not all variables bound [message #315234 is a reply to message #315226] Sun, 20 April 2008 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Oracle 10.2.0.3 seems to be having lot of bugs

As all versions and as will have 10.2.0.4.

Regards
Michel
Re: ora-01008 not all variables bound [message #315258 is a reply to message #314416] Sun, 20 April 2008 09:38 Go to previous messageGo to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
Yes lots of bugs. I upgraded from 9i to keep current and for support. I am a really disappointed with the number of issues that I've run into with this release. When 10.2.0.4 becomes available I plan to install it and do a LOT of testing.
Re: ora-01008 not all variables bound [message #315776 is a reply to message #314416] Tue, 22 April 2008 14:31 Go to previous message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
oracle has acknowledged that this is a bug #6867210. there is no available fix yet
Previous Topic: IDLE_TIME & CONNECT_TIME in seconds
Next Topic: Manage alertSID.log
Goto Forum:
  


Current Time: Sun Dec 11 08:19:23 CST 2016

Total time taken to generate the page: 0.09555 seconds