6-Transporting Data Between Databases

6-Transporting Data Between Databases - Transporting Data...

Info iconThis preview shows pages 1–13. Sign up to view the full content.

View Full Document Right Arrow Icon
Transporting Data Between Databases Presenter Tathagata Bhattacharjee
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Export and Import Tathagata Bhattacharjee Objectives ± After completing this lesson, you should be able to do the following Describe the uses of the Export and Import utilities Describe Export and Import concepts and structures Perform simple Export and Import operations List guidelines for using Export and Import
Background image of page 2
Export and Import Tathagata Bhattacharjee Oracle Export and Import Utilities EXPORT IMPORT Oracle Database Oracle Database
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Export and Import Tathagata Bhattacharjee ± The export utility provides a simple way for you to transfer data objects between databases, even if they reside on platforms with different hardware and software
Background image of page 4
Export and Import Tathagata Bhattacharjee ± When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, constraints, grants, etc) if any. ± The extracted data is written to an Export file, which is an Oracle binary-format dump file that is typically located on disk or tape
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Export and Import Tathagata Bhattacharjee ± The Import utility reads the object definitions and table data from an Export dump file. ± It inserts the data objects into an Oracle database
Background image of page 6
Export and Import Tathagata Bhattacharjee Oracle Export and Import Utility Overview ± You can use these utilities to do the following Archive historical data Save definitions to protect them from user error failure Move data between machines and databases or between different versions of the Oracle server Transport tablespace between databases
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Export and Import Tathagata Bhattacharjee ± The Export utility can provide a logical backup of: Database objects A tablespace An entire database
Background image of page 8
Export and Import Tathagata Bhattacharjee ± The Import utility can be used to read a valid Export file for moving data into a tablespace. ± Redo log history cannot be applied to objects that are imported from an export file, therefore data loss may occur, but can be minimized
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Export and Import Tathagata Bhattacharjee ± You can use the Export and Import utilities to complement normal operating system backups by using them to: Create a historical archive of a database object or entire database e.g., when a schema is modified to support changing business requirements Save table definitions in a binary file. This may be useful for creating and maintaining a baseline of a given schema structure Move data from one Oracle database version to another, such as upgrading from Oracle8i to Oracle9i
Background image of page 10
Export and Import Tathagata Bhattacharjee ± You can use these utilities to protect against: User errors where a user may accidentally drop or truncate a table A table that has become logically corrupt An incorrect batch job or other DML statement that has affected only a subset of the database
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Export and Import Tathagata Bhattacharjee ± You can use the utilities to recover:
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 62

6-Transporting Data Between Databases - Transporting Data...

This preview shows document pages 1 - 13. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online