Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is it possible to drop temp tables owned by SYS without restart the database?

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

From: Sanjay Mathew <alsm1_at_micro.lucent.com>
Date: 1997/12/12
Message-ID: <3491B067.B34@micro.lucent.com>#1/1

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.

Try drop table "2.12;";

-- 
Sanjay T. Mathew
Certified Oracle DBA
Lucent Technologies,
555 Union BLVD,
Allentown 
PA 18103

Phone Number  Office        610 712 5967
Received on Fri Dec 12 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US