Some importants notes from Oracle’s documentation: – “… you cannot rename or drop the SYSTEM tablespace or take it offline.” – “As for the SYSTEM tablespace, management of the SYSAUX tablespace requires a higher level of security and you cannot rename or drop it.” Locally Managed Tablespace : Define through the command EXTENT MANAGEMENT LOCAL where you can: – Choose two types of extent management: AUTOALLOCATE: (default) Database manage extents. CREATE TABLESPACE tech01 DATAFILE ‘/u01/app/oracle/oradata/DB/tech01.dbf’ SIZE 100M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ; UNIFORM: You define the size on command…