Re: Serialization issue on Oracle 10g

From: hxie <qixie1_at_gmail.com>
Date: 17 Aug 2006 09:54:38 -0700
Message-ID: <1155833678.922996.13580@h48g2000cwc.googlegroups.com>

After adding "purge" option, I don't get the serialization error anymore. I think adding purge option is equivalent to the drop statement in previous Oracle versions without recycle bin.

No, I am not dropping tables regularly. This is kind of part of a setup script I ran several several times in my test. I was curious about the "side effect" of recycle bin feature.

Thanks, Hans.
HansF wrote:
> On Wed, 16 Aug 2006 17:04:59 -0700, qixie1 wrote:
>
> >
> > 2.drop table test cascade constraints;
> > Table dropped.
> >
>
>
> Does it happen when you use the 'purge' option to the drop table command?
>
> Sideline comment: I hope you are not dropping regularily in a production
> environment ...
>
> --
> Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
> *** Feel free to correct me when I'm wrong!
> *** Top posting [replies] guarantees I won't respond.
Received on Thu Aug 17 2006 - 11:54:38 CDT