這個問題如何解決？
uj5u.com熱心網友回復：
明顯是SQL陳述句有問題。你把SQL陳述句發過來。
uj5u.com熱心網友回復：
是整個dmp檔案，怎么弄？uj5u.com熱心網友回復：
不是，你dos中的SQL陳述句。有aaa表，bb表，t表。
uj5u.com熱心網友回復：
IMP-00041: 警告: 創建的物件帶有編譯警告
"CREATE FORCE VIEW "ZY196"."V_FUND_STOCKTYPE_ASSET" "
" ("I_FUND","VC_STOCK_TYPE","VC_STOCKTYPE_CAPTION","EN_CB_BALANCE","EN_BAS_"
"MARKET_VALUE","EN_INVEST_PROFIT","EN_TOTAL_ASSET","EN_NET_ASSET","EN_FUND_S"
"HARE","EN_UNIT_ASSET","EN_CB_PERCENT","EN_SZ_PERCENT") AS "
"select aaa.i_fund,"
" aaa.vc_stock_type,"
" t.vc_stocktype_caption,"
" aaa.en_cb_balance,"
" aaa.en_bas_market_value,"
" aaa.en_invest_profit,"
" bb.en_total_asset,"
" bb.en_net_asset,"
" bb.en_fund_share,"
" bb.en_unit_asset,"
" case when bb.en_total_asset <> 0 then"
" round(aaa.en_cb_balance/bb.en_total_asset,4)*100"
" else 0 end as en_cb_percent,"
" case when bb.en_total_asset <> 0 then"
" round(aaa.en_bas_market_value/bb.en_total_asset,4)*100"
" else 0 end as en_sz_percent"
" from"
"(select aa.i_fund,"
" aa.vc_stock_type,"
" sum(en_cb_balance) as en_cb_balance,"
" sum(en_bas_market_value) as en_bas_market_value,"
" sum(en_invest_profit) as en_invest_profit"
" from"
" ("
" (select a.i_fund,"
" a.vc_stock_type,"
" nvl(sum(en_bas_market_value),0) as en_bas_market_value,"
" 0 as en_invest_profit,"
" 0 as en_cb_balance"
""
" from v_fundstocks_cal_sz a group by a.i_fund,a.vc_stock_type)"
" union all"
" (select i_fund,"
" info.vc_stock_type,"
" 0 as en_bas_market_value,"
" nvl(sum(yy.en_invest_profit* fn_getexrate(i_fund,info"
".vc_tradecury)),0) as en_invest_profit,"
" 0 as en_cb_balance"
" from v_fundstocks_cal_sy yy ,stockinfos info"
" where yy.vc_stock_code = info.vc_stock_code"
" group by i_fund,info.vc_stock_type"
" )"
""
" union all"
" (select cb.i_fund,"
" b.vc_stock_type,"
" 0 as en_bas_market_value,"
" 0 as en_invest_profit,"
" sum(cb.en_invest_balance* fn_getexrate(cb.i_fund,b.vc_tradec"
"ury)) as en_cb_balance"
" from v_fundstocks_cal_cb cb,stockinfos b"
" where cb.vc_stock_code=b.vc_stock_code"
" group by cb.i_fund ,b.vc_stock_type )"
""
") aa"
" group by i_fund,vc_stock_type) aaa"
""
", v_fund_asset_balance bb ,"
" stocktypes t"
" where aaa.i_fund= bb.i_fund and aaa.vc_stock_type = t.vc_stock_type"
IMP-00017: 由于 ORACLE 錯誤 900, 以下陳述句失敗:
"ALTER PROCEDURE "UP_REPORT_DATA_900001" COMPILE REUSE SETTINGS TIMESTAMP '2"
"017-04-11:18:14:53'"
IMP-00003: 遇到 ORACLE 錯誤 900
ORA-00900: 無效 SQL 陳述句
成功終止匯入, 但出現警告。
Import finished on 2017-12-7 12:22:48
uj5u.com熱心網友回復：
先忽略后看程序能不能導進去,然后重新編譯看具體報啥錯。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/77975.html
標籤：開發
上一篇：關于DataFactory連接oralce資料庫的問題
下一篇：資料庫