Re: Drop table

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 31 May 2006 04:22:03 -0700
Message-ID: <1149074523.010170.71880@u72g2000cwu.googlegroups.com>

Lasse schreef:

> Hi,
> I use Oracle Application Express and have made a mistake to use a swedish
> letter in the tabel name.
> How do I drop or rename the table?
> The tabelname is 'INKÖPARE_LOOKUP'
> I have tryed 'Drop table INKÖPARE_LOOKUP' but i get an error message
> 'invalid letter'
>

I wonder how you got it created in the first place: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> create table INKÖPARE (col1 varchar2(30)); create table INKÖPARE (col1 varchar2(30))

                *

FOUT in regel 1:
.ORA-00911: Ongeldig teken.

SQL> create table "INKÖPARE" (col1 varchar2(30)); Tabel is aangemaakt.

SQL> drop table "INKÖPARE";
Tabel is verwijderd.

Which is your solution: use double quotes on the table name -mind you, in that case the
table name is case sensitive! Received on Wed May 31 2006 - 06:22:03 CDT