I created a table in Oracle 7 from Microsoft Access using the ODBC driver. I can connect to the table remotely using Access and view records in the table. However, when I issue a select statement from SQL DBA Oracle says the table does not exist. I can do a 'select * from USER_TABLES' and I can see the table is there in a tablespace other than the user's default. Is it neccessary to qualify the tablespace name? Or is it possible that my database is corrupted and if so how do I correct it? Received on Mon Aug 01 1994 - 21:32:39 CEST
Original text of this message