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!

Oracle Warehouse Builder

271736Jul 6 2004 — edited Jul 16 2004

Hello,

I posted this in the Database-General forum but I thought I might get a reply in this forum...

I am using Oracle Warehouse Builder 9.2 against an Oracle 9i database.

I am trying to access materialized views as the source for my target tables. When I try to import these (go to the Database name, right-click and select 'Import')Materialized views are not one of my options under Object Type. The materialized views do not show up under Table or View in the 'Next' screen either (Object Selection, list of Available Options). Can someone tell me if we can use Materialized views as Source objects? It seems silly that an Oracle tool like OWB would not let users access an Oracle Object like MV so I hope I'm doing something stupid and it's not a limitation of the tool...

Thanks in advance,

Mike

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2004

Added on Jul 6 2004

#data-warehousing, #olap

1 comment

246 views