Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am beginner in Oracle 11g. I have created a database in oracle 11g(Application Express).

I want to export this database with all data(whole workspace) and import this to another computer where I already have installed Oracle.Is there any way to export-import the whole workspace in oracle 11g application express?

share|improve this question

You have lots of different options for doing this:

http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/impexp.htm

I would recommend using Oracle Datapump as this is the most powerful solution, and would represent the best opportunity for instruction on how this is done in an enterprise environment.

share|improve this answer
  1. exp username/password@database name file=path (where you want to store the dump file)
  2. exp username/password@database name file=path (where you want to store the dump file )statics=none
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.