How to copy Oracle Apex Application with data?

I have Oracle Apex (Oracle Express 10g) installed on Linux server.
How do I copy all Apex applications to another Oracle Express 10g instance located on Windows Server 2003?

LVL 1
shlafrockAsked:
Who is Participating?
 
gatorvipCommented:
You can use either impdp/expdp (Oracle tools) or you can download an external application (like Oracle SQL Developer) that does exports among other things. One nice thing about SQL Dev is that you can administer APEX applications directly, including exporting/importing them.
0
 
gatorvipCommented:
You want to copy

a) the APEX applications?
- if so, just do Export from the workspace interface of the first server
- then do Import  from the workspace interface of the second server

b) the data
- this is more involved, as you would have to use the Oracle tools
- or, to export one table at a time, go to Utilities/Data Load/Unload in the workspace interface
0
 
shlafrockAuthor Commented:
I want to do both.
Is there a tool that can export all data and table structures into single sql file (like mysqldump)?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.