CODEWITHSUNDEEP
sqloracle-databaseoracle-sqldeveloper
Madhusudan
Madhusudan

Reputation: 4815

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

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?

Upvotes: 75

Views: 262534

Answers (3)

Bipil Raut
Bipil Raut

Reputation: 21

You can use Load function

Load TableName fullfilepath;

Upvotes: 0

Lalit Kumar B
Lalit Kumar B

Reputation: 49082

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

enter image description here

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

Upvotes: 147

Sandeep
Sandeep

Reputation: 806

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

Upvotes: 2

Related Questions