This content has been marked as final. Show 3 replies
Is there any way to avoid having to select the rowid's as part of the materialized view?
No, unless you'd like to sacrifice FAST refresh option.
Or a way to essentially "hide" them within the database on the mv object itself
The only thing that comes to mind is column masking that is part of Virtual Private Database, but I’m afraid it’s an overkill for this problem.
Why are you so opposed to creating a view on top of the mv?
Not possible unless you create a view on top of it
Thanks for all the input.