thatJeffSmith-Oracle Hi Jeff, I marked the parts where the CREATE TABLE and ALTER TABLE are in red
I don't know why but the whole export forgets to add semicolon at the end of the statments (even with the correct option activiated in the export options for it).
I tried different options and different tables but everytime it's the same result it doesn't export everything in the same order you have there instead it first exports the primary unique index, then wants to add the primary key and after that the CREATE TABLE is exported. And it also forgets the semicolon everytime. I really don't understand what the problem is, I even reinstalled SQL Developer without using any old settings just to be sure, same problem.
ok after reinstalling it 2 more times and deleting every file that could be even close to related to SQL Developer it finally works... I have no idea what the problem was, I didn't change any settings expect for the ones in the export window.