| PLS-00905: object DBADM.TABLE1@otherDB is invalid [message #59991] |
Thu, 08 January 2004 04:31  |
Mimosa
Messages: 3
Registered: January 2004
|
Junior Member |
|
|
Hello,
May be somebody could help me?
After one of table1's partitions was dropped, it's not possible to execute any blocks on it through SQL*Net.
Same SQL request from sql*plus prompt works perfectly.
Table and it's indexes are valid. What should I check?
Here is error message:
-------------------------------------------------------Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.1 - Production
With the Partitioning option
JServer Release 8.1.7.2.1 - Production
from table1@otherDB
*
ERROR at line 46:
ORA-06550: line 46, column 7:
PLS-00905: object DBADM.TABLE1@otherDB is invalid
ORA-06550: line 19, column 2:
PL/SQL: SQL Statement ignored
|
|
|
|
| Re: PLS-00905: object DBADM.TABLE1@otherDB is invalid [message #59997 is a reply to message #59991] |
Thu, 08 January 2004 12:15  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi there,
I just tried dropping a partition and selecting it through sqlNet (DBLINK) and didnt have any issues(I am on 9.2 though). I dont have a 8.1.7.2.1 database to reproduce this exactly.
Are you executing through sql or Pl/SQL ( I tried both) ? Did you drop the partition while the query is executing ? Did you check metalink for bugs ?
-Thiru
|
|
|
|
| Re: PLS-00905: object DBADM.TABLE1@otherDB is invalid [message #60006 is a reply to message #59997] |
Thu, 08 January 2004 23:44 |
Mimosa
Messages: 3
Registered: January 2004
|
Junior Member |
|
|
Hi Thiru and everyone who reads this!
I performed this operation (dropping of partition with local indexes) many times previously without any problems.
But now it's really something strange. I'll try to decsribe more detailed what I have now, may be somebody could have any ideas.
for example, such pl/sql block:
declare
cc number;
begin
select count(1) into cc from table1 where rownum<2;
end;
is processed successfully from otherDB.
BUT, when I run same from currentDB through dblink, I get as following:
----------------------------------------------------
SQL> declare
2 cc number;
3 begin
4 select count(1) into cc from table1@otherDB where rownum<2;
5 end;
6 /
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [[17069]], [[185376160]], [[]], [[]], [[]],
[[]], [[]], [[]]
SQL> select count(1) from table1@otherDB where rownum<2;
COUNT(1)
----------
1
SQL>
------------------------------------------------------
So, current error looks yet more serious than previous "invalid object" :(
My experianced colleague considers old session locks in otherDB's library cash.
What can be done to get rid of old sessions, except restarting DB? We have online DB... I've restarted all running processes and client programs, but it doesn't help.
I didn't checked Metalink yet, but going to do it now...
/M
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
