Re: Is it possible to drop temp tables owned by SYS without restart the database?

On 12 Dec 1997 02:23:03 GMT, dshi_at_magpage.com (David Shi) wrote:

>Some times when a job dead, Oracle don't drop those temp tables (table
>names like 2.12 etc), I usually follows a book says, just restart the
>database, but this is very inconvenient, is there another way to do
>that? I tryed something like "drop table 2.12;" which won't work.
>
>Thanks.

They're not really tables, they're temporary segments. I've had the same problem with numerous versions of Oracle. SMON is supposed to clean them up but it apparanently has a bug in it. They fix it in one release, and it reappears in the next.

If you find an answer, let me know. I'm constantly having the same problem on HP-UX and occasionally on IRIX too. The only solution I know of is to bounce the instance.

--
Chuck Hamilton
chuckh_at_dvol.com

"Therefore the Lord Himself will give you a sign:
Behold, a virgin will be with child, and bear a son,
and she will call His name Immanuel." (Isa 7:14 NASB)