trying to rtfm question

From: Robyn <robyn.sands_at_gmail.com>
Date: Fri, 21 Oct 2005 17:32:07 -0400
Message-ID: <ece8554c0510211432u60bd71b7pf376c189385a9c99@mail.gmail.com>

hey all,

Last week, by mistake, I ran an alter table move on a snapshot table and lo and behold, it actually worked. (Oracle 9.2.0.6 <http://9.2.0.6>) I thought I had read that this does not work and things will break etc. I've searched some of the docs, but haven't found a definitive 'go forth and move' statement for snapshot tables.

Is this acceptable in 9.2 and everyone knows this already? Shouldn't be done during a refresh I'm sure, but this option would make my life a lot easier. Or did I just got lucky on the one that worked?

Robyn

--

Robyn Anderson Sands
email: Robyn.Sands_at_SciAtl.com

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 21 2005 - 16:34:18 CDT