Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of Hands On Software Engineering with Python this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Bear Bibeault
  • Knute Snortum
  • Liutauras Vilda
Sheriffs:
  • Tim Cooke
  • Devaka Cooray
  • Paul Clapham
Saloon Keepers:
  • Tim Moores
  • Frits Walraven
  • Ron McLeod
  • Ganesh Patekar
  • salvin francis
Bartenders:
  • Tim Holloway
  • Carey Brown
  • Stephan van Hulst

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

 
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
ranger
Posts: 17344
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
suresh charan
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to transfer approximately around 30MB data.
 
Here. Have a potato. I grew it in my armpit. And from my other armpit, this tiny ad:
Programmatically Create PDF Using Free Spire.PDF with Java
https://coderanch.com/wiki/703735/Programmatically-Create-PDF-Free-Spire
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!