Home -> Usenet -> comp.databases.oracle -> A Large DB Import Problem

A Large DB Import Problem

From: STOCKHOLDING CORPORATION OF INDIA LTD. <hemant_at_shakti.ncst.ernet.in>
Date: Sat, 5 Feb 1994 08:13:17 GMT
Message-ID: <CKqs66.LzF_at_shakti.ncst.ernet.in> 






While recreating an Oracle 6.0.33 Database on DG/UX 5.4.2






We tried importing a large table with the following import command : 





impst system/manager fromuser=XYZUSER touser=XYZUSER \
buffer=40960000 file=LARGE_EXPORT_FILE grants=N \
ignore=N tables=LARGE_TABLE indexes=N rows=Y 






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:13:17 CET












Original text of this message