My Oracle Support Banner

Data Upload to the Table in ADB Fails Due to ORA-1861 Error (Doc ID 3030744.1)

Last updated on JUNE 28, 2024

Applies to:

Oracle SQL Developer Web - Version 23.4 and later
Information in this document applies to any platform.

Symptoms

Data upload to a table in ADB fails due to error "ORA-01861: literal does not match format string" error if the data file has multiple records and is in Excel format (.xlsx). Additionally, the table includes several DATE columns.

Steps to reproduce:

  1. Create table from the SQL worksheet of your ADB.
  2. Right click the table and select "Data Loading" > "Upload Data...".
  3. Drag and drop <Filename>.xlsx to "Add File".
  4. Click "Upload" button.
  5. Check the error log table, SDW$ERR$_<TABLE_NAME>, "ORA-01861: literal does not match format string" occurs.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.