Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Monday, February 28, 2011

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

Sunday, February 27, 2011

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

Monday, February 14, 2011

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.

Monday, February 07, 2011

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.

Sunday, February 06, 2011

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


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.

Saturday, February 05, 2011

Using External Table

1- Create the CSV File on some location using excel