Database Software

Hi folks,

Iam loading flat file from my server location. but Iam getting the following error.i tried with different times with diferent locations...........but getting the same error.

my flat file dir is /svm/oracle/BI_staging.

but while loading it the control file is taking my local machine path.please suggest me


Thanks
vijji


M_FIXED_BI_STAGING
Description : Runtime User : REPOSOWR Started : 2009-01-12 19:52:25.0
Status
Log
Error
RPE-01013: SQL Loader reported error condition, number 1.

SQL*Loader: Release 10.2.0.1.0 - Production on Mon Jan 12 19:52:38 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Control File: C:\svm\oracle\BI_staging\M_FIXED_BI_STAGING.ctl
Character Set WE8MSWIN1252 specified for all input.

Data File: /svm/oracle/BI_staging/FIXEDTEST1.txt
Bad File: C:\svm\oracle\BI_staging\FIXEDTEST1.bad
Discard File: none specified

(Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 200 rows, maximum of 50000 bytes
Continuation: Concatenate every 1 physical records
Path used: Conventional

Table "FIXED_TEST_TGT", loaded from every logical record.
Insert option in effect for this table: APPEND

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
"ID" 1:3 3 CHARACTER
"NAME" 4:11 8 CHARACTER
"SALARY" 12:15 4 CHARACTER
"ZIP" 16:20 5 CHARACTER

SQL*Loader-500: Unable to open file (/svm/oracle/BI_staging/FIXEDTEST1.txt)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Table "FIXED_TEST_TGT":
0 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.


Space allocated for bind array: 6000 bytes(200 rows)
Read buffer bytes: 65536

Total logical records skipped: 0
Total logical records read: 0
Total logical records rejected: 0
Total logical records discarded: 0

Run began on Mon Jan 12 19:52:38 2009
Run ended on Mon Jan 12 19:52:38 2009

Elapsed time was: 00:00:00.38
CPU time was: 00:00:00.03

SQL*Loader: Release 10.2.0.1.0 - Production on Mon Jan 12 19:52:38 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-500: Unable to open file (/svm/oracle/BI_staging/FIXEDTEST1.txt)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Job Summary
Updated : 2009-01-12 19:52:27.0 Job Final Status : Completed with errors Job Processed Count : 1 Job Error Count : 1 Job Warning Count : 0