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
Join the conversationComment
Share
Comments
Results
Contribute to the conversation