Home » SQL & PL/SQL » Client Tools » table view not avaialable for EDIT (Oracle 12.1.0.2.0)
table view not avaialable for EDIT [message #674539] Thu, 31 January 2019 22:26 Go to previous message
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.

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Unable to connect Oracle Database using SQL Developer
Next Topic: Blank rows in spooled txt output file using SQL developer
Goto Forum:
  


Current Time: Sun Jan 19 15:45:21 CST 2020