| PLS-00905: object DBADM.TABLE1@otherDB is invalid [message #59989] |
Thu, 08 January 2004 03:02 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
