I have started an export of a DB via SQL Dev Version 3.0.04
At first this was a single file, but when the file got to a size that I could not burn to media to restarted it using the multiple files option
This export is of all objects and all rows for one schema including dependancies
My questions are;
- how to import the database schema using SQL Dev?
only see how to import data into an existing table, not an entire schema of new objects
- using multi file option it looks like it is creating a .sql file for each object, how does it know the order to import these objects again due to dependancies?
Unfort I am not able to connect directly to the server to run exp or expdp as I normally would so hitting a few snags w/ this tool. I can however if needed connect to the destination server to run imp or impdp