> 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 - 10:25:04 CST
