| lost tab table !!!!!!!!!!!!!!!! [message #56880] |
Fri, 02 May 2003 08:34  |
pavan kashyap
Messages: 6
Registered: March 2003
|
Junior Member |
|
|
hi,
i have lost my "tab" table
whenever i am trying to execute the query
select * from tab;
i am getting error as
ora-00942 table doesnot exist
even if i try to connect as system/manager
i am getting the same error
but, when i try to connect as sys as sysdba/change..
i am not getting any error........
is there any method to restore the table!!!!!!!!!
what should i do now..........
pavan
|
|
|
|
| Re: lost tab table !!!!!!!!!!!!!!!! [message #56882 is a reply to message #56880] |
Fri, 02 May 2003 10:40  |
jigar
Messages: 74
Registered: July 2002
|
Member |
|
|
In this case I guess Public Synonym for TAB has been dropped. So Connect as Sys/change_on...
and run the following command
create public synonym tab for tab
Now connect to scott and try
select * from tab;
Hope this will work
Regards,
Jigar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
