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, ‘+ […]

Oracle Database Import

Using power of Oracle Data Pump If you haven’t used oracle Data Pump and still using old IMP / EXP, it’s time for change. It’s very simple to use and at least 10 times faster (my experience) than IMP/EXP. Simple steps to configure 1. CREATE OR REPLACE DIRECTORY EXPIMP AS ‘{path}’; 2. GRANT READ, WRITE […]