Group file already exists

[Semitool]

Can someone please explain what causes this error:

OCA-30023: error fetching result set
[POL-3253] group file already exists


I am using Oracle 8 Lite. I have created a view that returns all records from a table with the related data from other tables. If the database is open in another application first, then I eventually get the group file error shown above. For the record, we use Windows NT/2000, our app is recording data, and we use Crystal Reports to view the data. I also get this error when I use SQL*Plus or Oracle 8 Navigator to open the view.

Thanks for any info.


************************

Here's the view definition:

create view EventViewEx
(EventIndex,LogDate,Tool,ModuleId,Module,Type,Event,StrDesc1,StrDesc2,StrDesc3,StrDesc4,IntDesc1,FptDesc1,UserName) as
select Event.EventIndex,
Event.EventDate,
Tool.ShopOrder,
Event.ModuleID,
Module.ModuleName,
Event.EventType,
Names.Name,
Event.EV_StrDesc1,
Event.EV_StrDesc2,
Event.EV_StrDesc3,
Event.EV_StrDesc4,
Event.EV_IntDesc1,
Event.EV_FptDesc1,
Users.UserName
from Event,
Names,
Module,
Tool,
Users
where Event.ToolIndex = Tool.ToolIndex
and Event.NameId = Names.NameId
and Event.ModuleId = Module.ModuleId
and Event.UserIndex = Users.UserIndex;

 

[ngibbs]

basically you are trying to create a view that already exists. You need to either give it a new name or replace it.
Try Create o replace view instead of create view.

 

[Semitool]

Let me clarify. I do not get the error when I create the view. I get the error when I use the view in a query (i.e., select * from eventviewex). Sorry for the confusion.

Thanks.

 

[karluk]

Please excuse the obvious question, but are you sure that Oracle lite supports views being used by two applications at once? Maybe the error means it can't be done.

 

[Semitool]

I only use views for all of the report queries, some with more tables in the view than this one, and all of them work fine except this one. Again, I do not initially get the error, but only over time as the database file grows. I'm not sure if it is related to size or some combination of data in the tables.