You can load into an existing table or create a new table from the loaded data. You can omit (skip) columns when loading or unloading. You can load by copying and pasting from a spreadsheet. You can load or unload XML files or delimited-field text files (such as comma-delimited (. The step-by-step wizards have the following features: The Data Load/Unload wizards of the Oracle Database XE graphical user interface enable you to easily load and unload delimited text data to and from the database. The data contains XMLType data and contains no FLOAT or DOUBLE data types. You want to import or export data from or to another Oracle database. There is no XMLType data in any of the data. You want to import or export an entire schema from or to another Oracle database. You have text data to load, and you want to load only records that meet certain selection criteria (for example, only records for employees in department number 3001).
You have tab-delimited text data to load, and there are more than 10 tables. The records are fixed length, and field definitions depend on column positions. You have to load data that is not delimited. You have fewer than 10 tables to load, the data is in spreadsheets or tab- or comma-delimited text files, and there are no complex data types (such as objects or multivalued fields). Table 10-2 Import/Export Scenarios and Recommended Options Import/Export Scenario Table 10-2 provides a number of load/unload/import/export scenarios and suggests the appropriate option to use for each. Imports/exports entire database, entire schema, multiple schemas, multiple tablespaces, or multiple tablesĬommand-line interface, invoked with exp and imp commandsĭoes not support the FLOAT and DOUBLE data typesĬapabilities similar to Data Pump Data Pump is preferred unless you must import or export XMLType data Supports numerous input formats, including delimited, fixed record, variable record, and streamĭata Pump Export and Data Pump Import utilitiesĬommand-line interface, invoked with expdp and impdp commandsĮxports and imports from one Oracle database to another (proprietary binary format) Loads/unloads tables only, one table at a timeĬommand-line interface, invoked with sqlldr commandīulk-loads data into the database from external files Loads/unloads from and to external text files (delimited fields) or XML files Table 10-1 Summary of Oracle Database XE Import/Export Options Feature or Utilityĭata Load/Unload wizards in the Oracle Database XE graphical user interface
0 kommentar(er)
