Oracle: Tablespace Management

• Add datafile to normal tablespace

ALTER TABLESPACE DIAGRAM_INDEXES ADD DATAFILE '/dbfs/data5/DIAGRAM_INDEXES02.dbf' SIZE 200M REUSE AUTOEXTEND ON;

• Add datafile to temporarytablespace

ALTER TABLESPACE REPOS_TEMP ADD TEMPFILE '/dbfs/data5/REPOS_TEMP02' SIZE 200M REUSE AUTOEXTEND ON;
ALTER TABLESPACE REPOS_TEMP TEMPFILE OFFLINE;
ALTER TABLESPACE REPOS_TEMP TEMPFILE ONLINE;

Solaris show epoch time

Solaris show epoch time

nawk 'BEGIN{print srand()}'

Virtualbox: Installation on SUSE Linux

Problem:

ERROR: Kernel configuration is invalid.
         include/linux/autoconf.h or include/config/auto.conf are missing.
         Run 'make oldconfig && make prepare' on kernel src to fix it.

Solution:

# cd /usr/src/linux
# make menuconfig
# make
# /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules                                                                                                                          done
Recompiling VirtualBox kernel modules
Starting VirtualBox kernel modules 

or reinstall Virtualbox