Menu
I have .sql file. I need to import that to oracle 11g. .sql file contains ddl queries for all tables. How can i import .sql file to oracle 11g. I have sqldeveloper tool.
Thanks in Advance.
615
Open SQL Server Management Studio. Connect to an instance of the SQL Server Database Engine or localhost. Expand Databases, right-click a database (test in the example below), point to Tasks, and click Import Flat File above Import Data.
From SQL Developer or Toad
Open --> File --> /locationofyourfile/yourfile.sql.
Once you have the file opened in SQL Developer or Toad,
execute by F5
From SQLPlus
@/locationofyourfile/yourfile.sql
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
