wood burning stoves 2.0*
The moose likes Oracle/OAS and the fly likes copying all of the objects in one schema over to another schema Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "copying all of the objects in one schema over to another schema" Watch "copying all of the objects in one schema over to another schema" New topic
Author

copying all of the objects in one schema over to another schema

suresh charan
Greenhorn

Joined: Jun 15, 2006
Posts: 8
Hi,

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 ]
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17257
    
    6

How much data are you trying to transfer?

Also, if you need to transfer lots of data like that then Java isn't the right tool to use.

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
suresh charan
Greenhorn

Joined: Jun 15, 2006
Posts: 8
I need to transfer approximately around 30MB data.
 
Don't get me started about those stupid light bulbs.
 
subject: copying all of the objects in one schema over to another schema