Q

Exporting a DB using Oracle Console

How can I export my DB using Oracle Console? It asked me to log in in management server mode but I cannot log in. I gave the server as my DB name and it told me that there is no such server.

I'd like to ask how I can export my DB using Oracle Console. It asked me to log in in management server mode but I cannot log in. I gave the server as my DB name and it told me that there is no such server. When I log in as SYS, it tells me that you have to log in as sys/admin.
I don't normally perform database exports via Enterprise Manager but I do know that you need to set the proper credentials for the server and your userid for export to work via EM. The most common methods of exporting data are export via the command line, export interactively or export using a parameter file. You can also export a remote database over Oracle Net.

To export via the command line, you would type in a command (from the UNIX or DOS prompt) that looks something like this:

 
exp system/manager full=y file=expdatORCL.dmp log=expdat.log compress=y rows=y

Note that you may use different parameters for your export so your command line export may look slightly different.

To export interactively, you simply type:

 
exp

at the command line and follow the prompts.

To use a parameter file, place the parameters that you would normally provide at the command line into a file called something like expORCL.par, and call it from the command line like this:

exp parfile=expORCL.par

One of those three trusted methods should work for you. If not, please submit another question with specific error messages and I will do my best to address them.

This was first published in August 2005

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close