Home » Other » General » invalid sys object
invalid sys object [message #121146] Thu, 26 May 2005 08:14 Go to next message
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.
Re: invalid sys object [message #121167 is a reply to message #121146] Thu, 26 May 2005 10:57 Go to previous messageGo to next message
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';
Re: invalid sys object [message #121506 is a reply to message #121146] Mon, 30 May 2005 06:41 Go to previous messageGo to next message
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
Re: invalid sys object [message #122369 is a reply to message #121167] Mon, 06 June 2005 03:50 Go to previous messageGo to next message
George LAZAR
Messages: 7
Registered: March 2005
Location: Romania
Junior Member
I did Embarassed 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

Re: invalid sys object [message #122392 is a reply to message #122369] Mon, 06 June 2005 06:21 Go to previous messageGo to next message
George LAZAR
Messages: 7
Registered: March 2005
Location: Romania
Junior Member
The status of the Sys.dual table is N/A.
Re: invalid sys object [message #123267 is a reply to message #122392] Sat, 11 June 2005 01:15 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
run again catalog.sql & catproc.sql. Probably That should resolve the issue.
icon7.gif  Re: invalid sys object [message #123268 is a reply to message #123267] Sat, 11 June 2005 01:21 Go to previous message
George LAZAR
Messages: 7
Registered: March 2005
Location: Romania
Junior Member
Thank you.

Actually I have solved the issue.

I have deleted the table dual, recreated and it's running just fine.



Previous Topic: What is alternet of cursor
Next Topic: What is job profile(activity) of Oracle PL/SQL Developer (Backend Programmer)
Goto Forum:
  


Current Time: Fri Mar 29 04:31:35 CDT 2024