hello all,
we have oracle database 12c in our exalytic server.
the disk where we have installed database is full.
the on one schema "XYZ" from where i am pulling data in csv file.
but i get error of ORA-01114: IO error writing block to file string (block # string)
as disk has no more space
and also Temp tablespace is not releasing space as it getting bigger almost 120 GB
Please if there is workaround here
1. how to create new temp table space and assign it to this schema
or
2. how to shrink this Temp table space ?
regards,
Dattatray Mate