Home » RDBMS Server » Server Administration » COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [string]
COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [string] [message #373151] |
Thu, 29 March 2001 16:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
keyur
Messages: 4 Registered: March 2001
|
Junior Member |
|
|
Hi,
I used COPY command to copy result of a very long and complex query into a table.
There is no error as far as column data types are concerned.
The Error occurs becoz the SQL statement is very long and the user side memory runs out of space.
( I checked it by removing and adding columns of SQL query used..it fails after 255 character in SQL query...or so..)
Is there any setting that can be used to get extra user side memory ???.
COPY FROM username/password@FDMD -
INSERT table_new -
USING -
SELECT -
b.fiscal_year fiscal_year -
,b.acctg_perd acctg_perd -
,g.district_csa_id district_csa_id -
,NVL(g.owner_type_cd,'SPCS') owner_type_cd -
,b.sales_chnl_id sales_chnl_id -
,b.fncl_acct_nbr fncl_acct_nbr -
,NVL(g.bus_unit_id,b.bus_unit_id) bus_unit_id -
,'99999' cost_cntr_id -
,b.proration_ind proration_ind -
,b.cust_type_cd cust_type_cd -
,b.credit_class_cd credit_class_cd -
,b.sys_src_name sys_src_name -
,NVL(c.mrc_type, -1) mrc_type -
,b.serv_name serv_name -
,SYSDATE load_dt -
,sum(decode(f.descr,NULL,0,b.charge_cr_amt)) charge_cr_amt -
,sum(b.total_bill_minute_qty) total_bill_minute_qty -
,NVL(g.owner_cd,'85') owner_cd -
,NVL(u.sbu_type_cd, 'UNKN') sbu_type_cd -
from -
bild_amt_info b -
,csa_val g -
,csa_serv_val c -
,subs_cust_type_val s -
,sbu_val u -
,(select fncl_acct_nbr, descr -
from fncl_acct_val f -
where upper(fncl_acct_type) = 'REVENUE' -
and fncl_acct_nbr between 000000 and 999999 -
) f -
where b.fiscal_year = :fiscal_year -
and b.acctg_perd = :acctg_perd -
and b.sub_type_cd = s.sub_type_cd (+) -
and b.acct_type_cd = s.acct_type_cd (+) -
and b.cust_type_cd = s.cust_type_cd (+) -
and s.sbu_cd = u.sbu_cd (+) -
and b.sbscrp_leaf_csa_id = g.leaf_csa_id -
and b.sbscrp_leaf_csa_id = c.leaf_csa_id (+) -
and b.serv_name = c.serv_name (+) -
and b.fncl_acct_nbr = f.fncl_acct_nbr (+) -
group by -
b.fiscal_year -
,b.acctg_perd -
,g.district_csa_id -
,NVL(g.owner_type_cd,'SPCS') -
,b.sales_chnl_id -
,b.fncl_acct_nbr -
,NVL(g.bus_unit_id ,b.bus_unit_id) -
,'99999' -
,b.proration_ind -
,b.cust_type_cd -
,b.credit_class_cd -
,b.sys_src_name -
,NVL(c.mrc_type, -1) -
,b.serv_name -
,to_char(SYSDATE,'DD-MON-YY') -
,NVL(g.owner_cd,'85') -
,NVL(u.sbu_type_cd, 'UNKN') -
having (sum(decode(f.descr,NULL,0,b.charge_cr_amt)) != 0 -
or sum(b.total_bill_minute_qty) != 0);
|
|
|
|
Goto Forum:
Current Time: Sat Sep 07 16:55:11 CDT 2024
|