DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Default Value In Materialized Views

  1. #1
    Join Date
    May 2003
    Posts
    32

    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

  2. #2
    Join Date
    Jul 2003
    Posts
    59
    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?

  3. #3
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    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

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    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
  •  


Click Here to Expand Forum to Full Width