ADDING DATAFILE TO TABLESPACE IN Filesystem DB:
==========================================
ALTER TABLESPACE users ADD DATAFILE '/u01/oracle/oradata/users_02.dbf' size 100m;
ADDING DATAFILE TO TABLESPACE IN ASM RAC:
========================================
alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G;
alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;
alter tablespace AAAPP add datafile '+ORA_DB' size 1G AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;
alter tablespace GPAPP add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;
RESIZE DATAFILE IN TABLESPACE (ASM RAC):
=====================================
alter database datafile '+ORA_DB/hrprd/datafile/gpapp.552.9454654566' resize 5G;
==========================================
ALTER TABLESPACE users ADD DATAFILE '/u01/oracle/oradata/users_02.dbf' size 100m;
ADDING DATAFILE TO TABLESPACE IN ASM RAC:
========================================
alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G;
alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;
alter tablespace AAAPP add datafile '+ORA_DB' size 1G AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;
alter tablespace GPAPP add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;
RESIZE DATAFILE IN TABLESPACE (ASM RAC):
=====================================
alter database datafile '+ORA_DB/hrprd/datafile/gpapp.552.9454654566' resize 5G;
No comments:
Post a Comment