Re: Sqlplus Alter question

Martin Meadows wrote:

> sql> describe payroll_transaction_master
> I get a nice listing of that table.
 

> alter table payroll_transaction_master add job_function integer
> ERROR at line 1:
> ORA-00942: table or view does not exist

Hello Martin,

I am not sure if payroll_transaction_master is a table. I rather think it is a view. But test:
select
  object_name,object_type,owner
from
  all_objects
where
  object_name = 'PAYROLL_TRANSACTION_MASTER' ;

The error message ORA-00942 arises if the table does not exist, although telling you that neither a table or a view with this name exists.

Stephan Schaefer
stesch_at_camline.com Received on Mon Mar 02 1998 - 00:00:00 CST