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;

Comments