REFRESH SCHEMA WITH IMPORT

pts.
Tags:
Oracle
To refresh a test schema using import from a production export, (rows=no, ignore=y -- or any combo), I wish to verify that for object code with the same name, (procedures, functions etc.) that the import will replace existing procedures, only replace procedures that are older than in the export.dmp, or not replace them?

Answer Wiki

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

just checking

Discuss This Question: 2  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
  • Kurthp
    I would recommend using a tool like TOAD with DBA option pack which will allow you to compare schemas and generate scripts that would allow you to synchronize schemas. If just using the Import utility, I believe that all procedures will be replaced. You could use SHOW=Y which will list all objects being created and then manually scan the log file to select the code you want to run.
    195 pointsBadges:
    report
  • AlanMuster
    Import of a schema will replace stored procedures. If you do not want to do this, and only wish to refresh data, then you should instead perform a table import.
    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