• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

Export / Import SQL For 9i/10g

 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I have an Oracle 9i db with an assortment of tables, indices, and constraints that we want to export for use on another computer( minus data ).

What do you recommend for exporting said information in an easy-to-read format? The EXP utility supplied with oracle appears to require that each row and index be typed in individually and it doesn't present an easy-to-read output.

Is there a particular way to use EXP or a utility program out there that will do this for me? Bonus points if it can compare two and SQL Scripts and output the difference.

Thanks ahead of time,
Kevin Wright
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic