This content has been marked as final. Show 4 replies
missymichi wrote:And how about you try to do so and tell us what is the outcome of that effort?
Is it possible to add a datafile to a tablespace while the database is running?
yes we always add datafile to tablespace when database is runing
ALTER TABLESPACE <Tablespace name> ADD DATAFILE <'path'> SIZE <size of datafile>;
Edited by: Asad99 on Apr 1, 2013 12:15 AM
Edited by: Asad99 on Apr 1, 2013 12:16 AM
Thank you for your answer.
Edited by: missymichi on Apr 1, 2013 12:21 AM
I've read over the documentations already, I think I was just unsure. TY.
Edited by: missymichi on Apr 1, 2013 12:44 AM