I was asked to grant a privilege for a user to create only temporary tables. I was sure there’s no the specified grant such as

[php]

SQL>GRANT CREATE TEMPORARY TABLE to user1;

[/php]

After making a simple research, I saw the following thread where Justin Cave mentions that “However, if you grant the user the CREATE TABLE privilege but do not grant the user quota on any permanent tablespace, they would be unable to create permanent tables but should be able to create global temporary tables”

https://forums.oracle.com/forums/thread.jspa?threadID=2197364

A simple test proved the above quote:

[php]

SQL> create user user1 identified by user1;
User created.

SQL> grant connect to user1;
Grant succeeded.

SQL> grant create table to user1;
Grant succeeded.

SQL> conn user1/user1
Connected.

SQL> create table a (id number);
create table a (id number)
*
ERROR at line 1:
ORA-01950: no privileges on tablespace ‘USERS’
SQL> create global temporary table a (id number);
Table created.

SQL>

[/php]

After removing the RAC installation on the test server, I got the following error during the installation:

“The installer has detected the existence of 10g Oracle Clusterware on the remote node, —-, however, 10g Oracle Clusterware does not exist on the local node …

Although I run $CRS_HOME/install/rootdelete.sh, removed the $CRS_HOME and oraInventory folders and killed all running processes, it was throwing above mentioned error. After making some checks, I saw that /etc/oracle/ocr.loc file is still there. When removing that file, the error message disappeared. I was interested whether installation checks the file’s availability or its entry also, so created an empty file with the same name “ocr.loc” and tried the installation. Guess what? I got the error again. This means that Oracle looks only for the name of the file in the mentioned folder

In case you want to clear the failed RAC installation, check the following article:

http://blog.flimatech.com/2008/10/02/10g-rac-how-to-clean-up-after-a-failed-crs-install/

My friend and former ACE Director Porus Homi Havewala’s new book on Enterprise Manager 12c Cloud Control, will be available in September 2012 or earlier, perhaps the First EM 12c Cloud Control book in the world.

If you are interested in learning about the capabilities of Enterprise Manager 12c, please have a look. The book can be pre-ordered in advance. Electronic copies will be available too on publication.

http://www.packtpub.com/oracle-enterprise-manager-12c-cloud-control/book

Oracle Enterprise Manager 12c Cloud Control: Managing Data Center Chaos

I’m currently reviewing this book and must say that it’s very well written!