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