OraFAQ Forum: General » invalid sys object

Home » Other » General » invalid sys object

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

invalid sys object [message #121146]

Thu, 26 May 2005 08:14

George LAZAR
Messages: 7
Registered: March 2005
Location: Romania

Junior Member

hello

My server is Oracle 7.2.2
I have a package I can't recompile. The error message is invalid object sys.dual

I can select from dual, but i can't create any procedure using select ... from dual.

Any ideeas.

thank you.

Report message to a moderator

Re: invalid sys object [message #121167 is a reply to message #121146]

Thu, 26 May 2005 10:57

andrew again
Messages: 2577
Registered: March 2000

Senior Member

That doesn't sound right. After you create the package or re-compile it ans "show errors". What is the exact message?

Try:
select * from dba_objects where status = 'INVALID';

Report message to a moderator

Re: invalid sys object [message #121506 is a reply to message #121146]

Mon, 30 May 2005 06:41

Maaher
Messages: 7065
Registered: December 2001

Senior Member

George LAZAR wrote on Thu, 26 May 2005 15:14

My server is Oracle 7.2.2

This doesn't sound right either...

I hope it's no production box.

MHE

Report message to a moderator

Re: invalid sys object [message #122369 is a reply to message #121167]

Mon, 06 June 2005 03:50

George LAZAR
Messages: 7
Registered: March 2005
Location: Romania

Junior Member

I did

and the table DUAL is not in the list.

Can I delete and recreate the DUAL table and then recompile all the objects?

The error message is "object sys.dual is invalid"

[Updated on: Mon, 06 June 2005 03:51]

Report message to a moderator