Having trouble running .sql file from SQL Developer
I have a file with thousands of insert statements (importing data from another database) and trying to run it all at once in SQL Developer.
I tried
@C:\Data\Prod\myscript.sql;
commit
I highlight it and click Run but does not seem like anything is happening.
I also tried opening the sql file in SQL Developer and running it via "Run Script" (F5) but still nothing happens. One time it looked like it was running this way - the bar appeared but then it ran for over an hour but no records got inserted. No error message. Can someone please help me diagnose the problem?
0