Using Oracle SQL Developer, I want to export databases to SQL scripts using the "Tools" > "Database Export" menu entry. I selected all the DDL entry to export. The problem now is the SQL file generated will have sections in order like DROP TABLE/VIEW, CREATE VIEW, CREATE TABLE, INSERT DATA.
It does not make sense to CREATE VIEW from table that has not been created yet. Is there any explanation for this? I did try to import the exported database from the dump file and it won't work.
Any help will be appreciated.