What about checking to see if there are any processes
holding that table.
Also, check the referential integrity associated with
the table.
Another thing, see if you can re-create the table
using:
1.import/export as well as
2.create table tablename as select * from original
table.
G!
- "Bond, Mike" <CEMAB_at_cews.okc.disa.mil> wrote: >
SQL*Plus
>
> -----Original Message-----
> Sent: Wednesday, November 29, 2000 11:46 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> Are you trying the update in SQL*PLUS or an
> application like Visual Basic?
>
>
>
>
>
> "Bond, Mike" <CEMAB_at_cews.okc.disa.mil> on 11/29/2000
> 11:30:53 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
>
> Hi,
>
> I am having a problem updating a table. Using
> 8.1.6.1 on NT.
>
> I can update other tables owned by user 'BOB'.
>
> All tables were created via IMPORT. Table X
> 'should' be the same as the
> rest.
>
> But no one can update table X, owned by BOB.
>
> No errors are returned and no alert log entries are
> generated. SQL PLus
> simply hangs.
>
> It doesn't matter if it is 1 record to be updated or
> 30,000, the same result
> - nothing.
>
> BOB can select from this and other tables just fine.
>
> BOB can update other tables just fine.
>
> Ideas?
>
> Thanks,
>
> Mike
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Wed Nov 29 2000 - 13:56:15 CST
