From daemon Tue Mar  5 09:55:33 1996
Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM)
 id AA09741; Tue, 5 Mar 1996 09:55:26 -0500
Message-Id: <9603051455.AA09741@alice.jcc.com>
Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3)
   with BSMTP id 4071; Wed, 06 Mar 96 09:24:41 EST
Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 4259; Wed, 6 Mar 1996 09:22:40 -0500
Date: Wed, 6 Mar 1996 09:22:40 -0500
Reply-To: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
Sender: "ORACLE database mailing list." <ORACLE-L@ccvm.sunysb.edu>
From: Lee Robertson <Lee_Robertson@QSP.CO.UK>
Subject:      Dropping a tablespace
X-To:         oracle-l@CCVM.SUNYSB.EDU
To: Multiple recipients of list ORACLE-L <ORACLE-L@ccvm.sunysb.edu>
X-Orig-Date: Wed, 6 Mar 1996 14:21:38 +0100

     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@qsp.co.uk