![]() ![]() When data is imported into existing tables, however, the order of import can still produce referential integrity failures. This sequence also prevents redundant triggers from firing twice on the same data (once when it was originally inserted and again during the import).įor example, if the EMP table has a referential integrity constraint on the DEPT table and the EMP table is imported first, then all EMP rows that reference departments that have not yet been imported into DEPT would be rejected provided that the constraints are enabled. This sequence prevents data from being rejected due to the order in which tables are imported. Then triggers are imported, and integrity constraints are enabled on the new tables. After all data has been imported into all tables, indexes are built. Table objects are imported from the export file in the following order:įirst, new tables are created. Figure 2 - 1 illustrates the process of importing from an export file: Import extracts the objects from an Export file and puts them into a database. ![]() The basic concept behind Import is very simple. Several example Import sessions are also provided to help you learn how to use Import. This chapter discusses the following topics: For information on how to export a database, see Chapter 1, "Export." To load data from other operating system files, see the discussion of SQL*Loader in Part II of this manual. Import only reads export files created by Export. Import reads an Export file into an Oracle database. This chapter describes how to use the Import utility. Importing Incremental, Cumulative and Complete Export Files.Warning, Error, and Completion Messages.Import Oracle7 Server Utilities User's Guide
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |