Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Use of dummy column in Multi Column datastore

user13780543Feb 2 2011 — edited Feb 4 2011
Hi,

I want to create a multi column datasore with 3 columns and all are from different tables. So i created a materialized view and created a text index on it.

My question is do i need to create a dummy column in the materialized view to sync text index or will it be able to generate the tokens when a DML operaition made on the view without dummy column.

Also what would be the alternative to specify the column name during index creation, if we dont have dummy column.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2011
Added on Feb 2 2011
#database-key-features, #text
3 comments
843 views