重开的：ORA-00942和ORA-02063错误。请高手指点

Question

一、检查当前用户是否有create database link的权限
二、检查当前用户是否有create synonym 的权限
三、检查数据库中是否有LONGSHINE.TRANS_AGENT_RES这个对象
四、检查数据库中是否已有JF_DATALINK.US.ORACLE.COM这个对象
五、ORA-02063错误是因为ORA-00942这个错误引起的最后重点检查ora-00942的错误,祝你好运！！

Answer 1

在执行存储过程的用户下，执行select * from LONGSHINE.TRANS_AGENT_RES@JF_DATALINK.US.ORACLE.COM;
看是否有问题！
如果依然存在问题，建议将存储过程的写法贴出来！

Answer 2

/***************************************************************
    过程名称：P_IO_GET_SIMCARD_INFO
    输入参数：In_PROCID(功能标识号)
              Ic_OperNo(操作员工号)
      --------------------------------------------------------------
    *****************************************************************/
    PROCEDURE P_IO_GET_SIMCARD_INFO
    (
      In_ProcId  IN NUMBER,
      Ic_OperNo  IN VARCHAR2
    )
    IS
        Lc_DySql         VARCHAR2(1000); --定义动态sql
        Error_Log         EXCEPTION ;   --异常定义
        Lc_ReturnMsg        tcm_proc_control.error_msg%TYPE;
        Ln_LogId            tcm_proc_control_dtl_log.log_id%TYPE;
    BEGIN
        --记录运行的开始日志
        PAK_PM_PRO.P_PM_RTLOG(
                                In_ProcId,
                                Ic_OperNo,
                                'B', --开始标志
                                Ln_LogId,
                                null
                             );
        /*-------------------清空已存在接口表里信息-------------------------*/
        Lc_DySql := 'TRUNCATE TABLE tio_simcard_info';
        EXECUTE IMMEDIATE Lc_DySql;    
        /*-------------------------删除表索引-------------------------------*/
        IF PAK_PM_PRO.F_PM_CHECK_INDEX('TIO_SIMCARD_INFO','IDX_TIO_SIMCARD_INFO') = 1 THEN
            Lc_DySql :='DROP INDEX idx_tio_simcard_info';
            EXECUTE IMMEDIATE Lc_DYSql;
        END IF;
        /*---------------获取卡资源接口信息---------------------------------*/
        SET TRANSACTION  USE ROLLBACK SEGMENT DS_R08;
        INSERT INTO tio_simcard_info NOLOGGING
        (
            user_id             ,--VARCHAR2(10)           
            oper_type           ,--CHAR(1)                
            phone_id            ,--VARCHAR2(20)           
            sim_no              ,--VARCHAR2(20)           
            open_area_no        ,--VARCHAR2(4)            
            use_area_no         ,--VARCHAR2(4)            
            load_date           ,--VARCHAR2(8)            
            emp_no              ,--VARCHAR2(7)            
            send_date           ,--VARCHAR2(8)            
            oper_no             ,--VARCHAR2(7)            
            card_status         ,--VARCHAR2(2)            
            res             --VARCHAR2(100)     
        )
        SELECT
            to_char(user_no),
            decode(tele_type,'GSM','G','CDMA','C','PPC','P','Z'),
            device_number,
            sim_number,
            innet_local_net,--open_area_no
            sub_local_net,--use_area_no
            to_char(sysdate,'yyyymmdd'),
            null,--emp_no
            null,--send_date
            Ic_OperNo,
            '00',
            null
        FROM tjf_trans_sale_res;          
        COMMIT;
        /*-------------------------创建表索引-------------------------------*/
        Lc_DySql := 'CREATE INDEX idx_tio_simcard_info ON tio_simcard_info(user_id,oper_type)'||
                    ' TABLESPACE DS_INDEX_IO';
        EXECUTE IMMEDIATE Lc_DYSql;
        --记录成功日志
        PAK_PM_PRO.P_PM_RTLOG(
                                In_ProcId,
                                Ic_OperNo,
                                'S', --成功标志
                                Ln_LogId,
                                null
                             );
    EXCEPTION
        WHEN Error_Log THEN
            Rollback;
         --dbms_output.put_line(L_ReturnMsg);
             --记录异常日志
            PAK_PM_PRO.P_PM_RTLOG(
                                  In_ProcId,
                                  Ic_OperNo,
                                  'F', --失败标志
                                  Ln_LogId,
                                  Lc_ReturnMsg
                                  );
        WHEN OTHERS THEN
            Rollback;
            PAK_PM_PRO.P_PM_RTLOG(
                                    In_ProcId,
                                    Ic_OperNo,
                                    'F', --失败标志
                                    Ln_LogId,
                                    sqlerrm
                                 );
    END;--end P_IO_GET_SIMCARD_INFO

Answer 3

select * from LONGSHINE.TRANS_AGENT_RES@JF_DATALINK.US.ORACLE.COM
在执行的时候出现下面的错误。
ORA-02019: connection description for remote database not found

Answer 4

SELECT
            to_char(user_no),
            decode(tele_type,'GSM','G','CDMA','C','PPC','P','Z'),
            device_number,
            sim_number,
            innet_local_net,--open_area_no
            sub_local_net,--use_area_no
            to_char(sysdate,'yyyymmdd'),
            null,--emp_no
            null,--send_date
            Ic_OperNo,
            '00',
            null
        FROM tjf_trans_sale_res;
是这里报错吗？tjf_trans_sale_res和你建的TJF_TRANS_AGENT_RES的名字都不一样？
楼主可以通过select * from syn;查询一下是否有建的同义词，看一下各项是否正确