7 Replies Latest reply: Feb 29, 2012 6:56 AM by 920826 RSS

    How to rename multiple tables at Once?

      I would like to know how to rename multiple tables in oracle at once? for example I have test, test_1, test_3 ETC... THE TABLES and I would like rename them with KC_test, KC_test_1, KC_test_3 etc....

      how do I do them at once rather than doing them one by one....

      Thank you.