Hi all,
I'm having some trouble doing a simply export than import of a schema (data + structure, tables, sequences, triggers, indexes) from 10g XE to a same version server on another machine.
I follow different ways:
1) Export from "script sql" both as file as sql commands. Trying to import I get this error:
Not found
The requested URL /apex/f was not found on this server
2) (traduction from italy language sorry if it is not exact in english) Loading/Downloading data -> Download -> I tryed both file and xml format. In this case I must select one table a time... but only the structure is exported, no data... fortunately I have only 3 table to export, but if I got many tables?
In short, which is the best practice to export schema with inside data from a server to another with same version??
Thankyou