Full Export on Win 2000

pts.
Tags:
Oracle 9i
Windows 2000 Server
I have spent most of my DBA life on HP/UX. I just recently installed an App on Win 2000 and was able to easily set up schema exports, but I can't get the full database export to work. I am running it as SYSTEM and made sure that SYSTEM has the DBA role as well as EXP_FULL_DATABASE. Has anyone else run it this?

Answer Wiki

Thanks. We'll let you know when a new response is added.

What syntax are you using? What error messages are you getting? We need more information.

I am currently doing a full export on one of my databases. The syntax I am using is as follows:

exp userid=system file=sid_full.dmp log=sid_log.dmp full=y

HTH,
Brian

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • Oconnra
    My syntax is: exp sys/arcdbms@dbms file=c:flsbackupSunday.dmp full=y log=c:flsbackupSunday.log I'm not getting an error, the export just hangs when it gets to: exporting object type definitions. I went back and recompiled all of the invalid sys procedures per a private reply, but that didn't fix the export.
    0 pointsBadges:
    report
  • Smeagol
    This may be very basic, but: have you looked on Metalink? For instance, note 151188.1 refers to exp hanging if the JAVA_POOL is too small, and as you're having problems with a recent installation, I wonder if that's worth checking?
    0 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following