search

oravirt / ansible-oracle-modules

Oracle modules for Ansible
MIT License
214 stars 161 forks source link

oracle_tablespace.py - line 663, in drop_tablespace - NameError: global name 'module' is not defined. #155

Open ReinerNippes opened 4 years ago

ReinerNippes commented 4 years ago

We get an Error: global name 'module' is not defined in line 663

https://github.com/oravirt/ansible-oracle-modules/blob/a044b47fa76bd7d3136baae8353553bc79797b1d/oracle_tablespace#L663

When we try to drop the tablespace with an SQL command we get the following error message:

SQL> drop tablespace indexes including contents and datafiles;
drop tablespace indexes including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

How to avoid the python error message. To drop the tablespace is not the problem.