Re: ora -03232

Hi

I too got ORA-03232 but to my utter surprise i found that the Query Fails with User A , BUT goes thru with User B when User B accesses the same query as UserA.tablename (after granting Access Priviliges). The Tablespace related was TEMP tablespace with 1.5 G of freespace (Two contiguous space of 1024M for one data file and 512M in another datafile). The temporary tablespace was the same for both the users.

Environment Background : The tables were getting analyzed as "ANALYZE TABLE ... ESTIMATE STATISTICS". Solution: When I used the hint Select /*+ RULE */ to force Rule based Optimising , the error didnot arise. init.ora had CHOOSE.

The problem may not appear if one does ANALYZE TABLE COMPUTE STATISTICS.

--
Posted via dBforums
http://dbforums.com