Assignment 2

Create a tablespace sha_tb01.

Verifying the tablespace

Create a datafile named as shadb01.dbf in '/opt/stage/shadb01.dbf' with size 2GB

How to resize datafile shadb01.dbf to 4G

How to check list of datafiles and tablespaces in database.

List all datafiles

List all tablespaces

Command to check tablespace utilization (free, used)

NOT DONE

How will you check the number of datafile & its size which belongs to spcific tablespace.

How to Drop non default datafile?

TEMP TABLESPACE:

Create temp datafile sha_tmp with 200M size.

Check number of temp datafiles with size.

Command to check temp tablespace Utilization (free, tused)

How to Drop temp (Default) datafile?

UNDO TABLESPACE:

How to add undo datafile with size 1GB?

How to check undo retention parameter at Database level?

How to increase undo retention polity for 1Day?

Commands to check undo tablespace utilization.

How to Drop undo datafile?