Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sqlplus Alter question
Hervé Patin wrote:
>
> L'objet sur lequel tu travaille est peut- etre une vue?
> il faut vérifier dans le dictionnaire (vue dba_segments) quel est le type
> d'objet.
> Si c'est une vue, il faut trouver le nom de la table pour pouvoir la
> modifier.
>
> BYE
>
> Martin Meadows a écrit dans le message <34F9F42B.63F8_at_indy.net>...
> >Hi.
> >
> >I'm working in a database that has a table called
> >payroll_transaction_master. When I use
> >sql> describe payroll_transaction_master
> >I get a nice listing of that table.
> >
> >When I attempt the following
> >SQL> alter table payroll_transaction_master add job_function integer;
> >I get
> >
> >alter table payroll_transaction_master add job_function integer
> >*
> >ERROR at line 1:
> >ORA-00942: table or view does not exist
> >
> >Have I entered the command incorrectly? Hope this isn't too trivial. I'm
> >an Oracle newbie.
> >
> >Thanks,
> >Martin Meadows
Sorry Herve' but I don't understand French when I read it. Wish I did. Thanks for the thought ... I think. Received on Mon Mar 02 1998 - 00:00:00 CST