Your question is a little confusing because you state that when you import the data, you get errors, yet all of...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.continue reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.continue reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.