Richard,

SQL>> show tables
CON>> ;
R> adresses company

R> coredata coredatacode

R> glassGroup glassMaterial

R> glasseSales ocsGlassGroup

R> ocsSupplier optician



SQL>> select * from optician;
R> Statement failed, SQLCODE = -204

R> Dynamic SQL Error
R> -SQL error code = -204
R> -Table unknown
R> -OPTICIAN
R> -At line 1, column 15.

you need to understand how delimited identifiers work.
In your case, change your query to

select * from "optician";

If you aren't willing to double quote everything, then don't
use delimited identifiers in the first place when defining metadata.
This may be more or less easy to accomplish depending on the tool you
are using. Some tools will delimit your identifiers by default.

Remember that if you don't use delimited identifiers your identifiers
become case-insensitive and are stored in UPPERCASE by the server.
Then you don't need to double quote them when querying the database.

Ciao
--
Nando mailto:nandod@...