'Import with pl/sql developer

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?



Solution 1:[1]

Two approaches come to mind:

  1. Open the file with SQL Developer and Execute it (select the appropriate connection if prompted)

  2. Open a connection, and in the SQL Worksheet:

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

Then Execute as a statement.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 MeyerRJ