table view not avaialable for EDIT [message #674539] |
Thu, 31 January 2019 22:26 |
|
alimlim9
Messages: 4 Registered: January 2019
|
Junior Member |
|
|
hi,
I need edit script table view since we restore full backup rman that problem on edit script table view and the message error :
/* source of VIEW F55MAV is not available */
And when I check on dba_views or user_views record that is empty.
sqlplus : proddta@jdeora
password : xxxx
CREATE OR REPLACE VIEW PRODDTA.F55MAV AS
SELECT * FROM PRODDTA.F0101;
And we try to edit script table have error via pl/sql :
/* source of VIEW F55MAV is not available */
how to solve this case ? we have a lot of table view. need maintenace.
|
|
|