Author: Maurice Ruckman

Posted on

Fix the ORA-00904: ORA_ROWSCN

Fix the ORA-00904: ORA_ROWSCN: invalid identifier error in SQLDeveloper with a few easy steps

Refer: https://www.igorkromin.net/index.php/2017/08/06/fix-the-ora-00904-ora_rowscn-invalid-identifier-error-in-sqldeveloper-with-a-few-easy-steps/

Fix

Turns out fixing this problem is easy. Open up the SQL Developer Preferences, then navigate to Database > Object Viewer. Untick the box that says Use ORA_ROWSCN for DataEditor insert and update statements.

Posted on

Sharing folders in VMWare

Refer: https://kb.vmware.com/s/article/74650

Create the file /etc/systemd/system/mnt-hgfs.mount with this content:

sudo touch /etc/systemd/system/mnt-hgfs.mount
sudo gedit /etc/systemd/system/mnt-hgfs.mount
[Unit]
Description=VMware mount for hgfs
DefaultDependencies=no
Before=umount.target
ConditionVirtualization=vmware
After=sys-fs-fuse-connections.mount

[Mount]
What=vmhgfs-fuse
Where=/mnt/hgfs
Type=fuse
Options=default_permissions,allow_other

[Install]
WantedBy=multi-user.target

Create the file /etc/modules-load.d/open-vm-tools.conf with this content:

sudo touch /etc/modules-load.d/open-vm-tools.conf
sudo gedit /etc/modules-load.d/open-vm-tools.conf

If the file already exists, add that line to the file.

fuse

Enable the system service with the command:

sudo systemctl enable mnt-hgfs.mount

This will make sure the hgfs fdirectory will be mounted after a reboot.

Make sure the 'fuse' module is loaded:

sudo modprobe -v fuse

In Workstation or Fusion, enable "Shared Folders" in "Virtual Machine Settings" > "Options", and set the folders to be shared.
The shared folders should appear in the directory /mnt/hgfs. If that is not the case, start the service with:

sudo systemctl start mnt-hgfs.mount

or

reboot