Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    46

    Arrow Unanswered: Double & Triple Materialized View output

    -
    -
    I have got this quirky problem with a materialized view displaying double and triple of the same (row) data.

    Has anyone seen this?

    The developer seems to have no idea.
    There seems to be no prob with the physical table data.

    It is indexed by three factors:

    - unique_index
    - channel_no
    - program_time


    It typicaly triples up at 10pm (22:00) doubles up at 11pm (23:00)
    then doubles up again at 00:00 then from 01:00 it is normal again.


    just thought I would check 2 see if it wasnt neccessarily application specific

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    magic ball broken.

    it would help if you post your code to create the MV
    and to create the LOG.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jan 2003
    Posts
    46

    Sorry, Its not my app

    -
    -
    Its not our app so I dont have priveledge to the code.

    I was just trying to eliminate the DB materialized view as a problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •