SQL*Loader error 605
Date: Sun, 10 Oct 1999 05:01:08 GMT
Message-ID: <38001a78.24562225_at_news.metro.net>
I'm trying to load a flat text file with about 30,000 records into Oracle 8 Personal Edition database. SQL*Loader hangs each time after displaying
Commit point reached - logical record count 2112
If I press Ctrl-C, it displays
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
Pressing Ctrl-Break terminates it.
ORCLALRT.LOG contains the following lines:
Current log# 2 seq# 262 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA Thread 1 cannot allocate new log, sequence 263 Checkpoint not complete
Any ideas?
For what it's worth, this is the entire contents of ORCLALRT.LOG from the start of the latest run of SQLLDR80:
Sat Oct 09 21:52:52 1999
ORACLE V8.0.4.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows 95 V4.0, OS V192.0, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.4.0.0.
System parameters with non-default values:
processes = 50 shared_pool_size = 3500000 disk_asynch_io = FALSE control_files = C:\orawin95\DATABASE\ctl1orcl.ora db_block_buffers = 200 db_block_size = 2048 log_buffer = 8192
log_checkpoint_interval = 10000
db_files = 1024
db_file_multiblock_read_count= 8
sequence_cache_entries = 10
sequence_cache_hash_buckets= 10
remote_login_passwordfile= SHARED
global_names = TRUE
db_name = oracle job_queue_processes = 2 parallel_max_servers = 5 background_dump_dest = %RDBMS80%\trace user_dump_dest = %RDBMS80%\trace max_dump_file_size = 10240
Sat Oct 09 21:52:53 1999
PMON started with pid=2
Sat Oct 09 21:52:53 1999
DBW0 started with pid=3
Sat Oct 09 21:52:53 1999
LGWR started with pid=4
Sat Oct 09 21:52:53 1999
CKPT started with pid=5
Sat Oct 09 21:52:53 1999
Sat Oct 09 21:52:53 1999
RECO started with pid=7
SMON started with pid=6
Sat Oct 09 21:52:53 1999
SNP0 started with pid=8
Sat Oct 09 21:52:54 1999
SNP1 started with pid=9
Sat Oct 09 21:52:55 1999
ALTER DATABASE MOUNT EXCLUSIVE
Sat Oct 09 21:52:55 1999
Successful mount of redo thread 1.
Sat Oct 09 21:52:55 1999
Completed: ALTER DATABASE MOUNT EXCLUSIVE
Sat Oct 09 21:52:55 1999
alter database open
Sat Oct 09 21:52:56 1999
Thread 1 opened at log sequence 261
Current log# 1 seq# 261 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Successful open of redo thread 1.
Sat Oct 09 21:52:56 1999
SMON: enabling cache recovery
SMON: enabling tx recovery
Sat Oct 09 21:53:01 1999
Completed: alter database open
Sat Oct 09 21:53:05 1999
Thread 1 advanced to log sequence 262
Current log# 2 seq# 262 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA
Thread 1 cannot allocate new log, sequence 263
Checkpoint not complete
Current log# 2 seq# 262 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA
Thread 1 advanced to log sequence 263
Current log# 1 seq# 263 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Thread 1 advanced to log sequence 264
Current log# 2 seq# 264 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA
Thread 1 advanced to log sequence 265
Current log# 1 seq# 265 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Thread 1 cannot allocate new log, sequence 266
Checkpoint not complete
Current log# 1 seq# 265 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Thread 1 advanced to log sequence 266
Current log# 2 seq# 266 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA
Thread 1 advanced to log sequence 267
Current log# 1 seq# 267 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Thread 1 cannot allocate new log, sequence 268
Checkpoint not complete
Current log# 1 seq# 267 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Thread 1 advanced to log sequence 268
Current log# 2 seq# 268 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA
Thread 1 advanced to log sequence 269
Current log# 1 seq# 269 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Thread 1 cannot allocate new log, sequence 270
Checkpoint not complete
Current log# 1 seq# 269 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Thread 1 advanced to log sequence 270
Current log# 2 seq# 270 mem# 0: C:\ORAWIN95\DATABASE\LOG1ORCL.ORA
Thread 1 advanced to log sequence 271
Current log# 1 seq# 271 mem# 0: C:\ORAWIN95\DATABASE\LOG2ORCL.ORA
Received on Sun Oct 10 1999 - 07:01:08 CEST