Q

Export errors with Oracle 7 on SCO OpenServer

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. Please help us to find the solution.

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.

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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close