Assignment 4 ‐‐‐Temp and Undo tablespace - eshan3101/DataBase-Architech GitHub Wiki

1.Create a tablespace sha_tb01

  1. How to resize datafile shadb01.dbf to 4GB?
  1. How to check the list of datafiles and tablespaces in the database?
  1. Command to check tablespace utilization (% Free and % Used).

5.How will you check the number of datafiles and their sizes belonging to a specific tablespace?

  1. How to drop a non-default tablespace?

7.Create a temporary tablespace sha_tmp with 200MB size.

  1. Check the number of temp datafiles with size.
  1. Command to check temporary tablespace utilization (% Free and % Used).
  1. How to drop a default temporary tablespace?
  1. How to add an undo datafile with size 1GB?
  1. How to check the Undo Retention parameter at the database level?
  1. How to increase Undo Retention policy for 1 day?
  1. Commands to check Undo Tablespace utilization.
  1. How to drop an undo datafile?