Forum Stats

  • 3,740,456 Users
  • 2,248,256 Discussions
  • 7,861,252 Comments

Discussions

SQLDeveloper - slow execution of large script

user7425388
user7425388 Member Posts: 1 Green Ribbon
edited Mar 26, 2021 1:39PM in SQL Developer

Hello,

I've quite large SQL script (~11MB) which creates database objects (tables, procedures, functions)

Because script is automatically generated all procedures and function in script are created in alphabetalical order. That's why during script execution I have a lot compiler errors which is totally ok, since at the end of the script I compile all database objects.

Problem is that creation of each procedure/function in SQLDeveloper takes around 5-10 second for each procedure. I think problem is related to fact that SQLDeveloper shows me details of compilation error which I don't need at these time.



Function DPsp_EvalSl compiled


LINE/COL ERROR

----------------------------------------------

21/15 PL/SQL: ORA-00904: "DPsp_Val": invalid identifier

23/17 PL/SQL: ORA-00904: "DPsp_WalSopA": invalid identifier

Errors: check compiler log.

Is there any option in SQLDeveloper to turn off detailed compiler log and speed up execution process a little ?

Regards

Answers

Sign In or Register to comment.