Home > IT Answers > Oracle > Full Export on Win 2000
Oconnra
0 pts.
 Full Export on Win 2000
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?

Software/Hardware used:
ASKED: May 12, 2004  5:08 PM
UPDATED: May 13, 2004  11:52 PM
RELATED QUESTIONS
Answer Wiki:
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
Last Wiki Answer Submitted:  May 13, 2004  10:54 am  by  Peasland   0 pts.
All Answer Wiki Contributors:  Peasland   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Oconnra
 0 pts.
 

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?

Smeagol
 0 pts.