OraFAQ Forum: Reports & Discoverer » ORA-00942 Table or view does not exist

Home » Developer & Programmer » Reports & Discoverer » ORA-00942 Table or view does not exist

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

ORA-00942 Table or view does not exist [message #161137]

Thu, 02 March 2006 03:54

batsandall
Messages: 6
Registered: April 2005
Location: Geneva

Junior Member

Hi,

I have the message ORA-00942 when I add a condition to a report.
The condition is on one of the field displayed:
f_year >= TO_CHAR(TRUNC(SYSDATE),'YYYY')

The report is based on 2 folders, one is a view, the other one is a complex folder.

f_year is in the report (so it exists in the database)

What is the problem ?

Thanks for your answers

Report message to a moderator

Re: ORA-00942 Table or view does not exist [message #161139 is a reply to message #161137]

Thu, 02 March 2006 04:07

orausern
Messages: 826
Registered: December 2005

Senior Member

recheck for f_year.what are the tables being referenced in the report? post output of describe command for the tables used in the report and check in which table f_year is present.

[Updated on: Thu, 02 March 2006 04:08]

Report message to a moderator

Re: ORA-00942 Table or view does not exist [message #161195 is a reply to message #161139]

Thu, 02 March 2006 08:56

batsandall
Messages: 6
Registered: April 2005
Location: Geneva

Junior Member

The data from f_year is displayed in the report so the report access the table.

Report message to a moderator

Re: ORA-00942 Table or view does not exist [message #161607 is a reply to message #161195]

Mon, 06 March 2006 04:39

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Report was written earlier.
Now you want to add another condition.
Doing so, you received the ORA-00942 error.

Did you connect to the database BEFORE applying changes?

Report message to a moderator

Re: ORA-00942 Table or view does not exist [message #161608 is a reply to message #161607]

Mon, 06 March 2006 04:42

batsandall
Messages: 6
Registered: April 2005
Location: Geneva

Junior Member

Hi,

I don't fully understand the answer. the report was created before, yes. Before creating the condition, but the condition applies to a column already in the report (from the start), so the table does exist.

Report message to a moderator

Re: ORA-00942 Table or view does not exist [message #161620 is a reply to message #161608]

Mon, 06 March 2006 06:21

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What I meant was: did you connect to the proper schema before applying changes to the report query? You know, when the Report Builder is opened, you open the report and connect to the database (by pressing <Ctrl> + J, for example) and enter username, its password and database.

So I asked: did you provide correct logon credentials?

Did you, for example, wrote the report as 'scott/tiger@ora8' and now want to change the report using 'mike/lion@ora9'? Doing so would end with an ORA-00942.

Report message to a moderator

Re: ORA-00942 Table or view does not exist [message #161622 is a reply to message #161620]

Mon, 06 March 2006 06:29

batsandall
Messages: 6
Registered: April 2005
Location: Geneva

Junior Member

Sorry.
No I am using only one user and don't reconnect. I am using the user used in Discoverer admin.

Report message to a moderator

Previous Topic:	Patch 15
Next Topic:	reports background engine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 11:01:56 CDT 2024