This content has been marked as final. Show 4 replies
This may be Start with clause = 1 for assigned varaible in (select org_id from T_USER_ORG_MAPPING where upper(user_id)= upper('Administrator') )
Same Conect By query workds fine in 9i but not in 10g - Please help
Edited by: user2361373 on May 5, 2011 1:34 AM
PhoenixBai wrote:This has got to be frustrating! Indexes (bitmap or btree) should not influence query parsing errors :(
Futher findings about this case is that it works perfectly fine when I don`t create any bitmap indexes for the fact tables.
Once I create bitmap indexes for the fact table, it throws this annoying ORA-01788 errors.
You say the same code workes in dev. Something is different:
* are you certain the code is the same in both places?
* initialization/session parameters?
* database patches level?
Query transformation gone bad? Try using the NO_QUERY_TRANSFORMATION hint to see if the error recurs (warning: this may affect performance)