Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP ! SQL LOADER 605 - Non-data dependent Oracle Error occured

HELP ! SQL LOADER 605 - Non-data dependent Oracle Error occured

From: <kif_at_worldnet.att.net>
Date: 1997/10/07
Message-ID: <61c40a$473@bgtnsc02.worldnet.att.net>#1/1

We have Oracle 7.3 on Win NT 4.0. I loaded 99540 records from a fixed format text file into an Oracle table. Then I had to add 3 new fields(columns) to the table. So I truncated the table and changed the structure. But when I started loading the data again, it gave the above error, which I suppose is due to space problem.

I have a rollback tablespace with 10 MB space and all of it has been used up. There is no free space. Is there a way to get back that 10MB space?

                        thanks in advance

                        
Received on Tue Oct 07 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US