Re: Sqlplus Alter question

Stephan Schaefer wrote:
>
> 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

Thanks for the response Stephan,

A couple newsgroup members sent private responses & seem to be in complete agreement with you. I'll test out your select statement.

Thanks again,
Martin Meadows Received on Mon Mar 02 1998 - 00:00:00 CST