Adding Data Files automatically

then it´s a danger!

Quote:

---

Originally posted by pando
then it´s a danger!

---

There is no danger, because there is no such feature as adding datafiles to a tablespace automaticaly, not even in 9i.

that´s fine then =)

Even in 9i you first have to determine where to make the files:

alter system set DB_CREATE_FILE_DEST='/oradata/9i/files';

Only then you can add files:

alter tablespace DBA_SUPPORT add datafile;