Database Software

I created relational data model using Oracle SQL Developer Data Modeler. I can export this model to DDL File (File->Export->DDL File and save to fileName.sql) but I don't know how to import this file to Oracle 10g Express and creat the schema.
In main menu I try to use SQL->SQL Scripts->Import but always after refering fileName.sql there is a message "Your export file is not supported." Whatever what type of encoding is set.

I tried to copy text from fileName.sql and pase to SQL->SQL Commands->Enter Commands, but I think that it is not a best way to creat a schema. Apart from that, there is a message ORA-00911: invalid character.

Second question. Is it possible in Oracle Data Modeler to creat primary keys and sequences like it is in GUI of Oracle 10g Express? In Oracle when I creat promary key I can select "Populated from a new sequence", "Populated from an existing sequence" or "Not populated" what is nice. In Oracle Data Modeler I must creat primary key and apart sequence... and in some way I must connect them.

Edited by: user12076978 on 2009-10-28 06:53