Hi
when i tried to load view into a table.(Basically the view is in one database
and the target table is in other database)
I am getting the below error
can any body suggest what to do.
Oracle_Enterprise_17,0: SQL*Loader: Release 10.2.0.2.0 - Production on Tue Jan 16 11:54:42 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: ora.434338.642423.0.ctl
Character Set WE8ISO8859P1 specified for all input.
Data File: ora.434338.642423.fifo.0
File processing option string: "FIX 79"
Bad File: ora.434338.642423.0.log.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Continuation: none specified
Path used: Direct - with parallel option.
Table "RDW90_DM"."V_SLS_SU_STORE_SKU_DMD", loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
SKU 1:10 10 CHARACTER
NULL if 1:10 = BLANKS
STORE 11:14 4 CHARACTER
NULL if 11:14 = BLANKS
YEARWEEK 15:18 4 INTEGER
NULL if 15:18 = 0X80000000(character '')
REG_UNITS 19:38 20 PACKED DECIMAL (38, 10)
NULL if 19:38 = 0X0000000000000000000000000000000000000000(character '')
PRM_UNITS 39:58 20 PACKED DECIMAL (38, 10)
NULL if 39:58 = 0X0000000000000000000000000000000000000000(character '')
SU_UNITS 59:78 20 PACKED DECIMAL (38, 10)
NULL if 59:78 = 0X0000000000000000000000000000000000000000(character '')
SQL*Loader-951: Error calling once/load initialization
ORA-26056: Requested direct path operation on a view is not supported.
Log file contents:
view
Moderators: chulett, rschirm, roy