Home » RDBMS Server » Server Administration » Table disappeared (Oracle 9i2 v. 9.2.0.6, Win2003 server Std.)
Table disappeared [message #335075] Sun, 20 July 2008 16:17 Go to next message
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 #335076 is a reply to message #335075] Sun, 20 July 2008 16:47 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Does the application continue to work normally?
Re: Table disappeared [message #335098 is a reply to message #335076] Mon, 21 July 2008 00:21 Go to previous messageGo to next message
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 #335100 is a reply to message #335075] Mon, 21 July 2008 00:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
What changed?
Re: Table disappeared [message #335104 is a reply to message #335098] Mon, 21 July 2008 00:48 Go to previous messageGo to next message
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
Re: Table disappeared [message #335893 is a reply to message #335104] Thu, 24 July 2008 01:59 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Can you write your table name in double cots

like ....Very Happy
select * from "sunil_table";

Wink
Previous Topic: Auto Start Oracle 10G on windows 2003 Server
Next Topic: views
Goto Forum:
  


Current Time: Fri Dec 09 05:48:28 CST 2016

Total time taken to generate the page: 0.08251 seconds