Oracle Database Discussions

Hello,

I installed Oracle 10 Express Edition. I would like to create tables and fields with lowercase letters. I try to create a table with the wizard, I choose respect lowercase / uppercase. But when the time comes to execute it to create the table several errors appear. So I tried to create the table in uppercase and there is no any problem. Here is the error:

Failed to create table "livres"
Creating table failed ORA-24344: successful operation with compilation error ORA-00942: Table or view not exist ORA-06510: PL / SQL exception defined by the user untreated

Here is the SQL code generated by the Wizard before being executed:

CREATE TABLE "livres" (
"id" NUMBER NOT NULL,
"genre_id" NUMBER NOT NULL,
"auteur_id" NUMBER NOT NULL,
"titre" VARCHAR2(4000) NOT NULL,
"date_parution" DATE NOT NULL,
constraint "livres_PK" PRIMARY KEY ("id")
)
/

CREATE sequence "LIVRES_SEQ"
/

CREATE TRIGGER "BI_livres"
before INSERT ON "livres"
FOR each row
begin
SELECT "LIVRES_SEQ".NEXTVAL INTO :NEW.id FROM dual;
end;
/


I surveyed the net for hours and I found nothing that could help me.

I thank you in advance for your help and i'm sorry for the translation (french => english, thanks google^^).