Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "how to solve the database ORA-01455 error report". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Today, when exporting a table with exp, I reported an error of 1455. The version of oracle on the server is 11.2.0.4 and the version on the client is 10.2.0.4. At first, I thought it was a problem of inconsistent version, but according to experience, I did not encounter this problem before, and later found that the table was caused by an empty table.

[oracle@RACdbTestServer] $exp hxxx/xxxxx@192.168.128.xx/oraxxx file=/home/oracle/Mxxxxx.dmp tables=MxxxxExport: Release 10.2.0.4.0-Production on Wed Sep 19 10:28:03 2018Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application TesExport done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified tables via Conventional Path... EXP-00008: ORACLE error 1455 encounteredORA-01455: converting column overflows integer datatypeEXP-00000: Export terminated unsuccessfully

This is a new feature of Oracle 11g R2. When no data has been inserted since the table was created, in order to save space, segment; is not allocated by default. It is controlled by the parameter deferred_segment_creation, and the default is TRUE.

SQL > show parameter deferred_segment_creationNAME TYPE VALUE-- deferred_segment_creation boolean TRUE

Solution:

1. Change the parameter to false

Alter system set deferred_segment_creation=false scope=both

two。 Find out the empty table.

Select 'alter table' | | table_name | | 'allocate extent;' from user_tables where num_rows=0

3. Just execute the alter table statement.

4. You can change deferred_segment_creation back to true after export

"how to solve the database ORA-01455 error report" content is introduced here, thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.