How to solve this problem?

CodePudding user response:

Apparently there is something wrong with the SQL statement,
You put the SQL statement sent to come over,

CodePudding user response:

Is the DMP file, how?

CodePudding user response:

No, you DOS the SQL statements,
Aaa table, bb table, t table,

CodePudding user response:

IMP - 00041: warning: creating a object with a compiler warning
V_FUND_STOCKTYPE_ASSET "CREATE FORCE VIEW" ZY196. "" ""
"(" 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.v c_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 & lt;> 0 then
""Round (aaa) en_cb_balance/bb) en_total_asset, 4) * 100", "
"The else 0 end as en_cb_percent,"
"Case when bb. En_total_asset & lt;> 0 then
""Round (aaa) en_bas_market_value/bb) en_total_asset, 4) * 100", "
"The else 0 end as en_sz_percent"
"From"
"(the select aa i_fund,"
"Aa vc_stock_type,
""The sum (en_cb_balance) as en_cb_balance,"
"The sum (en_bas_market_value) as en_bas_market_value,"
"The sum (en_invest_profit) as en_invest_profit"
"From"
"("
"(the select Anderson _fund,"
"Dr. C_stock_type,"
"The 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 Anderson _fund, Dr. C_stock_type)"
"Union all
""(the select i_fund,
""The info vc_stock_type,
""0 as en_bas_market_value,"
"The NVL (sum (yy. En_invest_profit * fn_getexrate (i_fund, info
"", 0) as en_invest_profit vc_tradecury)), "
"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
""(the select cb i_fund,"
"B.v c_stock_type,"
"0 as en_bas_market_value,"
"0 as en_invest_profit,"
"The sum (cb) en_invest_balance * fn_getexrate (cb) i_fund, b.v c_tradec
""Ury) as en_cb_balance"
"From v_fundstocks_cal_cb cb, stockinfos b"
"Where cb. Vc_stock_code=b.v c_stock_code"
"Group by cb. I_fund, b.v c_stock_type)"
"
""Aa"
"Group by i_fund vc_stock_type) aaa,"
"
""V_fund_asset_balance bb,"
"Stocktypes t
""Where the aaa. I_fund=bb. I_fund and aaa. Vc_stock_type=t.v c_stock_type"
IMP - 00017:900 due to ORACLE error, the following statement failure:
"The ALTER PROCEDURE UP_REPORT_DATA_900001 COMPILE REUSE SETTINGS TIMESTAMP '2", "
"The 017-04-11:18:14:53 '"
IMP - 00003: ORACLE error 900
ORA - 00900: invalid SQL statement
Successful termination of import, but a warning,

The Import finished on the 2017-12-7 12:22:48

CodePudding user response:

Can ignore the process after guide go in, then recompile the specific quote what wrong,