1 2 Previous Next 19 Replies Latest reply: Nov 6, 2012 9:31 PM by rp0428 RSS

    EXP-00056: ORACLE error 1455 encountered

    442775
      when trying to export full database gives this error

      . exporting synonyms
      . exporting views
      . exporting referential integrity constraints
      . exporting stored procedures
      . exporting operators
      . exporting indextypes
      . exporting bitmap, functional and extensible indexes
      . exporting posttables actions
      . exporting triggers
      . exporting materialized views
      EXP-00056: ORACLE error 1455 encountered
      ORA-01455: converting column overflows integer datatype
      EXP-00000: Export terminated unsuccessfully

      Pls suggest me solution
        • 1. Re: EXP-00056: ORACLE error 1455 encountered
          464759
          According to Metalink note 351233.1, this is an export bug in 9.2.0.4.0 fixed in 10.2.0 and linked to audit trail configuration.

          If you disable auditing with "noaudit session" before running full export, export should complete successfully.
          • 2. Re: EXP-00056: ORACLE error 1455 encountered
            Nicolas.Gasparotto
            Hi,

            What is your Oracle version ?
            Maybe it's the bug #4270321, you can read a workaround into metalink note Export of Index On Large Table Fails With: ORA-01455 (Datatype Overflow) - Note:339124.1

            Try to export with INDEXES=n STATISTICS=none

            Nicolas.
            • 3. Re: EXP-00056: ORACLE error 1455 encountered
              442775
              I have not enable any audit.Still it give error.
              • 4. Re: EXP-00056: ORACLE error 1455 encountered
                464759
                In this case, try to use workaround suggested by Nicolas. There are 2 possibles bugs linked to these problems and not only 1 as I said earlier.
                • 5. Re: EXP-00056: ORACLE error 1455 encountered
                  user517698
                  Hi ,

                  I am getting the same error as well . A search in Google says it's due to INTERGER datatype but the table involved is using NUMBER.

                  You have suggested the following : INDEXES =n STATISTICS=none

                  However, i do require the indexes.

                  Is there any other workaround ?

                  tks & rgds
                  • 6. Re: EXP-00056: ORACLE error 1455 encountered
                    429643
                    bug is there in 11g Linux 32bit happened near end when export views.. with followed by 1455 as messages indicate below..
                    EXP-00056: ORACLE error 1455 encountered
                    ORA-01455: converting column overflows integer datatype
                    • 7. Re: EXP-00056: ORACLE error 1455 encountered
                      AndySwann
                      I had the exact same problem on an 11.1.0.6.0 database.

                      . exporting synonyms
                      . exporting views
                      EXP-00056: ORACLE error 1455 encountered
                      ORA-01455: converting column overflows integer datatype
                      EXP-00000: Export terminated unsuccessfully

                      I used solution 2 in DocID 351233.1

                      2. Disable auditing by issuing the following from sqlplus:
                      SQL> noaudit session;

                      The export then terminated successfully without warnings

                      According to this same document "This bug is fixed in Fixed In Ver: 10.2.0".
                      • 8. Re: EXP-00056: ORACLE error 1455 encountered
                        753139
                        I am facing same issue with one of my database export. and above mentioned solution is of no help.
                        what else I could do?

                        I have an 11g db to export, is there any issue restriction in 11g export?

                        Edited by: user1904245 on 11-Feb-2010 06:10
                        • 9. Re: EXP-00056: ORACLE error 1455 encountered
                          595762
                          Hi,

                          I also have the same problem,

                          Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
                          With the Partitioning, OLAP, Data Mining and Real Application Testing options
                          Export done in UTF8 character set and AL16UTF16 NCHAR character set
                          .
                          .
                          . exporting synonyms
                          . exporting views
                          EXP-00056: ORACLE error 1455 encountered
                          ORA-01455: converting column overflows integer datatype
                          EXP-00000: Export terminated unsuccessfully

                          Thank you,
                          • 10. Re: EXP-00056: ORACLE error 1455 encountered
                            758141
                            I am also getting this.


                            christian@workstation:/export/home/christian> exp christians_user/secret@//some.host/some_service owner=christians_user FILE=export_owner_christians_user.dat COMPRESS=Y STATISTICS=none INDEXES=n

                            Export: Release 11.2.0.1.0 - Production on Mi Dez 8 10:56:21 2010

                            Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.


                            Angemeldet bei: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
                            With the Partitioning, OLAP, Data Mining and Real Application Testing options
                            Exportieren in AL32UTF8-Zeichensatz und AL16UTF16-NCHAR-Zeichensatz durchgeführt
                            Achtung: Die Tabellenindizes werden nicht exportiert

                            Spezifizierte Benutzer werden gleich exportiert ...
                            . Prozedurale Pre-Schema-Objekte und -Aktionen werden exportiert
                            . Fremdfunktions-Bibliotheksnamen für Benutzer christians_user werden exportiert
                            . Synonyme vom Typ PUBLIC werden exportiert
                            . Synonyme vom Typ PRIVATE werden exportiert
                            . Objekttypdefinitionen für Benutzer christians_user werden exportiert
                            christians_user Objekte werden gleich exportiert ...
                            . Datenbank-Links werden exportiert
                            . Sequenzzahlen werden exportiert
                            . Clusterdefinitionen werden exportiert
                            . Tabellen von christians_user werden gleich exportiert ... über 'Conventional Path'
                            EXP-00008: ORACLE-Fehler 1455 aufgetreten
                            ORA-01455: Überlauf von Integer-Datentyp bei Umwandlung der Spalte
                            EXP-00000: Der Export-Vorgang endete mit Fehlern
                            christian@workstation:/export/home/christian>



                            Could it be due to the slight version difference between exp (11.2.0.1.0) and the Oracle I'm connecting to (11.2.0.2.0)?

                            Regards,

                            Christian
                            • 11. Re: EXP-00056: ORACLE error 1455 encountered
                              826984
                              hi - i am ali farvardin from www.baridsoft.ir
                              we have Office automation systems

                              **I had the exact same problem on an 11 r2 database on windows 2008 r2.**

                              Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                              With the Partitioning, OLAP, Data Mining and Real Application Testing options
                              EXP-00075: rounding FILESIZE down, new value is 26106126336
                              Export done in UTF8 character set and UTF8 NCHAR character set

                              About to export specified users ...
                              . exporting pre-schema procedural objects and actions
                              . exporting foreign function library names for user EORG
                              . exporting foreign function library names for user EORG_NOTIFICATION
                              . exporting foreign function library names for user EORG_GENERATOR
                              . exporting PUBLIC type synonyms
                              . exporting private type synonyms
                              . exporting PUBLIC type synonyms
                              . exporting private type synonyms
                              . exporting PUBLIC type synonyms
                              . exporting private type synonyms
                              . exporting object type definitions for user EORG
                              . exporting object type definitions for user EORG_NOTIFICATION
                              . exporting object type definitions for user EORG_GENERATOR
                              About to export EORG's objects ...
                              . exporting database links
                              . exporting sequence numbers
                              . exporting cluster definitions
                              . about to export EORG's tables via Conventional Path ...
                              . . exporting table ACCOUNT
                              2 rows exported
                              /
                              /
                              /
                              /
                              /
                              / 4 rows exported
                              . . exporting table USERRIGHTS
                              ...........................................................................
                              .....................................
                              112826 rows exported
                              . . exporting table USERS
                              325 rows exported
                              . . exporting table USERSPROFILEDATA
                              .......
                              7135 rows exported
                              . . exporting table USERWORKGROUP
                              914 rows exported
                              . . exporting table VMS_SETTINGS
                              1 rows exported
                              . . exporting table WF_WORKFLOW
                              2 rows exported
                              . . exporting table WORKGROUP
                              16 rows exported
                              . exporting synonyms
                              . exporting views
                              EXP-00056: ORACLE error 1455 encountered
                              ORA-01455: converting column overflows integer datatype
                              EXP-00000: Export terminated unsuccessfully

                              when i run expdb command , i dont have any problem.


                              I used solution 2 in DocID 351233.1

                              2. Disable auditing by issuing the following from sqlplus:
                              SQL> noaudit session;

                              ***but NOT WORK***

                              Edited by: user9538494 on Dec 28, 2010 1:22 AM
                              • 12. Re: EXP-00056: ORACLE error 1455 encountered
                                Psst
                                Hello All,

                                After browsing though your posts and the web, here is what worked for me to fix the EXP-00056: ORACLE error 1455 encountered error:

                                I had set up automated Windows Task to export the db (not data pump) and forgot about changing the Oracle Home path in it from 11.1.0 to 11.2.0.2 and the "start in' box did the same thing. It got all the way through the export after that. (the 'noaudit' and the indexes='n', etc. solutions did NOT work for me either.)

                                I had it working OK on another (2) 11.2.0.2 instances I just upgraded, so it wasn't making sense about those other solutiona as I didn't have to do them on the first two.

                                Good luck.

                                old: D:\oracle\product\11.1.0\BIN\exp.exe username/password@hostname parfile=D:\exports\r9prod\wed_r9prod.par

                                FIX
                                D:\oracle\product\11.2.0.2\BIN\exp.exe username/password@hostname parfile=D:\exports\r9prod\wed_r9prod.par
                                • 13. Re: EXP-00056: ORACLE error 1455 encountered
                                  829952
                                  I also think this error is related to export binary being on a lower version of the target database. I was trying to create an export from an 11gR2 database (which got upgraded from 11gR1) with an 11gR1 client, and failed with "export ORA-01455: converting column overflows integer datatype". Then I installed 11gR2 client and the problem was gone.
                                  • 14. Re: EXP-00056: ORACLE error 1455 encountered
                                    user3790255
                                    I have the same errors when I used exp to export in ver 11.2.0.1. I found a copy of exp.exe version 11.2.0.2 and replaced it on 11.2.0.1 and the export completed without any errors.
                                    1 2 Previous Next