ATS Services System Engineer Interview Questions and Answers

Free up space by deleting unnecessary data or increasing table space size.

• Identify which table space is full

• Check if there are any unnecessary data that can be deleted

• Increase the size of the table space if necessary

• Consider partitioning the table to distribute data across multiple table spaces

Adding a datafile to a tablespace

• Use ALTER TABLESPACE statement to add datafile

• Ensure enough disk space is available

• Monitor tablespace usage regularly

• Example: ALTER TABLESPACE users ADD DATAFILE '/u01/app/oracle/oradata/db1/users02.dbf' SIZE 50M;

To add a datafile to a tablespace:

• Identify the tablespace where the datafile needs to be added

• Create a new datafile using the 'CREATE DATAFILE' command

• Add the new datafile to the tablespace using the 'ALTER TABLESPACE' command

• Ensure that the new datafile is of the correct size and location