Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

export dmp file from apex.oracle.com - reg

613777Apr 15 2010 — edited Apr 19 2010
Recently 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2010
Added on Apr 15 2010
3 comments
1,377 views