Tablespaces Info for upgrading to 18c

To help you keep track of your tablespace allocations, the following AUTOEXTEND tablespaces are expected to successfully EXTEND during the upgrade process.

Tablespace Size       Min Size For Upgrade
---------- ---------- -----------
SYSAUX     490 MB     718 MB
SYSTEM     750 MB     1194 MB
TEMP       54 MB      150 MB
UNDOTBS1   85 MB      446 MB

Minimum tablespace sizes for upgrade are estimates.

Only Solution is to extend the tablespace.

SQL> alter database datafile 1 resize 1200M;

Database altered.

SQL> alter database datafile 2 resize 800M;

Database altered.

SQL> alter database datafile 3 resize 500M;

Database altered.

SQL> alter database datafile 4 resize 500M;

Database altered.

SQL> alter database tempfile 1 resize 200M;

Database altered.

SQL>

Stay tuned for more articles on Oracle 18c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp