A large DB import
Date: Sat, 5 Feb 1994 08:12:02 GMT
Message-ID: <CKqs42.Lvu_at_shakti.ncst.ernet.in>
The output of the above command was :
Import: Version 6.0.33.2.1 - Production on <date and time deleted>
Copyright (c) Oracle Corporation 1979, 1989. All rights reserved.
Connected to: ORACLE RDBMS V6.0.33.2.1, transaction processing option - Production PL/SQL V1.0.33.1.1 - Production
Export file created by EXPORT:V06.00.33
. importing XYZUSER's objects into XYZUSER
. . importing table "LARGE_TABLE"
IMP-00020: column (size 705) in export file too large for column buffer (size 22)
IMP-00028: partial import of previous table rollbacked: 491505 rows rollbacked
Import terminated successfully.
A Rollback Segment of initial 100M next 50M (in a tablespace with 2000M free was in use).
The table has NO long columns.
A description of the table is :
column_1 char(11) not null, column_2 char(6) not null, column_3 number(7,0) not null, column_4 number(12,0) , column_1 number(12,0) ) pctfree 5 pctused 95 tablespace large_tbs storage (initial 942080K next 40960K minextents 1 maxextents 999 pctincrease 0);The table actually has 22047804 rows
================================================================================
The file (which includes other tables exported) is of size 1926544384 bytes. This table is the first in the export file. There were no errors in the export.
The database data-tablespace and tablespace for rollback segment are on raw devices.
What is the cause ? Is it a known bug ? What action can be taken ? Received on Sat Feb 05 1994 - 09:12:02 CET