Home » SQL & PL/SQL » SQL & PL/SQL » ora-03001 unimplemented feature (toad 9.1 ,oracle 9i)
ora-03001 unimplemented feature [message #308062] Thu, 20 March 2008 23:50 Go to next message
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,
Re: ora-03001 unimplemented feature [message #308063 is a reply to message #308062] Thu, 20 March 2008 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 25036
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
Re: ora-03001 unimplemented feature [message #308071 is a reply to message #308062] Fri, 21 March 2008 01:05 Go to previous messageGo to next message
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,
Re: ora-03001 unimplemented feature [message #308080 is a reply to message #308071] Fri, 21 March 2008 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ora-03001 unimplemented feature [message #308092 is a reply to message #308080] Fri, 21 March 2008 02:17 Go to previous messageGo to next message
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 230 times)
Re: ora-03001 unimplemented feature [message #308093 is a reply to message #308092] Fri, 21 March 2008 02:26 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Sun Dec 04 18:54:16 CST 2016

Total time taken to generate the page: 0.04322 seconds