Oracle Database Discussions

I am trying to load about 14 GBs of data, totaling ~13.5 million records.
The raw data is about 14GBs, and the table space is set to 30GBs, its all text data.
The data is from about 200 different site files ranging in size from 10-180 MBs.
This is (real) test data I'm using to try to optimize my indexes and such before I start using the table for actual reports.
A DBA, I am not, proficient at databases and programming, I am, so please bare with me :)

My process is to use sqlldr to on an Oracle 10 DB to load the data into a records_load table, then use a procedure to basically do an insert into records (...) select (...) from records_load, delete from records_load.

I did a couple sites one at a time, and they work fine, so I have 500,000 records in my records table.
But when I try to transfer the entire 13,000,000 records from the load table using the SP, it eventually hangs.

If I log into sqlplus from another window, I get
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.

HOWEVER, everything I find online is telling me that a disk is full.
Oracle is setup on a Windows Server, as follows:

Drive Total Free
oracle-c (c:) 50.0 GB 39.3 GB
oracle-apps (e:) 99.9 GB 91.2 GB
oracle-logsA (f:) 195 GB 140 GB
oracle-logsB (g:) 83.5 GB 83.3 GB
oracle-data (h:) 278 GB 150 GB

I ran into this problem on as well on Friday, and ran:
RMAN> delete expired backup;
and this "seemed" to fix the issue, which doesn't make much sense to me.

So, I modified my SP somewhat today, to use a cursor, and loop through each site, and do the
"*loop* insert into records (...) select (...) from records_load *where site=cur_row.site*, delete from records_load *where site=cur_row.site*"

Now my db is hung again, with PLENTY of disk space.
I'm really not sure what to do and would really appreciate any suggestions?