Adding Data Files automatically

[pando]

then it´s a danger!

[jmodic]

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.

[pando]

that´s fine then =)

[julian]

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;