Forbidden file and folder names on Windows

Here’s an interesting experiment. On a Windows desktop, right-click on the desktop, and create a new Folder. Then, try renaming it ‘aux’. Can’t do it, right? There are certain restricted words that cannot be used to name folders or files, even though they use regular characters. You can’t even name it, say, ‘aux.test’.

Create Duplicate DB with RMAN - Single Instance

You can use the RMAN DUPLICATE command to create a duplicate database from target database backups while still retaining the original target database. The duplicate database can be either identical to the original database or contain only a subset of the original tablespaces.

Using SPFile

SQL> create spfile from pfile='E:\oracle\product\10.2.0\admin\DUPDB\initDUPDB.ora';

File created.

SQL> shutdown immediate;
ORA-01507: database not mounted

One Concurrent User Per Schema

1- Set in init.ora or spfile.ora the parameter
SQL@ homedev> alter system set resource_limit=true;
System altered.

Windows Sysinternals

The Sysinternals Troubleshooting Utilities have been rolled up into a single Suite of tools. This file contains the individual troubleshooting tools and help files. It does not contain non-troubleshooting tools like the BSOD Screen Saver or NotMyFault.

How to Find Out Which Windows Process is Using a File

Ever come across the following messages and wondered how to find out what is using the file?

• Cannot delete file: Access is denied

User Level Security - Disable SQL*Plus and DDL Commands

Sqlplus_product_profile

A table that resides in the SYSTEM account. It provides product level security that supplements the user level security provided by SQL commands GRANT and REVOKE, and can be used with one's own applications as well as with other ORACLE products.

Using External Table

1- Create the CSV File on some location using excel
1,ABC,100
2,DEF,200
3,IJK,300