Re: dropping a tablespace

No it does not normally take 18 hours to drop a tablespace of less than 2G after you have deleted all the objects in it. You should check your alert log and dump directories for any entries/trace files that occurred during your drop.

In article <39299DE9.840D3252_at_fnac.net>, Christian Moenne-loccoz <christian.moenne-leccoz_at_fnac.net> wrote:
>I have tried to drop a tablespace (1.2 Go) which used to
 contain only
>index.
>
>I first drop all the index contained in it and then put it
 offline.
>
>However, it has took 18 hours to drop the table space.
>
>Is it normal ?
>
>C. Moenne-Loccoz
>
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!