Recreating undo tablespace in oracle database
Many a time situation comes, when undo tablespace becomes very big in size and due to space crunch , we need to recreate undo tablespace with appropriate size & drop old one. This post provides u simple steps to perform this activity. SQL> SHOW PARAMETER UNDO NAME TYPE VALUE ———————————— […]
