Re: Materialized View

From: ExecMan <>
Date: Thu, 17 May 2012 09:35:42 -0700 (PDT)
Message-ID: <>

On May 17, 10:52 am, dombrooks <> wrote:
> Can you show the same approach working with a normal table?
> 1. I don't see why anyone should ever want to do this whether creating tables or MVs.
> 2. If this was going to work you'd need to pass a bind variable, surely. The SQL Engine knows nothing about v_inst_hold_rec.
> 3. You can't pass a bind variable because you'd get ORA-01027: bind variables not allowed for data definition operations.
> So, I'm very interested to see what you're doing when you say it works with normal tables.

This is all done in a PL/SQL procedure. Sorry if I did not indicate that before........ Received on Thu May 17 2012 - 11:35:42 CDT

Original text of this message