How to run .sql file in Oracle SQL developer tool to import database?

Question

I have exported database from Oracle SQL developer tool into .sql file. Now I want to run this file which is of size 500+ MB.

I read about running scripts here, but I didn't understand the way. Is there any command or query by which we can run this sql script by providing path?

How did you export, using EXPDP? Is it a dump file or just a .sql file? — Lalit Kumar B
– Lalit Kumar B, Commented Jul 22, 2015 at 10:28

ROOT · Accepted Answer · 2020-04-15 06:03:46Z

150

You could execute the .sql file as a script in the SQL Developer worksheet. Either use the Run Script icon, or simply press F5.

For example,

@path\script.sql;

Remember, you need to put @ as shown above.

But, if you have exported the database using database export utility of SQL Developer, then you should use the Import utility. Follow the steps mentioned here Importing and Exporting using the Oracle SQL Developer 3.0

edited Apr 15, 2020 at 6:03

ROOT

11.7k5 gold badges35 silver badges49 bronze badges

answered Jul 22, 2015 at 10:32

Lalit Kumar B

49.5k13 gold badges104 silver badges131 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Madhusudan Over a year ago

where should I run this command? Because I can get query explorer screen after click on one of present db

Lalit Kumar B Over a year ago

@Rushikesh Open a SQL Worksheet and then do as I said above.

MDaniyal Over a year ago

I gave a 12GB .sql file of my whole database and the Oracle SQL Developer just Crashed :(

abarre Over a year ago

Thanks for the tip ! Works like a charm (example on Windows : @D:\Scripts\import.sql)

Jan Over a year ago

If you have spaces in your path use "..." for example: @"c:\temp\big path with spaces\sqltool - oracle.sql"

|

Sandeep · Accepted Answer · 2015-07-22 20:27:07Z

2

You need to Open the SQL Developer first and then click on File option and browse to the location where your .sql is placed. Once you are at the location where file is placed double click on it, this will get the file open in SQL Developer. Now select all of the content of file (CTRL + A) and press F9 key. Just make sure there is a commit statement at the end of the .sql script so that the changes are persisted in the database

answered Jul 22, 2015 at 20:27

Sandeep

8164 silver badges8 bronze badges

3 Comments

Tomor Over a year ago

Unfortunately, when the file is 500+ MB as asked in the question, the SQL developer will fail to open it.

M Granja Over a year ago

In my case, the file is 2.5MB, and SQL Developer fails to open it.

SkinnyPete63 Over a year ago

Lalit's answer is the correct one, just make sure you put sufficient commits in your script if it is a very long file. (Provided you are happy committing as you go!!!)

Bipil Raut · Accepted Answer · 2021-02-19 08:05:29Z

0

You can use Load function

Load TableName fullfilepath;

answered Feb 19, 2021 at 8:05

Bipil Raut

211 bronze badge

Collectives™ on Stack Overflow

How to run .sql file in Oracle SQL developer tool to import database?

3 Answers 3

9 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related