| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Serious import problem (help!)
Folks,
I've been exporting data from the production db's every night for over a year. We use these exports to import into the test db's that we have setup in the office. Well, starting yesterday I am no longer able to import successfully into any of our 8.1.6 instances.
The exp/imp are being done with the same version (Export file created by EXPORT:V08.01.06 via conventional path, Import: Release 8.1.6.0.0 - Production on Thu Apr 25 14:19:59 2000) and we have not upgraded Oracle (production or test) ever since it's been installed. Our exp files are around 5GB (on NTFS filesystem) when exported, I then gzip (switching to bzip2 soon) the files and ftp them off for unzipping and importing into another 8.1.6 w2k server. The thing that dazzles me is that nothing has changed except that we moved into a new office (new IP address space) this week. Were using WINS to resolve machine names (eg oradb2) and that's working fine (always has).
75% of the tables in Schema A load up fine, the other 25% in Schema A are random but seem to be breaking on the largest tables.
These are the import errors I get on multiple instances and different DB machines, very strange.
imp.exe system/%pass%@%dbname% FILE=%dmpfile% BUFFER=20000000 COMMIT=Y LOG=import.log IGNORE=Y FROMUSER=%owners% TOUSER=%owners%
. . importing table "CUSTOMER"
IMP-00058: ORACLE error 3125 encountered ORA-03125: client-server protocol violation IMP-00018: partial import of previous table completed: 3718 rows importedORA-01461: can bind a LONG value only for insert into a LONG column IMP-00018: partial import of previous table completed: 212793 rows imported
. . importing table "ACCOUNT"
IMP-00058: ORACLE error 1461 encountered
. . importing table "AGING_LDC_TMP"
IMP-00058: ORACLE error 3106 encountered ORA-03106: fatal two-task communication protocol error IMP-00018: partial import of previous table completed: 264180 rows importedORA-01461: can bind a LONG value only for insert into a LONG column IMP-00018: partial import of previous table completed: 723328 rows imported
. . importing table "BATCH_LOG"
IMP-00058: ORACLE error 1461 encountered
Any help would be appreciated!
Ben.
This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited. If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at ops_at_uspowersolutions.com and destroy all copies of this communication and any attachments.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conrad, Ben INET: BConrad_at_uspowersolutions.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Apr 25 2002 - 14:32:46 CDT
 |
 |