Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Sqlplus Alter question

Re: Sqlplus Alter question

From: <mpir_at_compuserve.com>
Date: 1998/03/04
Message-ID: <6djtk8$aev$1@nnrp1.dejanews.com>#1/1

In article <6decg7$2gce_at_soprox-in.bull.fr>,   "Hervé Patin" <herve.patin_at_bull.net> 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
>
>

Another possibility is that it is a synonym pointing to someone_else.payroll_transaction_master. In that case you need to know or be someone_else to alter the table.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 04 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US