CODEWITHSUNDEEP
mysqloracle-databaseexport
Alana Storm
Alana Storm

Reputation: 166066

Oracle Data Dump and Data Restore

What's the "standard" (defacto or otherwise) way to dump an Oracle database/instance to an ascii or binary file, and then reimport that file into a separate Oracle instance.

I'm looking for the equivalent of mysqldump, but for the Oracle platform.

Upvotes: 2

Views: 1509

Answers (2)

cagcowboy
cagcowboy

Reputation: 30828

Actually, I'm pretty sure imp + exp have been superceeded by Oracle Data Pump.

imp + exp do not support all Oracle 10g + 11g features

See http://www.orafaq.com/wiki/Datapump

Upvotes: 5

sangretu
sangretu

Reputation: 1208

I believe you're looking for the Oracle Import / Export utility:

http://www.orafaq.com/wiki/Import_Export_FAQ

Upvotes: 3

Related Questions