Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Oracle Error 1861: ORA-01861: literal does not match format string, when running compare config w
설명
Getting error: Oracle Error 1861: ORA-01861: literal does not match format string, when running compare config with a table using horizontal partitioning by time in it .
Hori/ Part. Where Clause: CREATE_DM >= '0101 2006000000'
Here is the command I issued: sp_ctrl> compare config ORA_company_config repair
Here is the config file I used: datasource:o.rptprod REPORTS.TBL_DIM_COMPANY REPORTS.TBL_DIM_COMPANY !COMPANY_SCHEMA ! potosi@o.rptdev
Here is the row in the shareplex_partition table for COMPANY_SCHEMA:
SQL> desc reports.tbl_dim_company; Name Null? Type ----------------------------------------- -------- ---------------------------- COMPANY_ID NOT NULL NUMBER(15) COMPANY_TP NOT NULL VARCHAR2(40) COMPANY_NM NOT NULL VARCHAR2(80) CREATE_DM NOT NULL DATE UPDATE_DM NOT
해결 방안
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Shareplex for Oracle