Fix ORA-00972 error at test_rename_table_with_prefix_and_suffix

backport pull request#5837 to 3-2-stable
Merge pull request #9471 from yahonda/5837_32-stable

Fix ORA-00972 error at test_rename_table_with_prefix_and_suffix
Revert "Skip test_remove_column_with_array_as_an_argument_is_deprecated with Oracle adapter."

This reverts commit 7544c7a9f290a3ea25099ae38d52795458391785.

Oracle enhanced adapter is supporting remove_column with Array.
Merge pull request #9472 from yahonda/revert_7544c7a9

Revert "Skip test_remove_column_with_array_as_an_argument_is_deprecated ...