Friday, May 16, 2014

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;

Thursday, May 15, 2014

Friday, May 2, 2014

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