How to fix the Oracle error ORA-01352: tablespace given for Logminer spill does not exist?

In this post, you’ll learn more about the Oracle ErrorORA-01352: tablespace given for Logminer spill does not exist with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01352: tablespace given for Logminer spill does not exist

Reason for the Error ORA-01352: tablespace given for Logminer spill does not exist

The tablespace name given as the parameter to DBMS_LOGMNR_D.SET_TABLESPACE does not exist.

How to fix the Error ORA-01352: tablespace given for Logminer spill does not exist ?

You can fix this error in Oracle by following the below steps

Check spelling of the tablespace name. If spelling is correct verify that the named tablespace has already been created. DBMS_LOGMNR_D.SET_TABLESPACE does not create a tablespace.