I am using SQL Developer Export Wizard to get the data from tables in production db to a sql file to then export into development db. I exported the data into sql file in the form of INSERT statements but looks like the tables exported are not preceeded by schema name. How can I ensure wizard adds the schema?
Another thing is I have an issue running .sql scripts from SQL Developer.
I tried @"C:\Data\Prod\myscript.sql" and it looks like it is running but then no data shows up in the tables.
Can someone help?