Thank you Kaniz

Basically, it is required to update the location for each data objects in the old catalog. 

The external location in the following instruction should be removed as the objects are altered rather than the external location. 

• For example:ALTER EXTERNAL LOCATION catalog1.schema1.table1 SET LOCATION 'storage2/path/to/table1' FORCE;