Created a temp table in Oracle
(create table t12 as select * from complex_view ...) to slice some data out of a complex and slow view.
The newly created table allowed update statements to be run, but not in-place/grid edit in the
TABLE/Data tab in SQL Developer. The cells did not allow data to be edited as if the new table is a view, so turned on SQL Developer logging as curiosity took over.
See for turning on SQL Developer logging:
http://method-r.com/forum/technical/293-how-to-enable-logging-in-sql-developer Logging tab indicated the following SQL being issued when Data table is clicked. Executing this SQL revealed that this table is not even present in the view below.
SQL> select column_name from all_updatable_columns A where TABLE_NAME = :OBJECT_NAME and owner = :OBJECT_OWNER and A.updatable = 'YES'
Renaming the table did not help either, creating another temp table from this table 't12', allowed grid edits.
Wondering what went wrong with Oracle at the time table was created, and also any means to force update the view if it is to occur again ...