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
Description
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
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.