Importing Delimited Device Files into an Oracle Database using Oracle SQL Developer

Importing Delimited Device Files into an Oracle Database using Oracle SQL Developer

The Pipe-Delimited | device files provide a relational view of the device record data. These files can be imported into a database for easier reading and interaction.

Notice

Be aware of the file size and row limitations of the software you are attempting to import the files into. For information on limitations, look at the software's official documentation

Directions

The following directions are for the Oracle SQL Developer tool, but similar actions can be taken in other SQL tools and database types.

Note: Before you start this process, you must first manually change the file extension of the pipe-delimited device file(s) from .txt to .csv.

  1. Connect to your schema and right-click on Tables. Click Import Data. Choose the file you wish to import. Click Open.
    Import Data
  2. Check Header. For the Format dropdown, select Delimited. Set encoding to UTF-8. Set the Delimiter to |. Set the Left and Right Enclosure to none. Click Next.
    Delimited with Headers
  3. Choose Insert for your Import Method. Name your table you wish to import to. Click Next
    Insert
  4. Select the columns you wish to import. Click Next
    Columns
  5. For each column you wish to import, choose the appropriate Data Type and Size/Precision (max length) (For example, the Product Code would be VARCHAR2 type with size 3). Click Next.
    Data types
  6. Click Finish.
    Finish
  7. Repeat from step 1 for each file you wish to import into a table.