月度存档: 十月 2010

ORA-01861: literal does not match format string

Get following error when importing a schema to new database,

—————————–
orA-39083: Object type TABLE failed to create with error:
orA-01861: literal does not match format string
Failing sql is:
Create TABLE “BLOG”.”MT_AUTHOR” (“AUTHOR_ID” NUMBER(*,0) NOT NULL ENABLE, “AUTHO
R_API_PASSWORD” NVARCHAR2(60), “AUTHOR_CAN_Create_BLOG” NUMBER(1,0), “AUTHOR_CAN
_VIEW_LOG” NUMBER(1,0), “AUTHOR_EMAIL” NVARCHAR2(75), “AUTHOR_ENTRY_PREFS” NVARC
HAR2(255), “AUTHOR_EXTERNAL_ID” NVARCHAR2(255), “AUTHOR_HINT” NVARCHAR2(75), “AU
THOR_IS_SUPERUSER” NUMBER(1,0), “AUTHOR_NAME” NVARCHAR2(255) NOT NUL
—————————–
there is a column in this database defined like this,

“LOG_MODIFIED_ON” DATE DEFAULT ‘20000101000000’ NOT NULL ENABLE,  

and oracle thinks ‘20000101000000’  is not formated right, so it gives ora-01861 error.

Here is my troubleshooting steps, 继续阅读 »

终于好了,放心了

终于好了,放心了

不要生病了,快点好起来

你都发烧39.8C了,全身滚热,我好担心,好害怕。
不要生病了,快点好起来吧。