Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DB23c DataPump export / import jobs created by SQL Developer result in ORA-01891: Datetime or Interval internal error.

Jan-Peter MeyerDec 24 2023

On an OCI Base Database I performed the following steps:

  1. I created a test table on 23c with one sdo_geometry column with one row of data.
  2. I exported the test table from 23c (Creating export job with SQL Developer)
  3. I dropped the test table
  4. I loaded the export file created in step 2 into the original schema on 23c (Creating import job with SQL Developer)

Result:
[oracle@b4ddbsystem2 win_prod_pdb]$ cat IMPORT-06_52_08.LOG
Master table "BRAIN4DATA"."IMP_SD_406-06_51_00" successfully loaded/unloaded
Starting "BRAIN4DATA"."IMP_SD_406-06_51_00":
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "BRAIN4DATA"."BP_ADDRESS_TEST" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01891: Datetime or Interval internal error.
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "BRAIN4DATA"."IMP_SD_406-06_51_00" completed with 1 error(s) at Sun Dec 24 06:53:02 2023 elapsed 0 00:00:55

I am using SQL Developer Version 23.1.0.097
Tables without sdo_geometry columns work fine

Are there any known issues generating DataPump jobs from SQL Developer against 23c Databases when using sdo_geometry datatype?

Regards,
Jan-Peter

Comments

Post Details

Added on Dec 24 2023
2 comments
191 views