Name | Value |
---|---|
NAME | ORACLE (DELIMITED) |
FIELD DELIMITER | , |
SEND LAST FIELD DELIMITER? | YES |
FILE HEADER | D ORACTL^DDXPLIB |
DESCRIPTION | Use this format to export data to an Oracle table. Data will be exported in comma-delimited format and non-numeric fields will be surrounded by quotes. The user will be prompted for field names. The field names should be the column_names in the Oracle table. Also, the user will need to supply the maximum length of a record to be exported. By default, data will be imported into a table with the same name as that of the export template. |
USAGE NOTES | This format produces a control file to be used with Oracle's SQL*LOADER |TAB| SQLLOAD USERID=username/password, CONTROL=INTO_ORACLE.CTL|TAB| Of course, other options are available. Consult your Oracle documentation. utility to load data into a preexisting Oracle table. The control file is complete as created, but you may edit the file to modify the import. By default, the data will be imported into a table with the same name as that of the export template. So, either that table must exist in your Oracle table_space with the columns specified when the export template was built or the exported file will need to be modified to show the correct table_name. A minimum syntax for loading an export file named INTO_ORACLE.CTL would be: |
FORMAT USED? | YES |
RECORD LENGTH FIXED? | NO |
NEED FOREIGN FIELD NAMES? | YES |
MAXIMUM OUTPUT LENGTH | 0 |
QUOTE NON-NUMERIC FIELDS? | YES |