I want to create a new schema with the different name based on the objects of the old schema.
For that I created a new user and schema and then imported the dump file into it. But problem is
I am not getting the external table structure, except that other objects are coming into new schema.
Ex: Old schema name "ABC", new schema name "XYZ"
ABC contains 15 normal tables, 3 external table, 2 procedure, 2 functions and 2 packages.
I want to have all these objects in this new schema.
Help me regarding this matter.
Thanks in advance,