Adding datafile to tablespace via OEM12c

Adding datafile to tablespace via OEM12c

To add a datafile to tablespace follow these steps:

1.       In Cloud Control, Search the DB target and go to DB Home page, from the Administration menu click the Tablespaces as highlighted below.

2.       On Next Window, select the tablespace where we need to add datafile and select Add datafile in Action dropdown box and Click Go as highlighted below.

3.       On Next Window, Now Select Correct Disk Group name and storage type datafile size and autoextend option as per our epsilon standards, crosscheck the details before click Ok.

4.       And also check the SQL which going to execute for this datafile addition by clicking show SQL button,

5.       Return to previous Window and Click Ok to add datafile. Once you Click Ok, the datafile will add and the status message will display after successfully addition like below.

6.       We can click the tablespace name and we can check the newly added datafile details as below and repeat the same steps to add more datafile to get the tablespace usage under the threshold value.

7.       Below we can find the tablespace current usage after adding datafile to it.