ADDING DATAFILE TO TABLESPACE IN ASM

Datafile scripts :

CREATE TABLESPACE USERS DATAFILE
‘+DATA’ SIZE 33511680K AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED,
‘+DATA’ SIZE 32724M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 33554416K AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 30040M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 1010M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 910M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 910M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 910M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 910M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 910M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 910M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED,
‘+DATA’ SIZE 910M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

Add datafile to tablespace  ASM diskgroup  DATAGROUP.

Scripts sysntax:

ALTER TABLESPACE Table_Space_Name ADD DATAFILE ‘ASM_DISK_GROUP’ SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED

Example :

SQL> ALTER TABLESPACE USERS  ADD DATAFILE
‘+DATA’ SIZE 33511680K AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED;

Hits: 1

Leave a Reply

Your email address will not be published. Required fields are marked *