ORA-00959 tablespace 'string' does not exist

Cause: A statement specified the name of a tablespace that does not exist.

Action: Enter the name of an existing tablespace. For a list of tablespace names, query the data dictionary.


I am wondering you are still using conventional OS hotbackups though you are runnning on 9i. RMAN is the way to go.