Home » SQL & PL/SQL » SQL & PL/SQL » ORA-22992: (oracle,9.2.0.8,window)
ORA-22992: [message #352590] |
Wed, 08 October 2008 08:54  |
|
Hi All,
I am trying to insert data from remote server using DBlink from but I am getting below error .
ORA-22992: cannot use LOB locators selected from remote tables
ORA-06512: at "SCOTT.MRC_MRCDASH_STAGE_LOAD", line 180
ORA-06512: at line 3
Query
INSERT INTO mrc_alliance_stg(
CASE_ID,
QUEUE_NAME,
CATEGORY_NAME,
TYPE_NAME,
ITEM_NAME,
PRIORITY,
STATUS,
AGENT_NAME,
AGENT_LOGIN,
ASSIGNEE_MANAGER_NAME,
VENDOR,
LTF1,
LTF2,
LTF3,
RCA1,
RCA2,
RCA3,
CASE_REQUESTOR_LOGIN,
CASE_REQ_FULL_NAME,
CASE_DESCRIPTION,
CASE_SUMMARY,
CASE_SOLUTION_SUMMARY,
CASE_SOLUTION_DETAILS,
CASE_CREATE_DATE,
CASE_RESOLVE_DATE,
CASE_CLOSE_DATE,
RCA_DETAILS,
LTF_DETAILS,
TOTAL_TIME_SPENT,
SHORT_TERM_FIXC)
select
CASE_ID_,
NVL(ASSIGNED_TO_GROUP_,'NA'),
NVL(CATEGORY,'NA'),
NVL(TYPE,'NA'),
NVL(ITEM,'NA'),
PRIORITY,
STATUS,
NVL(ASSIGNED_TO_INDIVIDUAL_,'NA'),
NVL(ASSIGNEE_LOGIN_NAME,'NA'),
NVL(ASSIGNEE_MANAGER_FULL_NAME,'NA'),
NVL(X_VENDOR__,'NA'),
NVL(X__GLOBAL__FIXED_CODE,'NA'),
NVL(X_SUBFIX,'NA'),
NVL(X_SUBSUBFIX,'NA'),
NVL(X__GLOBAL__CAUSE_CODE,'NA'),
NVL(X_SUB_CAUSE,'NA'),
NVL(X_SUBSUBCAUSE,'NA'),
NVL(REQUESTER_LOGIN_NAME_,'NA'),
NVL(REQUESTER_NAME_,'NA'),
NVL(DESCRIPTION,'NA'),
NVL(SUMMARY,'NA'),
NVL(SOLUTION_SUMMARY,'NA'),
NVL(SOLUTION_DESCRIPTION,'NA'),
NVL(to_date('01-01-1970','dd/mm/yyyy')+(CREATE_TIME/86400),to_date('1/1/1901','mm/dd/YYYY')),
NVL(to_date('01-01-1970','dd/mm/yyyy')+(RESOLVED_TIME/86400),to_date('1/1/1901','mm/dd/YYYY')),
NVL(to_date('01-01-1970','dd/mm/yyyy')+(AUTO_CLOSE_TIME/86400),to_date('1/1/1901','mm/dd/YYYY')),
NVL(ROOT_CAUSE,'NA'),
NVL(RESOLUTION_METHOD,'NA'),
NVL(TOTAL_TIME_SPENT,0),
NVL(X_SHORT_TERM_FIX,'NA')
FROM HPD_HELPDESK@ALIANCEDB
where
ASSIGNED_TO_GROUP_ in (select distinct QUEUE_NAME from MRC_QUEUE_D)
AND to_date('01-01-1970','dd/mm/yyyy')+(MODIFIED_TIME/86400) < x_curr_update_process_date
AND to_date('01-01-1970','dd/mm/yyyy')+(MODIFIED_TIME/86400) > x_last_update_process_date;
Could you suggest me what I need to do .
Thanks,
Sagar
|
|
|
Re: ORA-22992: [message #352592 is a reply to message #352590] |
Wed, 08 October 2008 09:15  |
joicejohn
Messages: 327 Registered: March 2008 Location: India
|
Senior Member |
|
|
@vickey_sagar1,
Quote: |
ORA-22992: cannot use LOB locators selected from remote tables
Cause: A remote LOB column cannot be referenced.
Action: Remove references to LOBs in remote tables.
|
I cannot pinpoint to a particular column because you didn't provide us with table description.
Anyways, this Link might be of some use to you.
Regards,
Jo
|
|
|
Goto Forum:
Current Time: Mon Feb 17 17:25:05 CST 2025
|