OCI-43570
Cannot drop tablespace 'string' because it contains notification table 'string' of directive 'string' whose base object is either a table located in a different tablespace or is a view
Cause
An attempt is being made to drop a tablespace containing a notification table whose base object is either a table located in another tablespace, or a view (which is not dropped by the DROP TABLESPACE statement).
Action
Drop the notification directive associated with the notification table before retrying the operation.