OraFAQ Forum: SQL & PL/SQL » ora-03001 unimplemented feature

Home » SQL & PL/SQL » SQL & PL/SQL » ora-03001 unimplemented feature (toad 9.1 ,oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-03001 unimplemented feature [message #308062]

Thu, 20 March 2008 23:50

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
pls note on this query while running this in oracle 9i
it gets following error

SELECT st_week, GROUPING (st_week) AS g_st_week, st_start_dt,
GROUPING (st_start_dt) AS g_st_start_dt, st_end_dt,
GROUPING (st_end_dt) AS g_st_end_dt, st_origin_group,
GROUPING (st_origin_group) AS g_st_origin_group, st_origin,
GROUPING (st_origin) AS g_st_origin, st_destination_group,
GROUPING (st_destination_group) AS g_st_destination_group,
st_destination, GROUPING (st_destination) AS g_st_destination,
st_contr_group, GROUPING (st_contr_group) AS g_st_contr_group,
st_init_rate, GROUPING (st_init_rate) AS g_st_init_rate,
rate,GROUPING (rate) AS g_rate,
st_revenue,
GROUPING (st_revenue) AS g_st_revenue, st_route_exists_flag,
GROUPING (st_route_exists_flag) AS g_st_route_exists_flag,
SUM (st_init_cntrs) AS st_init_cntrs,
SUM (st_acc_num_cntr) AS st_acc_num_cntr,
SUM (st_reject_num_cntr) AS st_reject_num_cntr,
SUM (st_init_demand_weight) AS st_init_demand_weight,
SUM (st_acc_weight) AS st_acc_weight,
SUM (st_reject_wt) AS st_reject_wt,
SUM (st_init_demand_volume) AS st_init_demand_volume,
SUM (st_acc_volume) AS st_acc_volume,
SUM (st_reject_vol) AS st_reject_vol
FROM demand_results_v
GROUP BY ROLLUP (st_week, st_start_dt, st_end_dt, st_origin_group, st_origin,
st_destination_group, st_destination, st_contr_group,
st_init_rate,
rate,
st_revenue, st_route_exists_flag)
HAVING ( ( GROUPING (st_week)
+ GROUPING (st_start_dt)
+ GROUPING (st_end_dt)
+ GROUPING (st_origin_group)
+ GROUPING (st_origin)
+ GROUPING (st_destination_group)
+ GROUPING (st_destination)
+ GROUPING (st_contr_group)
+ GROUPING (st_init_rate)
+ GROUPING (rate)
+ GROUPING (st_revenue)
+ GROUPING (st_route_exists_flag) = 0
)
OR ( GROUPING (st_week) = 1
AND GROUPING (st_start_dt) = 1
AND GROUPING (st_end_dt) = 1
AND GROUPING (st_origin_group) = 1
AND GROUPING (st_origin) = 1
AND GROUPING (st_destination_group) = 1
AND GROUPING (st_destination) = 1
AND GROUPING (st_contr_group) = 1
AND GROUPING (st_init_rate) = 1
AND GROUPING (rate) = 1
AND GROUPING (st_revenue) = 1
AND GROUPING (st_route_exists_flag) = 1
)
)
ORDER BY st_week ASC,
st_start_dt ASC,
st_end_dt ASC,
st_origin_group ASC,
st_origin ASC,
st_destination_group ASC,
st_destination ASC,
st_contr_group ASC,
st_init_rate ASC,
rate ASC,
st_revenue ASC,
st_route_exists_flag ASC
so pls resolve this issue
ora-03001 Unimplemented feature

Thanks,

Report message to a moderator

Re: ora-03001 unimplemented feature [message #308063 is a reply to message #308062]

Thu, 20 March 2008 23:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Results 1 - 10 of about 1,070 for ora-03001
GOOGLE is your friend, but only when you use it

Report message to a moderator

Re: ora-03001 unimplemented feature [message #308071 is a reply to message #308062]

Fri, 21 March 2008 01:05

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
Sorry the above Query is Working fine in oracle9i but in oracle 10g it gives the following error
ORA-03001 unimplemented feature
but see the query when we comment the RATE column and i executed the script it gives me correct answer ,the query get result from the view DEMAND_RESULTS_VIEW in which the columns RATE and INIT_RATE are taken from the same column RATE from the base table DEMAND_FINAL, so pls look at this issue and give a proper explanation regarding this issue

Thanks,

Report message to a moderator

Re: ora-03001 unimplemented feature [message #308080 is a reply to message #308071]

Fri, 21 March 2008 01:33

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Copy and paste your session adding a query on v$version.
Post a test case we can reproduce: create table statement.

Regards
Michel

Report message to a moderator

Re: ora-03001 unimplemented feature [message #308092 is a reply to message #308080]

Fri, 21 March 2008 02:17

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
I have Attached below the View and Query Regarding that issue,its on oracle 10g the error follows ,so pls give me the correct solution as quick qs possible ,pls refer the above message also reg the column to be commented

Thanks,

Attachment: ERROR.TXT
(Size: 7.88KB, Downloaded 626 times)

Report message to a moderator

Re: ora-03001 unimplemented feature [message #308093 is a reply to message #308092]

Fri, 21 March 2008 02:26

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ah ah! It is a view and not a table, hiding information will just lead to inaccurate and wrong answer.
Now with what you posted I can't make any test as it is not complete, so you are on your own (YOYO).

Regards
Michel

[Updated on: Fri, 21 March 2008 02:26]

Report message to a moderator

Previous Topic:	Date format changes while fetching the record in a cursor
Next Topic:	Tablespace of IOT table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 20 07:32:08 CDT 2025