gkaindia.com

Home > > Create Force View

Create Force View

Advertisement
Hi all,
When I import the dumpfile I get the follwing errors...
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "uni"."V_F_OFS_REQUEST_DETAIL" "
" ("RECID","XMLRECORD","APPLICATION","NAPPLICATION","VERSION","NVERSION","F"
"UNCTION","NFUNCTION","TRANS_REFERENCE","NTRANS_REFERENCE","USER_NAME","NUSE"
"R_NAME","COMPANY","NCOMPANY","DATE_TIME_RECD","NDATE_TIME_RECD","DATE_TIME_"
"QUEUE","NDATE_TIME_QUEUE","DATE_TIME_PROC","NDATE_TIME_PROC","STATUS","NSTA"
"TUS","MSG_IN","NMSG_IN","MSG_OUT","NMSG_OUT","ACTION","NACTION","GTS_CONTRO"
"L","NGTS_CONTROL","NO_OF_AUTH","NNO_OF_AUTH") AS "
"SELECT x.RECID, x.XMLRECORD.getClobVal() "XMLRECORD""
",NVL(extractValue(x.xmlrecord,'/row/c1'),'^A') "APPLICATION",NVL(NUMCAST(ex"
"tractValue(x.xmlrecord,'/row/c1')),0) "nAPPLICATION",NVL(extractValue(x.xml"
"record,'/row/c2'),'^A') "VERSION",NVL(NUMCAST(extractValue(x.xmlrecord,'/ro"
"w/c2')),0) "nVERSION",NVL(extractValue(x.xmlrecord,'/row/c3'),'^A') "FUNCTI"
"ON",NVL(NUMCAST(extractValue(x.xmlrecord,'/row/c3')),0) "nFUNCTION",NVL(ext"
"ractValue(x.xmlrecord,'/row/c4'),'^A') "TRANS_REFERENCE",NVL(NUMCAST(extrac"
"tValue(x.xmlrecord,'/row/c4')),0) "nTRANS_REFERENCE",NVL(extractValue(x.xml"
"record,'/row/c5'),'^A') "USER_NAME",NVL(NUMCAST(extractValue(x.xmlrecord,'/"
"row/c5')),0) "nUSER_NAME",NVL(extractValue(x.xmlrecord,'/row/c6'),'^A') "CO"
"MPANY",NVL(NUMCAST(extractValue(x.xmlrecord,'/row/c6')),0) "nCOMPANY",NVL(e"
How to overcome this? and how to avoid this? Pls suggest me
Thanks in advance..
Advertisement
Yes, force view command never gives an error, its always a warning. And if you are getting this error during import, dont worry, view have been created in your schema by import command. This might happen when view is refers to any table that actually is not present. In your case it might be a case when view in the current schema refers table in another schema. So i think you should just try to query that view in the schema where you have just done the import.
Also to verify that why error came, you can go to the source schema and check for the base table of the view under consideration. From there you can get useful information about the actual base table and why import showing up the warning.
Read the other 9 answers
Is it possible to create materialized view log file for force refresh with join condition. Say for example: CREATE MATERIALIZED VIEW VU1 REFRESH FORCE ON DEMAND AS SELECT e.employee_id, d.department_id from emp e and departments d where e.department_
Back again - cleanup did not fix. Why am I getting 'missing keyword' error? Thanks for your eyes! Alexandra code CREATE OR REPLACE FORCE VIEW "DISC_AUTH_ECR_VW" ("DISC_AUTH_ID", "DISC_DT", "REQUESTOR", "BRANDIN
Hi Ihave got 2 tables emp and project In emp tabe: emp_no family name given name In porgect table: emp_no status(assigned,unassigned) start_date end_date emp_no Family_name given_name 1 Smith John In project table same employee can have many assigeme
Hi @ all, i'm trying to create a MATERIALIZED VIEW LOG for a fast refresh of a MATERIALIZED VIEW. It works fine with a simple Request in the MATERIALIZED VIEW: CREATE MATERIALIZED VIEW MV_ZOTD43_P TABLESPACE GDII BUILD IMMEDIATE REFRESH FORCE AS SELE
Hi all, I am trying to create the following materialized view, but throwing me the error message below CREATE MATERIALIZED VIEW "MVIW"."XXFA_R051_SHT2_AMV" (PARTITION BY LIST (PERIOD_YEAR) PARTITION YEAR2006 VALUES LESS ('2006'), PARTI
Hi Experts I want to Create a view which reside in one instance for example xxx Instance . I want to create the same view which reside in xxx instance to another instance for example YYY Instance How to acheive this ? I tried desc the View take the v
Oracle 10g R2 on AIX 5.3L I create a script (with help of EM) for a materilaized view CREATE MATERIALIZED VIEW "BAANDB"."R2_MV" TABLESPACE "USERS" NOLOGGING STORAGE ( INITIAL 128K) USING INDEX TABLESPACE "BAANIDX" S
Hi all, I'm trying to create a materialized view with a specific a column size. Something like create materialized view test_mv refresh force on demand as select id,        cast(my_compound_field as nvarchar2(50)) from ( select id,               fiel
Hi When I tried to create MV show me error : SQL> @CRIA_MV_ARC_BW.SQL AND INDUSTRIAL.CD_FABRICA = SUBSTR(ARC.DS_ARC, 1, 3) ERROR at line 88: ORA-01031: insufficient privilegesI am using Oracle 9.02 and there are Grant for all Tablles , my query of cr
Kindly let me know in what situation force view created apart from doesn't have base tablehttp://tinyurl.com/yhp92vmRead other 2 answers
Dear All, I've Oracle Enterprise Edition(ver 9.0.1.1.1) running on Windows Xp Home Edition, When I run the following statement to create a materialized view I got the famous error ORA-03113: end-of-file on communication channel.And the strange thing
Hi all, i am using oracle 11g. i want to create  parameter materialized view  with two parameter (STORED_VALUE, LOV_NAME) with  an index . i have below view CREATE OR REPLACE FORCE VIEW SR_MY_TEST(DISPLAYED_VALUE, STORED_VALUE, LOV_NAME) AS   SELECT 
Hello. Working with SQL Developer, I'm trying to write a procedure that creates a view. After a successful compilation, each time I try to execute it I get an ORA-00911 error and I'm not able to find the reason. Here's my code. Thanks in advance.   C
I following the sample in Oracle document to create materialized viewCREATE MATERIALIZED VIEW LOG ON sales    WITH ROWID, SEQUENCE(amount_sold, time_id, prod_id)   INCLUDING NEW VALUES; CREATE MATERIALIZED VIEW LOG ON times    WITH ROWID, SEQUENCE (t
Anybody can help me? Why could this happen? SQL> CREATE MATERIALIZED VIEW LESTARI.YIELD_BI_ACTUAL_PLAN_BLOK_MVU 2 TABLESPACE MVU 3 NOCACHE 4 NOPARALLEL 5 REFRESH FORCE 6 START WITH TO_DATE('19-APR-2005 18:00:00','DD-MON-YYYY HH24:MI:SS') 7 WITH PRIMA
ORA-04052 creating Materialized View Hi All !! I'm trying to create a Materialized view and his query definition uses an active public database link. When I ran the script for creating the view I get the following message: ERROR in line 1: ORA-04052:
Hi I need to create a simple view like this No Count 10 15 to get the No i am using a function which would normally return 1 value like 10 above but could sometimes return 2 numbers in the following format 10:5 When I get a number like this i need to
hello, only i know that it is created object in db and after tat we can create the table as per requirement. please tell me wat is the main advantage of Force View? Tks PMHello PM, if you have mutual dependencies, e.g. between a package and a view, t
Hi All, Can you tell me what are the uses of force view? Thanks in advance.It's relatively common to find in install scripts (and/or in import & export). If you're going to create dozens of different views which depend on various other views and/or t