Re: Oracle Lite Alter Table error
Date: Mon, 21 Sep 2015 22:46:45 -0700 (PDT)
Message-ID: <d50fc3d9-4b65-4185-bfe6-fd6257e3d738_at_googlegroups.com>
On Wednesday, December 9, 1998 at 1:30:00 PM UTC+5:30, dme..._at_metasolv.com wrote:
> Has anyone else had trouble with ALTER TABLE on Oracle Lite? I don't think
> it's my typing because I get the same syntax error in Oracle 8 Navigator when
> trying to modify a table using the designer. Here's the example:
>
> Oracle Open Client Adapter for ODBC 6.0.5.1.0
> Oracle Lite ORDBMS 3.5.0.1.0
>
> SQL> create table test1 ( a char(1) );
>
> Table created.
>
> SQL> alter table test1 modify ( a varchar(10) );
> alter table test1 modify ( a varchar(10) )
> *
> ERROR at line 1:
> OCA-30021: error preparing/executing SQL statement
> [POL-5228] syntax error
>
>
> SQL> desc test1
> Name Null? Type
> ------------------------------- -------- ----
> A CHAR(1)
>
> SQL> drop table test1;
>
> Table dropped.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
On Wednesday, December 9, 1998 at 1:30:00 PM UTC+5:30, dme..._at_metasolv.com wrote:
> Has anyone else had trouble with ALTER TABLE on Oracle Lite? I don't think
> it's my typing because I get the same syntax error in Oracle 8 Navigator when
> trying to modify a table using the designer. Here's the example:
>
> Oracle Open Client Adapter for ODBC 6.0.5.1.0
> Oracle Lite ORDBMS 3.5.0.1.0
>
> SQL> create table test1 ( a char(1) );
>
> Table created.
>
> SQL> alter table test1 modify ( a varchar(10) );
> alter table test1 modify ( a varchar(10) )
> *
> ERROR at line 1:
> OCA-30021: error preparing/executing SQL statement
> [POL-5228] syntax error
>
>
> SQL> desc test1
> Name Null? Type
> ------------------------------- -------- ----
> A CHAR(1)
>
> SQL> drop table test1;
>
> Table dropped.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
On Wednesday, December 9, 1998 at 1:30:00 PM UTC+5:30, dme..._at_metasolv.com wrote:
> Has anyone else had trouble with ALTER TABLE on Oracle Lite? I don't think
> it's my typing because I get the same syntax error in Oracle 8 Navigator when
> trying to modify a table using the designer. Here's the example:
>
> Oracle Open Client Adapter for ODBC 6.0.5.1.0
> Oracle Lite ORDBMS 3.5.0.1.0
>
> SQL> create table test1 ( a char(1) );
>
> Table created.
>
> SQL> alter table test1 modify ( a varchar(10) );
> alter table test1 modify ( a varchar(10) )
> *
> ERROR at line 1:
> OCA-30021: error preparing/executing SQL statement
> [POL-5228] syntax error
>
>
> SQL> desc test1
> Name Null? Type
> ------------------------------- -------- ----
> A CHAR(1)
>
> SQL> drop table test1;
>
> Table dropped.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
On Wednesday, December 9, 1998 at 1:30:00 PM UTC+5:30, dme..._at_metasolv.com wrote:
> Has anyone else had trouble with ALTER TABLE on Oracle Lite? I don't think
> it's my typing because I get the same syntax error in Oracle 8 Navigator when
> trying to modify a table using the designer. Here's the example:
>
> Oracle Open Client Adapter for ODBC 6.0.5.1.0
> Oracle Lite ORDBMS 3.5.0.1.0
>
> SQL> create table test1 ( a char(1) );
>
> Table created.
>
> SQL> alter table test1 modify ( a varchar(10) );
> alter table test1 modify ( a varchar(10) )
> *
> ERROR at line 1:
> OCA-30021: error preparing/executing SQL statement
> [POL-5228] syntax error
>
>
> SQL> desc test1
> Name Null? Type
> ------------------------------- -------- ----
> A CHAR(1)
>
> SQL> drop table test1;
>
> Table dropped.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Even for altering a table or creating a table the same error persists. Did you guys found some solution for this.... If found, please share me too... Received on Tue Sep 22 2015 - 07:46:45 CEST