-
Default Value In Materialized Views
Hi AGian!
The scenerio is ...
i m creating a materialized view based on the remotes tables...
The remote table contains DEFAULT values.
but when the materialized views are created .. they dont have these default values...
How can i get these DEFAULT values of the tables in Materialized Views.
Suggesstions.
RAFF
-
Do you mean, in existing rows in the remote table, there are default values currently populated, and then your MV refreshes, selecting one of those columns that has default values in it, and the values in the MV appear as NULL? What value is in there if it does not have the values from the source table (whether it came from a declarative default attribute or not doesn't matter).
Can you clarify the situation?
-
when record inserted in the remote table, the default should appear in remote table ( is'nt it ? ).
In your M view it is not appearing ?
What is your refresh method ?
Dilip Patel
OCP 8i
Catch me online at Yahoo: ddpatel256
-
Try creating table first with defaults, and then create snapshot on prebuilt table.
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|