Oracle bug

I promise will come back to remote partitioned table later.
I think I hit an Oracle bug.
When I tried to drop tablespace including contents and datafiles, Oracle returned successfully. But throws exception in the alert.log that Oracle couldn’t remove the underlying file on the OS. This happens only on windows and it seems like some other processes have locked the datafiles to be dropped. Oracle should throw an exception with an error code.
But even if Oracle does return an error code instead of silently throwing up in the alert.log, I am still puzzled by couldn’t remove the datafile by OS command. This is random that it’s difficult to reproduce and file a tar.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: