Re: HELP! Import Problem

From: Winnie Liu <poohland_at_hotmail.com>
Date: 1998/07/06
Message-ID: <6ns566$di6_at_sjx-ixn2.ix.netcom.com>#1/1


You are running out of tablespaces in LOCKBOX. Add more datafiles into the tablespace or resize your current datafiles. I guess that you may change the db_block_size or you have enlarge the initial or next extent for that tablespace/table (or the pctincrease parameter). That is why you will use up more space than before.

Winnie

>
>Export file created by EXPORT:V07.03.02 via conventional path
>. importing LB's objects into LB
> . importing table "AUTH_USER" 36 rows imported
> . importing table "AVAIL_RPT" 111 rows imported
> . importing table "AVAIL_RPT_DETAIL" 276 rows imported
> . importing table "BED" 1563 rows imported
> . importing table "CHARGES" 12769 rows imported
> . importing table "CTL_HEADER" 3777 rows imported
> . importing table "HEADER" 6575 rows imported
> . importing table "LBX_SERVICES" 31 rows imported
> . importing table "OUTPUT" 0 rows imported
>. . importing table "PAYMENT"
>IMP-00003: ORACLE error 1653 encountered
>ORA-01653: unable to extend table LB.PAYMENT by 1588 in tablespace LOCKBOX
>IMP-00018: partial import of previous table completed: 50635 rows imported
>
Received on Mon Jul 06 1998 - 00:00:00 CEST

Original text of this message