carsca
9/5/2019 - 3:32 PM
How to solve Oracle "ORA-01652: unable to extend temp segment by N in tablespace X"
-- Identify data files (specifically, the file_name column)
SELECT * FROM dba_data_files;
ALTER TABLESPACE users ADD DATAFILE '<new data file full path>' SIZE 30G AUTOEXTEND ON NEXT 512K MAXSIZE 30G;