dynamic tablespaces creation script

// dynamic tablespaces creation script

// crtbs.sh

while read tbs

   do

   echo "CREATE SMALLFILE TABLESPACE "$tbs " DATAFILE

   '/oradata01/oracle/oradata/${ORACLE_SID}/$tbs.dbf' SIZE 10M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED

   LOGGING

   ONLINE

   EXTENT MANAGEMENT LOCAL  UNIFORM SIZE 10M

   SEGMENT SPACE MANAGEMENT AUTO

   ;"

   echo " "

   done< crtbs.dat

// crtbs.dat

MAX_DATA

MAX_INDX