• 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
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
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
 
reply
    Bookmark Topic Watch Topic
  • New Topic