This file could then be
shipped in binary form to any platform Oracle supports and subsequently imported
into another database with Oracle??™s Import utility. This approach can still provide a
simple form of data redundancy if the amount of data is manageable.
Oracle 7.3 introduced a direct pathexport feature that runs about 70 percent faster
than a traditional export. The direct path export avoids some of the overhead of a
normal export by directly accessing the data in the Oracle datafiles. Oracle Database
10g and newer database releases provide a much higher speed export/import than in
the earlier Oracle version. This latest version, often called the Data Pump, is about
60 percent faster for export and 15 to 20 times faster for import per stream.
Another export option is to unload data from the desired tables into simple flat files
by spooling the output of a SELECT statement to an operating system file. You can
then ship the flat file to the secondary site and use Oracle??™s SQL*Loader utility to
load the data into duplicate tables in the secondary database.
Pages:
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631