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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: