Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Problem in Windows 2000

Status
Not open for further replies.

jcshepp

Technical User
Dec 31, 2002
8
GB
One of our sites runs Oracle 8.0.6 on a Win 2K server.

A few months ago , I created a Batch file with the following command , to take an export of the database.

exp80 system/manager@prod file=g:\exports\pimPexp.dmp log=g:\exports\pimPexp.log full=y

The batch job was scheduled for 9pm each night and has worked okay so far. Now the job no longer runs. Windows Scheduler says that the job is running, the next morning , but the export file and the logfile are both size 0 bytes.
The job will run okay if I double-click on it to run it manually.

The dmp file was just reached 2GB in size

Has anyone else ever experienced similar problems ?
 
8.0 has an export file limitation of 2GB - this is overcome in 8i

You need to compress the export on the fly as it is created - as I'm UNIX biased - you need to get a Windows expert to help or use Metalink

Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top