FastReader benchmark

Rapid Unload / Load Oracle data using WisdomForce FastReader Rapid Unload / Load Oracle data using WisdomForce FastReader WisdomForce Technologies, Inc. http://www.wisdomforce.com ©2005 WisdomForce Technologies, Inc. All rights reserved. 1 Rapid Unload / Load Oracle data using WisdomForce FastReader Note*: The latest copy of this document is available at http://www.wisdomforce.com/dweb/resources/docs/UnloadLoadUsingFastReader.pdfSteps for rapid Oracle database migration 1) The schema(s) should be exported using the exp utility using the ROWS=N parameter. During this stage all the objects which are non data, such as PL/SQL, Sequences, Views, Table definitions, Object privileges etc. will be exported. There will be one such exp file per each schema exported. FastReader allows exporting of the schema definitions such as tables, constraints, sequences, triggers and generating scripts. 2) The data from the large tables (fact tables and the large dimensions) should be exported using FastReader. 3) The data from the small code tables and dimensions can be exported either using FastReader or native exp utility. Native exp should be used with the TABLES parameter specifying only the small tables to be extracted. There will be one exp file per each schema exported. 4) The destination database should be setup with all the same global roles, users, user privileges, system ...