Please Help: Storage problems

From: sirirut vanichayobon <svanicha_at_cs.ou.edu>
Date: Thu, 18 Feb 1999 14:59:12 -0600
Message-ID: <36CC7F20.4292FAF0_at_cs.ou.edu>

Hi,

  I have Oracle 8 on Unix V4.0 alpha.
  I used SQL* Loader to load data into database. The following are the error that I got when I tried to load the data.

     ORA-01653: unable to extend table MESO.MES05A by 311072 in tablespace MESODATA_1

     SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.

  At first, my storage parameters were the following:

• INITIAL EXTENT = 20480 bytes
• NEXT EXTENT = 20480 bytes
• MIN EXTENT = 1
• MAX EXTENT = 249
• PCTINCREASE = 50

 Then I changed to the following but I still got the same errors.

• INITIAL EXTENT = 20480 bytes
• NEXT EXTENT = 20480 bytes
• MIN EXTENT = 1
• MAX EXTENT = 249
• PCTINCREASE = 0

 I did add 3 datafiles into my tablespace, "MESODATA_1", but I still got errors and couldn't load the data.

Could anyone suggest me how to solve this problem, please.

Thanks in advance,

-sirirut- Received on Thu Feb 18 1999 - 21:59:12 CET