hello all,
I've used up all my table space for a database, consisting of the following files.
users01.dbf (32Gb)
users02.dbf (32Gb)
users02.dbf (32Gb)
I can add another file to the table space by issuing the following...
ALTER TABLESPACE USERS ADD DATAFILE '/u02/oradata/dbname/users04.dbf' SIZE 32G autoextend on next 50m maxsize 60G;
which will add a new file with autogrowth up to 60Gb.
My question is - can I just add autoextend to the existing files, rather then adding a new one?
ALTER DATABASE DATAFILE '/u02/oradata/dbname/users01.dbf' resize 45GM autoextend on next 50m maxsize 60G;
ALTER DATABASE DATAFILE '/u02/oradata/dbname/users02.dbf' resize 45GM autoextend on next 50m maxsize 60G;
ALTER DATABASE DATAFILE '/u02/oradata/dbname/users03.dbf' resize 45GM autoextend on next 50m maxsize 60G;
if this is wrong, what is the correct format to perform this?
Many thanks in advance.
Dave