backup and recovery

5 pts.
Tags:
Backup and Recovery
Database Backup
Database migration
Oracle import/export
details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?

Answer Wiki

Thanks. We'll let you know when a new response is added.
No. By using the export/export datapump utility of Oracle, you cannot import into non-oracle Database.  Best way is to write to a flat file and load it.

While there are tools to convert one DB structure to another, The difficulty of doing so, or even the possibility of being able to do it at all would depend on both the version and type of DB software you are working with.
Good Luck
*********************************************************************************

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
  • Dwaltr
    If your dataset is fairly small, I have had a lot of success using MS Access and ODBC to move data from one database to another using append queries.
    900 pointsBadges:
    report
  • DBADAT
    No. By using the export/export datapump utility of Oracle, you cannot import into non-oracle Database.  Best way is to write to a flat file and load it.
    15 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