SELECT owner,table_name FROM dba_tables WHERE owner='SCOTT' AND table_name='EMP';If no rows are returned, the table was never created. Run the $ORACLE_HOME/sqlplus/demo/demobld.sql script to create the table.
If a row was returned, the table does exist and the account you used to query from this table does not have SELECT privileges on this table.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.