ora-01008 not all variables bound [message #314416] |
Wed, 16 April 2008 11:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #315072 is a reply to message #314426] |
Fri, 18 April 2008 18:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #315258 is a reply to message #314416] |
Sun, 20 April 2008 09:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|