This content has been marked as final. Show 4 replies
You say 'obviously' but I pasted your script as is and executed it in the Worksheet with F5 and everything ran as expected.
Are you executing this script in some other fashion? If so, please add your detailed steps so we can reproduce.
In SQLPlus, this script will attempt to create everything twice, resulting in
for each line.
ORA-00955: name is already used by an existing object
If SQL Developer doesn't do this then its SQLPlus compatability is broken.
This is messy and undesirable for DDL statements, but will definitely result in the wrong behaviour if there are insert statements.
Agreed Jim. I went through this too quick...I even saw the object exists errors in SQL*Plus, so I should have known better. Will talk to the developer on Monday.
Oracle has determined that this is a bug (16263281). Will post again when the fix is available.