Adding a data file to a tablespace in Enterprise Manager
588213Feb 11 2010 — edited Feb 15 2010Currently I have a tablespace called Data which has a block size of 8KB. Small file type.
It contains 1 data file max size 32GB. Autoextend is switched on. Currently we have used 18GB. I anticpate we will reach 32GB in approx 4 months.
As I am a novice with Oracle, I would like to confirm what I want to do is correct before making any changes:
The current datafile is called ifsapp_data.dbf
Once this file reaches 28GB for example, I would like to create a new data file via enterprise manager in the same tablespace.
I intend to call the new data file ifsapp._data1.dbf Size will be 32GB same as the current file with autoextend switched.
Once the current file then becomes completely full and cannot extend any further, oracle will automatically start saving data to the newly created data file. (This is my understanding, is it correct?)
As both data files will then be on line, any data in our original file and the new data file will still be accessible.
Besides creating this new data file, is there any other changes I would need to do in oracle?
Thanks and regards,
Christine