Table disappeared [message #335075] |
Sun, 20 July 2008 16:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandman42
Messages: 14 Registered: June 2007
|
Junior Member |
|
|
Hi,
I'm experiencing a strange problem: one table is disappeared.
I have an Oracle 9i2 installation on a six-disk RAID5 installation, with three instances, each one on a different logical disk. Every instance has a user who is the owner of some tables used for user authentication by an application that uses data in the instances.
In two of the three instances, the same table is disappeared. I'm using "disappeared" because the table has not really been dropped: if I do a select * from mytable, it goes timeout, if I do a select table_name from user_tables, it's not in the list, but if I try to restore it from a dump I have, imp.exe says the table already exists!
Therefore, I'm quite baffled from this, and I'm asking for help just to understand:
1) What had happened to this table? It's a table that's usually read, and very rarely written
2) Why had happened this
3) What can I do to solve the problem? Maybe can I try to dump the tablespace, delete and recreate it, and then import the dump? This would maybe solve the problem, but doesn't answer to the question why, so maybe it may happen again.
Can you help me please (at least help me to point in the right direction?)
Thanks in advance
Francesco
|
|
|
|
Re: Table disappeared [message #335098 is a reply to message #335076] |
Mon, 21 July 2008 00:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandman42
Messages: 14 Registered: June 2007
|
Junior Member |
|
|
anacedent wrote on Sun, 20 July 2008 16:47 | [url]Does the application continue to work normally?
|
No, it doesn't.
BTW system is Oracle 9i2 9.2.0.6 running on Windows 2003 Server Std. Ed.
|
|
|
|
Re: Table disappeared [message #335104 is a reply to message #335098] |
Mon, 21 July 2008 00:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandman42
Messages: 14 Registered: June 2007
|
Junior Member |
|
|
What I wrote before, i.e.:
Quote: | if I do a select * from mytable, it goes timeout, if I do a select table_name from user_tables, it's not in the list, but if I try to restore it from a dump I have, imp.exe says the table already exists!
|
Particulary, since this table contains authentication data for the application users, users can not log in the application anymore, but this is not a problem itself, since I think I can drop the user tablespace, recreate it and restore data from a dump I Have
Problems are:
1) What could have happened? I could understand if, due to some application bugs, data written into table is not what it's expected to be, but leaving the table is this state is something that I don't think it's an application fault.
2) Except for the mentioned delete tablespace and restore, is there something else I can do?
Ciao
|
|
|
|