Import with pl/sql developer

Question

I have an sql file that contains user schema with all objects(tables, packages) which I get by export user objects in pl/sql developer. Now I need to import it to my database. How I can do it with pl/sql developer?

Possible duplicate of [PL/SQL developer import dump](https://stackoverflow.com/questions/6160097/pl-sql-developer-import-dump) — Dominique Fortin, Nov 19 '18 at 16:20

score 0 · Answer 1 · answered Oct 04 '13 at 18:52

0

Two approaches come to mind:

Open the file with SQL Developer and Execute it (select the appropriate connection if prompted)
Open a connection, and in the SQL Worksheet:

@"C:\Path\To\My Schema\import.sql"

Then Execute as a statement.

answered Oct 04 '13 at 18:52

MeyerRJ

792
4
8

SQL Developer as nothing to do with PL/SQL Developer. – Dominique Fortin Nov 19 '18 at 15:50

Import with pl/sql developer

1 Answers1