In message <ZelBe.30663$8o.2507_at_fed1read03>, Andreas Sheriff
<spamcontrol_at_iion.com> writes
>"Ken" <ken_at_kk.int> wrote in message news:42d5d5e7$1_3_at_rain.i-cable.com...
>> Hi all,
>>
>> In Oracle 9iR2, the USER_OBJECTS view contains the STATUS column for ALL
>> objects including table. Does it mean it is possible to invalidate a
>> table?
>> If yes, how?
>>
>> Thx
>>
>>
>
>Ahmmm....
>No.
>
>You can drop, truncate, move, partition, index organize, alter, analyze,
>select from, delete from, update, insert, export, and do other neat little
>things with a table, but to my knowledge you cannot invalidate a table.
>
>Interesting question, though...
>
Would a table which contained an object type whose code wouldn't compile
be classed as invalid?
--
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Thu Jul 14 2005 - 09:08:27 CDT
