Use multiple dump files for large Oracle exports

Tuesday May 29th 2007 by DatabaseJournal.com Staff

Even as far back as Oracle 8i, the Export utility could handle large exports by splitting them into multiple output files. Bob Watkins reviews how this is done prior to Oracle 10g and what changes are necessary for 10g and later.

[From Builder.com]

Oracle's Export utility (exp) is a useful part of an overall backup strategy. It allows you to restore as little as a single table, which is something that's difficult to do with regular datafile-based backups. But as databases and individual tables have grown in size, it's become difficult to create an export file large enough to contain the data.

The article continues at http://builder.com.com/5100-6388_14-6187034.html?tag=sc

Mobile Site | Full Site