Exports & Imports

Export parameters as follows:

• BUFFER - The parameter BUFFER determines the maximum number of rows in an array fetched by Export.
  Buffer_size = rows_in_array * maximum_row_size
  If a table having a LONG datatype is Exported , or if BUFFER is specified as zero, only one row at a time is fetched.
• COMPRESS - Specifies how Export will manage the initial extent for the table data. This parameter is helpful during database re-organization. Export the objects (especially tables and indexes) with COMPRESS=Y. If your table was spawning 20 Extents of 1M each (which is not desirable, taking into account performance), if you export the table with COMPRESS=Y, the DDL generated will have initial of 20M. Later on when importing the extents will be coalesced. Sometime it is found desirable to export with COMPRESS=N, in situations where you do not have contiguous space on your disk (tablespace), and you do not want your imports to bomb.
• CONSISTENT - If massive updates/rollbacks are taking place when you have kicked off the exports, then the exports will not be consistent under normal conditions. If you set CONSISTENT=Y then a rollback segment is designated to backout the effect of any uncommitted transactions. I.e. a value changed to 100 when you have kicked off the exports and before the exports finishes, the changes being undone. The negative effect are exports being slower cause they have to check the consistency by cross referring the rollback segments.
• CONSTRAINTS - A flag to indicate whether to export table constraints.
• DIRECT - Specifying DIRECT=Y causes export to do Direct Path Exports, bypassing the evaluation layer.
• FEEDBACK - Specify that Export should display a progress meter in the for of a dot for x number of rows exported. For example setting FEEDBACK=10, would display a dot each time 10 rows has been exported. This is done for each table exported.
• FILE - The name of the export file.
• FULL - Specifies whether Export should export the entire database or not. This includes all users, there schemas, data dictionaries.
• GRANTS - Specifies whether grants should be exported or not.
• INCTYPE - Specifies the type of incremental export. Options are COMPLETE, CUMULATIVE, and INCREMENTAL.
• INDEXES - Specifies whether indexes should be exported or not.
• LOG - Specifies a file name to receive information and error messages.
• OWNER - Specifies a list of usernames whose objects will be exported.
• RECORD - A flag to indicate whether to record an incremental or cumulative export in the database.
• RECORDLENGTH- Specifies the length, in bytes, of the file record. The RECORDLENGTH parameter is necessary when you must transfer the export file to another operating system that uses a different default value.
• ROWS - Specifies whether the rows of table data should be exported or not.
• STATISTICS - Specifies the type of database optimizer statistics to generate when the exported data is imported later. Options are ESTIMATE, COMPUTE and NONE
• TABLES - Specifies the list of tables to export.
• USERID - Specifies the username/password of the user initiating the export