I got a requirement to delete sum data from a table.When am trying to delete the data from the table I got an error like below
"ORA-01732: data manipulation operation not legal on this view".
When I checked for that it is a materialised view and the table is the one which is created with the materialised view.(both mview and table with same name) So i thought of deleting the mview and to perform the operations on the table and to recreate the view again. But when I dropped the view ,I am not able to find the table now. When Am trying to recreate the mview, I am getting error like TNS entry could not be found.I have added it to TNS ora.But issue still persists the same.Before dropping I have taken DDL of it .Kindly let me know how to get the table back
I may be wrong but, it looks like your MView SQL is incomplete.
However, when you're using database links, you should take note of the connection string used for the dblink, normally a TNS alias, this alias is the one the Oracle Server process sees during DB initialization.
Check the information on your dba_db_links view for all the DBLinks involved on your query, check that if a TNS alias was used (in host field), it exists on the tnsnames.ora file on the server, if you configure the TNS_ADMIN environment variable on the server, check the file on that route, if not, check in $ORACLE_HOME/network/admin, they should be the same.