This content has been marked as final. Show 4 replies
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.
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