Oracle VirtualBox VMs for Developers -- as VirtualBox can be easily installed on desktops
It's clear that you cannot index the ROWID :
SQL> connect hemant/hemant
SQL> create table obj_list_tbl as select * from dba_objects;
SQL> select rowid from obj_list_tbl where object_id between 1001 and 1005;
If the voting disk exists on ASM you cannot add CFS votedisks. You must replace your ASM voting disk with the CFS votedisks. Apparently, both location types cannot be used concurrently ?
[root@node1 crs]# crsctl query css votedisk
## STATE File Universal Id File Name Disk group
Following up on my previous blog, I show a Tablespace Restore and Recovery for a NOARCHIVELOG mode database.
SQL> connect / as sysdba
SQL> archive log list
Normally, a CTAS (CREATE TABLE ... AS SELECT ....) operation generates redo and logging. However, if the database is in NOARCHIVELOG mode, Oracle silently converts it to a NOLOGGING operation.