0 Replies Latest reply: Sep 28, 2010 4:00 AM by 636586 RSS

    Creation of new schema based on old schema

    636586
      Hi,

      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,

      Narayan