restructuring tables in Oracle Lite - trouble

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 Fri Oct 03 1997 - 00:00:00 CDT