Xref: alice comp.databases.oracle.misc:34838
Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!uunet!nyc.uu.net!ffx.uu.net!nntphub.cb.lucent.com!news
From: Kenneth C Stahl <BluesSax@Unforgettable.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Help Altering table!!!
Date: Mon, 28 Jun 1999 15:44:52 -0400
Organization: Xyzzy Plugh Plover
Lines: 16
Message-ID: <3777D0B4.3F2CD407@Unforgettable.com>
References: <3777ca5b.6289483@news.alterdial.uu.net>
Reply-To: BluesSax@Unforgettable.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.51 [en] (Win95; U)
X-Accept-Language: en-US,en

Are you logged into the schema that owns the table? If not, try entering
the table name as
schema.table_name

Ken

Vic Millan wrote:

> This is the command I use to alter table:
>
> alter table prepayment modify (checkno number(10));
>
> I get error table or view does not exist.. Any idea????
>
> Vic