export dmp file from apex.oracle.com - reg
613777Apr 15 2010 — edited Apr 19 2010Recently i developed one application in the oracle test server itself using apex 3.2.1 . Generally whenever i want to port it from my laptop, i go to dos mode and use exp command for taking dmp file which will have data's are pooled also. I export application and creates sql file. Both these file will be taken to destination laptop, i go to dos mode and use imp command and all the tables will be loaded with data to the desired user. In apex, i just import application sql and after that i will be able to run the application.
But when i use the apex in the oracle site itself, i do not know how to go dos mode for using exp/imp command for generating .dmp file which is portable. In the SQL command if i give, using begin and end, it is not working. How to take the table along with constraints, data to another user and on some other database from apex.oracle.com login
thanks in advance