Aiming4theFoot
Active Member
I recently did a data refresh from production to development. In the midst of everything, I accidentally deleted the DEVCTL tablespace datafile. I recreated the file through Oracle Enterprise Manager and imported the data from production. Now when you login on to the FAT client, no menus show up at all. You can open applications via fast path, but you get an error dialog that says: Call to JDB_SelectKeyed failed. In the client jde log I get messages like this:
3200/2848 Wed Jul 11 18:41:45 2007 dbcolind.c133
OCI0000017 - Unable to execute statement for describe - SELECT * FROM DEVDTA.F7306 WHERE ( VQSY = :KEY1 )
3200/2848 Wed Jul 11 18:41:45 2007 dbcolind.c140
OCI0000018 - Error - ORA-00942: table or view does not exist
I am able to access these tables on the same client and on the Enterprise server via SQLPlus w/ NO problem at all. I checked the alert log on the Oracle server and there arent any funny messages there. The only way I can reproduce these errors in SQLPlus is to login to another database instance. Any ideas?
3200/2848 Wed Jul 11 18:41:45 2007 dbcolind.c133
OCI0000017 - Unable to execute statement for describe - SELECT * FROM DEVDTA.F7306 WHERE ( VQSY = :KEY1 )
3200/2848 Wed Jul 11 18:41:45 2007 dbcolind.c140
OCI0000018 - Error - ORA-00942: table or view does not exist
I am able to access these tables on the same client and on the Enterprise server via SQLPlus w/ NO problem at all. I checked the alert log on the Oracle server and there arent any funny messages there. The only way I can reproduce these errors in SQLPlus is to login to another database instance. Any ideas?