CODEWITHSUNDEEP
sqloracle-databaseoracle11gcrash
maryo
maryo

Reputation: 23

(PL/SQL) Crash when I create a new database

I have a problem with PL/SQL (64bit).

I have a work to do for my school and they give us a data base pre-created, but the problem is that when I'm running the Database that they give to us, PL/SQL crash !

This is because the Database have 8'897 lines.. and I don't know how can I run the script without this bug. When I'm running the script line by line it's working, or if I run block by block (of 500 lines) it's working, otherwise I can't run the full script in once.

The problem is not the script ! It's working on school computer or my gaming computer, but not on my Laptop (i7, 8ram, ssd, etc... a good computer).

Is there any option that I can activate to fix this ?

Upvotes: 0

Views: 215

Answers (2)

maryo
maryo

Reputation: 23

I found who to fix the problem on my Laptop, thank you everyone.

I just re-installed the older version of PL/SQL that I used before the update and when I launch the script, I don't touch any window of the computer, I juste waiting about 3 - 4 minutes (even if Windows say that "PL/SQL stopped responding") and then, it's just work fine.

Upvotes: 0

GMB
GMB

Reputation: 222632

The problem is with your PL/SQL Developer tool, not with your SQL script. It works fine on school computer but crashes on your laptop.

Options :

  • split the SQL script in several, smaller parts, and execute them one by one (like : 8 x 1000 insert commands instead of 1 x 8000 insert commands)

  • use another tool to run your script ; SQLDeveloper may be a good alternative (it’s free and works fine on Windows)

Upvotes: 1

Related Questions