Oracle Error ORA-23635: MAINTAIN_TTS: tablespace(s) already exist(s) in target database.

Oracle Error Message

ORA-23635: MAINTAIN_TTS: tablespace(s) already exist(s) in target database.

Reason for the Error

The tablespaces were already in existence in the target database when the streams MAINTAIN_TTS APIs were called.”

Solution

Check whether you can drop the tablespaces to be maintained in the target database. If not, don’t use streams MAINTAIN_TTS APIs to setup streams. Check the Oracle documentation on how to setup streams.