This content has been marked as final. Show 4 replies
did you find a solution to this? I am having the same issue.
this error occurs when an attempt is made to drop a TEMPFILE being used by online users.
Check whether the tempfile is being used by users.
SQL> SELECT s.sid, s.username, s.status, u.tablespace, u.segfile#, u.contents, u.extents, u.blocks
FROM v$session s, v$sort_usage u
ORDER BY u.tablespace, u.segfile#, u.segblk#, u.blocks;
select sid, username, osuser, program, machine from v$session where sid in
(<sid returned from above query>);
Kill the sessions referenced in the above query and try your drop action again.
Drop temp datafiles before running rconfig
Then retry rconfig, it worked for me, after all add temp datafiles to temp tablespace
Hello, thanks for your help, I resolve the issue.
Before run the rconfig, I need set in the original Database the next parameter:
sort_area_size = 900000000
workarea_size_policy = MANUAL
and next, the rconfig...work ok.
Edited by: Pek on Oct 17, 2012 6:15 AM