'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:
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.
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 |