Shulou(Shulou.com)06/01 Report--

The following date format errors occurred when importing ORACLE database:

ORA-39083: Object type TABLE creation failed with error:ORA-01843: Invalid month

Log in to the two databases, query the date format of the two databases, and find that the date format of the exported and imported library is different.

SQL> select sysdate from dual;

Exported library in English format Date

The imported library is in Chinese format Date

After checking, it was found that the locales of the two databases are different

Then modify the environment variable nls_lang of the imported library (temporarily modified under CMD) to English format date.

C:\Documents and Settings\admin>set nls_lang=AMERICAN_AMERICA.ZHS16GBK

Then log in again to query the date format

Modify date format after nls_lang

After the modification is completed, you can import it normally.

Note: Set nls_lang under CMD, valid only for the current session.

Reference: blog.csdn.net/pan_tian/article/details/7745717

http://www.cnblogs.com/rootq/archive/2009/05/16/1458090.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.