Database DataWarehousing (MOSC)

MOSC Banner

olap issue

edited May 31, 2011 9:01AM in Database DataWarehousing (MOSC) 2 commentsAnswered
hi All,

i created a new db in 10.2.0.5 in a linux enviroment. after doing in export from source 10.2.0.4 and import to my new db. i saw some many invalid objects. i did the same query below in my new db for it does not return any rows. what is the status say when :no script" here?

here are some of the invalid objects i got during the import..and i cant compile further. Is due to the fact that olap is not install.? what are the steps to install olap in my new db can you guys show me?

SQL> select comp_name,version,status from dba_registry where comp_name like '%OL

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center