Re: restructuring tables in Oracle Lite - trouble

There are two issues here; first, Oracle does not permit the types of structual changes you are attempting. Second, in the eyes of Oracle you are attempting operations that are not permitted -- even though the error messages seem confusing.

Oracle does not permit structural changes to tables because such changes could result in data corruption. Instead you are required to drop the table and then recreate it in the new format.

Jerry

Maxim Kulikovsky wrote:
>
> Hi,
>
> I'm using Personal Oracle Lite Rel. 2.3.1 installed on
> Windows 95 box and can't find a way to change the structure
> of any table in local database. I'm connecting to default
> database using Oracle Navigator or SQL Plus utility under
> OOT_SCH account. I can perform any data-access, data-
> manipulation operations; create new tables and drop existing
> tables; define new fields in tables. But I can't delete
> existing fields or change properties of them (such as:
> datatype, length, primary key, nulls), receiving
> error message: "access violation or syntax error".
> Seems it's cannot be access violation, because Oracle Lite
> doesn't supports security features.
>
> In same time I have no problem with changing structure of
> tables, located in remote Oracle 7.3 database.
>
> If anybody knows the reason of trouble with Oracle Lite,
> please respond (by mail, if possible).
>
> Thanks in advance.
>
> Max Kulikovsky
  Received on Sun Oct 12 1997 - 00:00:00 CDT