Re: Drop user takes too long

From: Eric Nguyen <nguyenq_at_supernet.ca>
Date: Sun, 23 Dec 2001 15:48:24 -0500
Message-ID: <egrV7.11150$xB4.1621884_at_brie.direct.ca>

You might be right Chao_ping, but for now I have no choice , my tablespace is dictionary managed.
Thanks

"chao_ping" <chao_ping_at_163.com> wrote in message news:3c257576$1_at_usenetgateway.com...
> I think it is mainly becauase oracle update system tables about the
> dictionary records: the freeup extents, the tables deleted, and so on.
> If u are using locally managed tablespace, maybe it will be much faster?
> I didnot test it.Just guess.
>
>
>
> --
> an oracle fan,
> an oracle beginner
>
> Posted via dBforums
> http://dbforums.com
>
Received on Sun Dec 23 2001 - 21:48:24 CET

This message: [ Message body ]
Next message: Robert Malikian: "Re: How can i select random rows from a table in oracle 8i?"
Maybe in reply to: Eric Nguyen: "Drop user takes too long"
In reply to chao_ping: "Re: Drop user takes too long"
Next in thread: Leader: "Re: How can i select random rows from a table in oracle 8i?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message