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

[dcseain.livejournal.com]

Sigh. It's back up, but nothing seems to be transmitting from the backend DB to the frontend system. I bet he broke table joins. Sigh.

[(Anonymous)]

Or possibly - after deleting the table and re-creating it, he didn't "grant all to public" so only the db admin account can access the table.

Is this Oracle, Sybase or something else entirely?

[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.