In SQL Developer, from the top menu choose Tools > Data Export. This launches the Data Export wizard.
So that is export. It creatres export.sql file. Now how to do import ? I am usgin SqlDeveloper 3.20.
Trygin to follow this tutorial , and have created new connection but I cannot find import. Tools->Preferences->Database->Utilities->Import Method and than what ?? I have tried to run script @C:\locationOfExportFile\export.sql
And I am getting eroors
SQL Error: ORA-00942: table or view does not exist 00942. 00000 - "table or view does not exist" *Cause:
BTW, I have no idea what am I doing i just want to get that database to localhost. Other computer and my computer both have Oracle 11g Express database. Schema name is the same!