Importing views with dependencies fails - Help!

From: Wayne L. Phares <pharesw_at_teoco.com>
Date: 2000/06/22
Message-ID: <39521B24.CDBC6263@teoco.com>#1/1

I am import an export and have the following problem.

When ever I try to import a view that calls a view that calls a function, the first view in the chain does not import with this error: IMP-00017: following statement failed with ORACLE error 1730:
"CREATE FORCE VIEW

"BT51"."VW_NECA_USAGE_BIP"                            ("B"

"AN_ID","INVOICE_SEQ_ID","SUMMARY_OFFICE_ID","FLAG_INT","CYCLE_START","CYCLE"

"_STOP","RECORD_TYPE","ELEMENT_ID","ELEMENT_ID_DESCRIPTION","RATING_POINT_1""

","RATING_POINT_2","TRAFFIC_TYPE","TOTAL_USAGE_AMT","STATE_LEVEL_COMPANY_COD"

"E","USAGE_RATE","BILLED_BIP","BILLED_MILEAGE_QTY","SERVICE","NECA_BIP","BIP"

"_DIFFERENCE","DISPUTE_AMOUNT") AS "
"SELECT"
" vw_base_neca_usage.*, "
" (billed_bip - neca_bip) AS bip_difference, "
" ((total_usage_amt * (billed_bip - neca_bip)) / billed_bip) AS
dispute_amou"
"nt"
"FROM "
" vw_base_neca_usage"

IMP-00003: ORACLE error 1730 encountered
ORA-01730: invalid number of column names specified
ORA-04063: view "BT51.VW_BASE_NECA_USAGE" has errors

This only happens on views that call views that call functions. I do know that functions do not get imported until AFTER views do and this is why the view that call the function gets imported with an "invalid" state.

This is happening on 8.0.4.2.4 & 8.0.5.1.1 (the latest patches for each - I may have not remembered the number correctly).

So I have to manually recreate the views after the import is done - is there any way to get around this?

Please help,

Wayne.
surooot_at_hotmail.com Received on Thu Jun 22 2000 - 00:00:00 CDT