Can we copy all of the objects in one schema over to another schema name in oracle?what i mean is duplicating all of the objects (tables, indexes, views, MQTs, functions, etc) from one schema to another (in the same or different tablespace) with or without the data.
Is there any other way or workaround to do this,without using import and export utilities provided by oracle?
I know that Export and import utilities have been designed for such a purpose. But,the project I'm currently working on is a java application, which has the requirement of importing data from source schema to destination schema including ddl.We are not supposed to make use of import and export utilities provided by oracle. [ February 01, 2007: Message edited by: suresh charan ]