Thank you very much for the great instructions!
I looked for this solution.
One think I found out is that I don't even need the
bold statement in your suggestion -
create table t_mv ( userid1, userid2, owner, object_name, constraint t_mv_pk primary key ( userid2) )
organization index <b>as select * from t</b>
I just have to specify the fields in the CREATE TABLE statement - e.g.
create table t_mc
(
userid1 number,
userid2 number,
Details varchar2(100),
constraint t_mv_pk primary key ( userid2)
)
That makes the code easier to maintain, when the SELECT statement is more extensive.
Greetings, Walter