Quote Originally Posted by notsirk View Post
Is that what this seems to be telling you? I didn't think that was it because when I used underscores instead of spaces I got a table "doesn't exist" message and with this I don't.
Please do not take it the wrong way but that rationale is like saying that you drained all the blood out of your patient so he/she would stop bleeding

Quote Originally Posted by notsirk View Post
The truth is, we are using a web based reporting system that has tools for building reports but they are quite limited so there is an option to put in "Custom SQL" code. The problem is, we have no idea what the table names or column names are (we don't have direct access to the Db) and I've had to guess based on the options in the report builder tools.

If that's what you think the problem is, I'll have to try to find a way to get that info but I was hoping it was something we could take care of on our end before going through the rigamarole of dealing with IT and the vendor... They suck!
Yes. I think the problem is that it is not easy to write a query if you know neither the name of the table nor the names of the columns. Once you get the table name, try to include the schema_name, fully qualifying it... that's most probably the reason why you got "table does not exist" error message, the alternatives are: 1) your user account has no privileges on the table and 2) the named table does not exist at all.

Looking forward, next steps are:
1- Get the right table names including schema name.
2- Be sure your account has privileges on such table/s
3- Log via sqlplus and do a "desc" of each table so to get a list of columns

Good luck.