Database Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Help In Export Database

747754Apr 4 2010 — edited Apr 5 2010

Hello All

I just finished developing my application using oracle application express (APEX) in order to upload it online as a web site. I have some problems in moving the database from my machine to the server. I'm not familiar with DBA task like export the database. I'm using Oracle database 11G release1 my schema contain the following:

50 Tables
1 Package
5 Procedures
10 Sequences
5 Functions
33 Mining Models (Oracle database Objects)

I need to export this schema as a dmp file and re import it in the server. I tried to use (exp) and (expdp) commands but I keep getting Unknown Command error but without any error number. I just hope if somebody can give me some instruction about how to export my database and what documents should I read. I know some DBA tasks like create user and directory and I have used DBMS_DATA_MINING.EXPORT_MODEL and DBMS_DATA_MINING.IMPORT_MODEL with my data mining objects but I have not export and import a complete database before.

Thanks in advance for the help

AL