Posts:
4
Registered:
10/12/11
|
|
|
|
NOVALIDATE expected when building a model
Posted:
Feb 21, 2012 4:01 PM
|
|
|
I get the following error when attempting to deploy my database project using 1.5.1:
Gen-86(2,65): Error ERR00003: Cannot build a model: Found ')', Expecting: NOVALIDATE Name: SCHEMA."VW_ViewName" Type: CREATE VIEW Text: CONSTRAINT "ViewName_pk" PRIMARY KEY ("ID") DISABLE) AS
This began immediately following the addition of a view with a primary key. My view script is as follows:
CREATE OR REPLACE VIEW SCHEMA."VW_ViewName"
(
"ID",
CONSTRAINT "ViewName_pk" PRIMARY KEY ("ID") DISABLE NOVALIDATE
)
AS
SELECT "ID" FROM "TableName";
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: NOVALIDATE expected when building a model
Posted:
Feb 24, 2012 10:33 AM
in response to: DRohlfing
|
|
|
DRohlfing,
It looks like our internal call to DBMS_METADATA.GET_DDL is not returning the NOVALIDATE clause. Can you try running the following statement from SQLPlus:
SELECT DBMS_METADATA.GET_DDL('VIEW', '<my_view_name>', '<my_schema_name>') FROM DUAL;
Can you post the results to to forum?
|
Dwight
|
|
Posts:
4
Registered:
10/12/11
|
|
|
|
Re: NOVALIDATE expected when building a model
Posted:
Feb 27, 2012 8:29 AM
in response to: Dwight
|
|
|
CREATE OR REPLACE FORCE VIEW "QCEW"."VW_Employer" ("EmployerID", "ContactName", "CreateDate",
CONSTRAINT "VW_Employer_pk" PRIMARY KEY ("EmployerID") DISABLE) AS
SELECT
e."EmployerID", e."ContactName", e."CreateDate"
FROM "Employer" e
|
|
|
Posts:
263
Registered:
8/22/07
|
|
|
|
Re: NOVALIDATE expected when building a model
Posted:
Feb 27, 2012 2:51 PM
in response to: DRohlfing
|
|
|
Ok,
That definitely shows us that DBMS_METADATA is not returning the NOVALIDATE clause. What version of Oracle is your database instance running?
I want to reproduce this, so I can work up a fix.
|
Dwight
|
|
Posts:
4
Registered:
10/12/11
|
|
|
|
Re: NOVALIDATE expected when building a model
Posted:
Feb 27, 2012 4:05 PM
in response to: Dwight
|
|
|
Currently our team is working against Oracle 11g XE. The version number is 11.2.0.2.0.
|
|
|
|
Legend
|
|
MVP: 2501
+
pts
|
|
Guru: 2001
- 2500
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
