Hello @Rajasaiharish ,

The above is expected by design.ALTER TABLE RENAME TO updates only the table name in the catalog.The underlying Delta log + data files remain in the original storage location

Try setting the location to a new location 

ALTER TABLE table_name SET LOCATION path_to_the_new_location

 or drop and recreate or run a CRTAS as a solution