Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Importing views with dependencies fails - Help!
Complete the import and issue individual alter view <viewname> compile;
statements the resolve the errors
or even use
dbms_utility.compile_schema('<schemaname>')
You could also write a little script
select 'alter '||object_type||' '||object_name||' compile;'
from user_objects
where status = 'INVALID'
More than one way out!
Hth,
Sybrand Bakker, Oracle DBA
"Wayne L. Phares" <pharesw_at_teoco.com> wrote in message
news:39521B24.CDBC6263_at_teoco.com...
> 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