Utility for copying tables w/constraints and indexes?

pts.
Tags:
Oracle
Hi, I think I read somewhere about a script for copying tables *with all constraints and indexes*. Does anyone know of such a thing? Thanks, Kai Quale University of Oslo

Answer Wiki

Thanks. We'll let you know when a new response is added.

Could use Oracle’s Export/Import utility. Tools such as TOAD or HORA will generate this could for you as well.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • ActorJack
    Sorry, I should have been more specific - I knew about the exp/imp solution, but I'm looking for a script/procedure (it seems impractical to do regular exp/imps as part of my production data warehouse environment). But thanks anyway, Jack
    0 pointsBadges:
    report
  • Kurthp
    Have a look at this link: http://www.dbasupport.com/oracle/ora9i/DDLgen2.shtml Haven't tried it myself but looks like it has potential of doing what you want if you're on 9i.
    195 pointsBadges:
    report
  • Lemmoracle
    I think exp/imp is the easiest step in copying table with constraints,indexes,triggers,etc.. I've been using this for 5 years now.
    0 pointsBadges:
    report
  • ActorJack
    Thanks everyone, especially kurthp for your link to DBAsupport.com - what a wonderful site! The DBMS_METADATA package indeed looks like it'll do the job.
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following