Wednesday, March 9, 2016

Slow start for CISCO VPN Client


Pretty much detailed here http://superuser.com/questions/607090/cisco-vpn-client-hangs-at-opening-cert-store, and it was because of Fiddler certs.


The following setting works for me in Fiddler v2.6.2.0


Canceling Stuck Printer Jobs in Windows 7

If you are using a print server, then look under C:\Windows\System32\spool\SERVERS\ directory. If not, then follow this thread: https://social.technet.microsoft.com/Forums/windowsserver/en-US/b560cd2b-43b3-402c-a141-0c764963862d/system32-spool-printers-folder?forum=winserverprint

Monday, February 22, 2016

Not Being Able To Do Grid Edits For Tables in SQL Developer

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 ...