Re: Help Modify Table!!!

Vic

Probably means the table is owned by someone else. If you have DBA privileges, check the view DBA_TABLES using:

select owner
from dba_tables
where table_name = 'PREPAYMENT'

If you don't have DBA privileges, check ALL_TABLES instead or get your DBA to check for you. Then either log on as the owner or change your statement to:

alter table owner.prepayment modify (checkno number(10));

If the latter works, shoot your DBA for giving you too many privileges!

HTH. Pete

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

--
Regards

Pete

Received on Mon Jun 28 1999 - 15:45:44 CDT