Re: Cant drop tablespace

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/07/01
Message-ID: <3t4hup$k1d_at_ixnews5.ix.netcom.com>#1/1


In <3t12ol$26u_at_engnews2.Eng.Sun.COM> flame3_at_East.Sun.COM (flame3) writes:
>
>Is this a Parallel Server environment?
>
>dml_locks must be greater than 0 in order to drop a tablespace.
>You must do a shutdown, modify the parameter in your parameter file
>and then startup and you should be able to drop the tablespace.
>
>If this is not a Parallel Server environment, then this does not
apply.

It's Oracle7 with the P.S. option, but we are not running parellel servers. It's a single database, with a single instance running. Is that what you're asking? (I'm still new to this stuff and am not really sure what P.S. does.)

-- 

><> Chuck Hamilton <><
><> chuckh_at_ix.netcom.com <><
Received on Sat Jul 01 1995 - 00:00:00 CEST

Original text of this message