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

This article mainly introduces "how to solve the problem of database import and export Times ORA-01843". In the daily operation, I believe that many people have doubts about how to solve the problem of database import and export Times ORA-01843. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts of "how to solve the problem of database import and export Times ORA-01843". Next, please follow the editor to study!

[problem description] expdp and impdp Times carried out the database with the following errors:

Dbms_sche

ORA-39083: creation of object type PROCOBJ failed with an error:

ORA-01843: invalid month

The failed sql is:

[environment description]

Platform: AIX6.1

Source database version: 10.2.0.1

Target database version: 11.2.0.4

[cause of the problem]

Literally, it is easy to know the general direction of the problem, when the date format of the exported file is inconsistent with the date format set by the target side, so that it cannot be imported.

The response processing method was quickly found on Metalink, but the whole way is also very easy to deal with.

The official question is explained as follows: DBMS_PSWMG_IMPORT.IMPORT_HISTORY expects passwords to be in 'yyyy/mm/dd' format.

[solution]

1. Add the following environment variables to the operating system

NLS_DATE_FORMAT=YYYY/MM/DD HH24:MI:SS

2. Echo $NLS_DATE_FORMAT

YYYY/MM/DD HH24:MI:SS

3. Query the current settings in the database

SQL > select* from nls_session_parameters where parameter = 'NLS_DATE_FORMAT'

PARAMETER VALUE

-

NLS_DATE_FORMAT YYYY/MM/DD HH24:MI:SS

At this point, the study on "how to solve the problem of database import and export Times ORA-01843" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.