Error: Failure 3807 Object 'interfacedfcst' does not exist.

Database

Error: Failure 3807 Object 'interfacedfcst' does not exist.

Hi,

I am trying to select few rows from the table INTERFACEDFCST in Teradatabase.

This is the select query

select * from interfacedfcst;

I am getting the below error

*** Failure 3807 Object 'interfacedfcst' does not exist.
Statement# 1, Info =0
*** Total elapsed time was 1 second.

Can anyone provide me the reason and the solution for the same.
2 REPLIES
Enthusiast

Re: Error: Failure 3807 Object 'interfacedfcst' does not exist.

hope the object itself does not exist
Enthusiast

Re: Error: Failure 3807 Object 'interfacedfcst' does not exist.

try qualifying the tablename with the databasename.Probably the table you are refering to does not exist in the default database that you are currently in.