tailieunhanh - Export and Import Utilities

Export and Import Utilities The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), 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. The Import utility reads the object definitions and table data from an Export dump file. It inserts the data. | Export and Import Utilities 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 Oracle Export and Import Utilities Oracle database Oracle database Export Import Export and Import Utilities The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), 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. The Import utility reads the object definitions and table data from an Export dump file. It . | Export and Import Utilities 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 Oracle Export and Import Utilities Oracle database Oracle database Export Import Export and Import Utilities The Export utility provides a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations. When you run Export against an Oracle database, objects (such as tables) are extracted, followed by their related objects (such as indexes, comments, and grants), 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. The Import utility reads the object definitions and table data from an Export dump file. It inserts the data objects into an Oracle database. Oracle Export and Import Utility Overview You can use these utilities to do the following: Archive historical data Save table definitions to protect them from user error failure Move data between machines and databases or between different versions of the Oracle server Transport tablespaces between databases Export and Import Utility Overview The Export utility can provide a logical backup of: Database objects A tablespace An entire database The Import utility is used to read a valid Export file for moving data into a database. Redo log history cannot be applied to objects that are imported from an export file, therefore data loss may occur, but can be minimized. 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; for example, when a schema is modified to support changing business requirements. Save table definitions .

TỪ KHÓA LIÊN QUAN
crossorigin="anonymous">
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.