We have Oracle 7 on SCO OpenServer 5.0.5. We export data in full exp system/manager and the other options are default. But when we import this data we have too many errors, such as "exp-00015: error on row 87993 of table F_MD_ADDRESSES, column Street, data type 1"; "exp-00222 system error message 2"; "exp: 00002 error in writing to export file"; "exp: 00001 export terminated unsuccesfully." The .dmp size is 2147483136. f_md_addresses is the table name. Please help us to find the solution.

    Requires Free Membership to View

Your question is a little confusing because you state that when you import the data, you get errors, yet all of the error messages are export errors! So I'm going to assume that the error messages are correct and you are getting these when exporting.

Your dump file has reached a 2GB file size limit. Once it hits this limit, the export utility cannot write to the file any more and you get the EXP-00002 error. If you upgrade to a newer version of Oracle, the export utilities can handle much larger dump files. Otherwise, you can use a workaround.

The workaround uses a pipe you create in the file system. The exp utility writes to the pipe, which is never more than a few kilobytes in size. You need another utility to pull data from the pipe and most use the gzip utility for this. First, make a pipe in your file system:

mknod exp.pipe p

The pipe can be seen as a file in your file system with the name "exp.pipe." Next, you'll have to start gzip to read from the pipe and export to dump to the pipe as follows:

gzip < exp.pipe > my_dump.dmp.gz &
exp userid=system full=y file=exp.pipe

To import, you need to unzip the file into the pipe and have the imp utility read from the pipe as follows:

gunzip < my_dump.dmp.gz > exp.pipe &
imp userid=system full=y file=exp.pipe

This was first published in June 2006

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: