Gah!

[dcseain]

IF the bloody page ever comes up, i can unlock the record and go home, seeing as even once i get the data i need, i can't fix it because the DB table still has not reappeared. If i can't change the P to a U in the missing table, it'l all for nought. Sigh. I will get to go home soonish. I hope.

Comments

[ksatyr.livejournal.com]

Hmm, that anonymous post was from me.

[dcseain.livejournal.com]

I figured. I can see the table, both through TOAD and through SQL*PLus. I've updated the table in question. It's just not transmitting after commit to the frontend. It's Oracle 9i.

[ksatyr.livejournal.com]

All I can suggest is to issue from SQL*Plus (the most annoying tool I've ever come across, by the way) the following two lines:

grant all on TABLENAME to public;

and then

create public synonym TABLENAME for username.COMM_CHANNEL_DEF;

Where username is whatever user the front end logs to the database as.