Today we are going to learn about modifications of Tablespace. In production Database, we do update tablespace on daily basis. Being a DBA it must be on our key tips. Right decision on correct time is more fruitful. Being DBA our brain must be active about database health on daily basis we must do a modification on database’s requirements.
Let’s have look at the steps. Simple and easy commands to add datafile in an existing tablespace.
Steps for How to add datafile in an existing tablespace.
ALTER TABLESPACE USERS ADD DATAFILE '/ora01/oracle/oradata/users_07.dbf' SIZE 2560M AUTOEXTEND ON NEXT 10M MAXSIZE 5000M;
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp