Malcolm's Tech Tips

Tips and tricks explained.

Fixing slow Save As problems.

Open RegEdit and go to :
HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\ShellIconOverlayIdentifiers

and rename it to something like

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\ShellIconOverlayIdentifiersOLD

Run the “catexp.sql” as SYS. The file is located in $ORACLE_HOME/rdbms/admin.

SQL> @?/rdbms/admin/catexp.sql


SQL> sp_dropserver 'oldservername';
SQL> sp_addserver 'newservername';

don’t run in same batch.
the two statements must be executed separately.

Type the following command for just this listing,
$ ls --color=none
Or remove the alias with the unalias command:
$ unalias ls

Moving a database to a new oracle home, owned by a different user and running a newer version.

NOTE : This is how is worked in my environment. It might not work the same in your environment. This is meant as a guide only.