Alter Tablespace Add Datafile
Example, How to add datafile in existing table.
ALTER TABLESPACE
USERS
ADD DATAFILE
‘/ora01/oracle/oradata/users_01.dbf’
SIZE 2560M AUTOEXTEND ON NEXT 10M MAXSIZE 5000M;
Example, How to add datafile in existing table.
ALTER TABLESPACE
USERS
ADD DATAFILE
‘/ora01/oracle/oradata/users_01.dbf’
SIZE 2560M AUTOEXTEND ON NEXT 10M MAXSIZE 5000M;