OraFAQ Forum: Server Administration » COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [string]

Home » RDBMS Server » Server Administration » COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [string]

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [string] [message #373151]

Thu, 29 March 2001 16:02

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);

Report message to a moderator

Re: COPY command failure, ORA : 01043 user side memory corruption [string], [string], [string], [str [message #373160 is a reply to message #373151]

Fri, 30 March 2001 09:07

kavithask
Messages: 34
Registered: March 2001
Location: London

Member

Hi,

It would help if you create a temporary table in the base environment and you then copy this table into the target environment.

When the temporary table is being created, you can replace the inner inline view with a temp table. Create the temp table based on the select used for the inline view (which fetches from fncl_acct_val) and add index to it and see if that increases the performance.

HTH
Kavitha

Report message to a moderator

Previous Topic:	ROWID error
Next Topic:	Bulk Insert.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 00:21:29 CDT 2024