Hi,
Can any1 tell how to create multiple tablespace with each having single datafile in oracle 10g. I needed a script which should be able to take 3 parameters
a) Tablespace NAME
b) datafile location & name
c) Size of datafile
I have around some 100's of tablespace to be created . Any go ahead idea would really be appreciated. Some of the tabelspaces mentioned below
T_GARVAN_FY_1998_DATA (12 MB)
T_GARVAN_FY_1999_DATA (75 MB)
T_GARVAN_FY_2000_DATA (319 MB)
T_GARVAN_FY_2001_DATA (433 MB)
T_GARVAN_FY_2002_DATA (545 MB)
T_GARVAN_FY_2003_DATA (599 MB)
T_GARVAN_FY_2004_DATA (697 MB)
T_GARVAN_FY_2005_DATA (1833 MB)
T_GARVAN_FY_2006_DATA (2892 MB)
T_GARVAN_FY_2007_DATA (2836 MB)
T_GARVAN_FY_2008_DATA (2727 MB)
T_GARVAN_FY_2009_DATA (3038 MB)
T_GARVAN_FY_1998_IDX (3 MB)
T_GARVAN_FY_1999_IDX (19 MB)
T_GARVAN_FY_2000_IDX (75 MB)
T_GARVAN_FY_2001_IDX (98 MB)
T_GARVAN_FY_2002_IDX (127 MB)
T_GARVAN_FY_2003_IDX (136 MB)
T_GARVAN_FY_2004_IDX (158 MB)
T_GARVAN_FY_2005_IDX (384 MB)
T_GARVAN_FY_2006_IDX (596 MB)
T_GARVAN_FY_2007_IDX (577 MB)
T_GARVAN_FY_2008_IDX (547 MB)
T_GARVAN_FY_2009_IDX (3026 MB)