DSXchange

laxmi_etl · Post by **laxmi_etl** » Tue Jan 16, 2007 1:41 pm

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:

chulett · Post by **chulett** » Tue Jan 16, 2007 1:44 pm

Actually, it looks like your target is a view. Load the base table(s) instead.

laxmi_etl · Post by **laxmi_etl** » Tue Jan 16, 2007 1:55 pm

Sorry, Actually My target is also view not a table.

laxmi_etl · Post by **laxmi_etl** » Tue Jan 16, 2007 1:55 pm

Sorry, Actually My target is also view not a table.

kcbland · Post by **kcbland** » Tue Jan 16, 2007 2:12 pm

sqlldr can't load a view in DIRECT path. Switch to DML.

chulett · Post by **chulett** » Tue Jan 16, 2007 2:22 pm

...and then only if the view is 'updateable' I do believe. As previously noted, you could always target the base tables.

narasimha · Post by **narasimha** » Tue Jan 16, 2007 2:29 pm

It is more efficient to work with the base tables (with DIRECT option), than removing the DIRECT option and loading of view.