Re: Help Modify Table!!!

Vic Millan wrote on 28-Jun-99 20:20:52:
>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????

Well this can have many reasons:

• It's not a table, but a view.
• It's a synonym that points to a table or view named differently.
• It's some other strange thing that you cannot modify. ;-)

You should try the following:

select object_name,object_type,owner from all_objects where object_name='PREPAYMENT';

>Vic

Hope that helps,
Lothar

--
Neue Adresse ab 10.07.'99:

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |