Monday 17 July 2017

how to add datafile to tablespace

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;

No comments:

Post a Comment

Jenkins Startup and Configuration

Steps to setup jenkins on ubuntu:- -After installation. check the jenkins services running on not on the server. sudo service jenk...