CREATE TABLE firmas
  (
     firmas_reg_nr VARCHAR2(15) constraint pk_freg primary key,
     firmas_nos    VARCHAR2(25) constraint nn_fnos NOT NULL,
     id_product    VARCHAR(15),
     constraint fs_fk_prid foreign key(id_product) references products (
     product_id) ON DELETE CASCADE
  )
CLUSTER klasteris1 (id_product)  

SQL> @firmas
SQL> DROP TABLE PRODUCTS;
DROP TABLE PRODUCTS
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> CREATE TABLE PRODUCTS
  2  (
  3  PRODUCT_ID VARCHAR2(15) CONSTRAINT PK_PRID PRIMARY KEY,
  4  PRODUCT_NOS VARCHAR2(30) CONSTRAINT NN_FPRO NOT NULL,
  5  PRODUCT_MASA NUMBER DEFAULT 0,
  6  PRODUCT_CENA NUMBER DEFAULT 0)
  7  /

Table created.

SQL> drop table firmas;
drop table firmas
           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> CREATE TABLE FIRMAS
  2  (FIRMAS_REG_NR VARCHAR2(15) CONSTRAINT PK_FREG PRIMARY KEY,
  3  FIRMAS_NOS VARCHAR2(25) CONSTRAINT NN_FNOS NOT NULL,
  4  ID_PRODUCT VARCHAR(15),
  5  CONSTRAINT FS_FK_PRID FOREIGN KEY(ID_PRODUCT) REFERENCES PRODUCTS (PRODUCT_ID)
  6  ON DELETE CASCADE)
  7  /

Table created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
bcm@bcm-laptop:~$ sqlldr user1/user1 control=firmas.ctl

SQL*Loader: Release 11.2.0.1.0 - Production on Fri Oct 15 16:21:04 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Commit point reached - logical record count 3
bcm@bcm-laptop:~$ cat firmas.ctl
LOAD DATA
INFILE 'firmas.txt'
INSERT INTO TABLE FIRMAS
FIELDS TERMINATED BY ","
(FIRMAS_REG_NR char,FIRMAS_NOS char,ID_PRODUCT char)