Add UNDO tablespace autoextend tips

Hello,   I need to alter by UNDO tablespace tpo make it autoextend on.  How do I change my UNDO tablespace to allow for autoextend?

Show Undo Tablespace in Oracle Database scripts ;

CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE 
'+ XDSLBAUNDATA' SIZE 33554416K AUTOEXTEND OFF,
'+ XDSLBAUNDATA' SIZE 33554416K AUTOEXTEND OFF,
'+ XDSLBAUNDATA' SIZE 33554416K AUTOEXTEND OFF,
'+ XDSLBAUNDATA' SIZE 33554416K AUTOEXTEND OFF,
'+ XDSLBAUNDATA' SIZE 20G AUTOEXTEND OFF,
'+ XDSLBAUNDATA' SIZE 20G AUTOEXTEND OFF
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK OPEN;

Or connect to oracle database as sqlplus / as sysdba than run this scripts.
output :

undotbs

Here is the syntax to alter your UNDO tablespace to add a datafile with the autoextend option:

ALTER TABLESPACE  UNDOTBS2 ADD DATAFILE
‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF,
‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF,
‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF,
‘+ XDSLBAUNDATA’ SIZE 33554416K AUTOEXTEND OFF,
‘+ XDSLBAUNDATA’ SIZE 20G AUTOEXTEND OFF,
‘+ XDSLBAUNDATA’ SIZE 20G AUTOEXTEND OFF

Output like this > Tablespace altered.

have a good day.

Hits: 5

Leave a Reply

Your email address will not be published. Required fields are marked *