Q
Problem solve Get help with specific problems with your technologies, process and projects.

Can't run select on table

When I run the query 'select * from scott.emp;' it shows an error that no tables or views are present.

I have a problem in running scripts. After creating the database, when I run the script to view tables and views of another schema, when I run the query 'select * from scott.emp;' it shows an error that no tables or views are present. Please help me. This has never happened before and I don't know what's the problem.
First, verify that the table actually exists. Sign on to the database as SYSTEM and issue the following:
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close