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

Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Dropping a tablespace

Re[2]: Dropping a tablespace

From: Lee Robertson <Lee_Robertson_at_QSP.CO.UK>
Date: Wed, 6 Mar 1996 11:19:46 -0500
Message-Id: <9603051646.AA15616@alice.jcc.com>

     Top Man Daniel, that worked a treat.

     Many Thanks

     Lee

     Lee_Robertson_at_qsp.co.uk

______________________________ Reply Separator _________________________________
Subject: Re: Dropping a tablespace
Author: Daniel Simson <dasimson_at_DAVIDSON.EDU> at internet Date: 06/03/96 14:56

> I recently had to create a temporary tablespace to enable me to create
> an index on a large table. I created it with no problems and then
> altered the user to pick up the new tablespace as his temporary one. I
> created the index and then altered the user back again. When I
> attempted to drop the tablespace it either a) just sat there for
> absolutely ages or b) came back with an ORA-3113 end-of-file on
> communication channel. Does anybody have a solution or have
> encountered similar problems ?
>
> We are running Oracle 7.0.16 on Sun/Solaris 2.4
>
> TIA
>
> Lee
>
> Lee_Robertson_at_qsp.co.uk
>

I had a similar problem. The solution that was given to me was to comment out the db_writers parameter in my init.ora file. There seems to be a bug that will not allow you to drop a tablespace when there are multiple db_writers active.

--

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-                   =-=-=-=-=-=-=-=-=-=-=-=-=-
= Dan Simson                     =                   = HP 9000                =
= Database Administrator         =                   = HP Unix 9.04           =
= Davidson  College              =                   = Oracle 7.1.4           =
= E-Mail: dasimson_at_davidson.edu  =                   =-=-=-=-=-=-=-=-=-=-=-=-=-
= Phone : 704-892-2215           =
= Fax   : 704-892-2670           =

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Tue Mar 05 1996 - 11:46:12 CST

Original text of this message

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