1

Topic: Error ORA-01426 at export of section of the table

Good afternoon! A question to professionals of Oracle. Help please a good advice.
There is an Oracle 11gR2 on  a server 2012. There is in it big intervalno-partitsionnaja a table.  procedure expdp . But since some moment archiving began to produce an error at attempts  any of new sections:
ORA-31693: Failure at loading/unloading of object of the data "HRA". "BILL": "SYS_P39000", this object of the data is passed because of an error:
ORA-02354: an error at export/import of the data
ORA-01426: number overflow
Contents of a file of parameters expdp extreme simple:
tables=BILL:SYS_P39000
directory=dumpdir
dumpfile=test.dmp
compression=all
logfile=test_exp.log
Old sections  without problems. And with new here such trouble. I feel something happened at some instant. But I will not understand about what generally there is a speech. Sections normal, i.e. are read by requests in the full volume. About what overflow there is a speech? Can eat restriction on numbers of sections? Help to solve this problem please. And that without  somehow not on itself. In advance thanks.
Z.Y.mov on 12 can to be offered.

2

Re: Error ORA-01426 at export of section of the table

drevil1993;
Bug 9735282
Which 11gR2?
Affirms that  in versions:
12.1.0.1 (Base Release)
11.2.0.3 (Server Patch Set)
11.2.0.2.3 Database Patch Set Update
11.2.0.2 Bundle Patch 8 for Exadata Database
11.2.0.2 Patch 7 on Windows Platforms

3

Re: Error ORA-01426 at export of section of the table

drevil1993 wrote:

Z.Y.mov on 12 can to be offered.

Oracle MetaLink wrote:

WORKAROUND?
===========
No

4

Re: Error ORA-01426 at export of section of the table

Kind  - Eh;
Thanks for the information. And thought that it simply bug. It is a pity just  our tops four decided not to pay year as: (. There was a hope that it something in adjustments, but alas... We Will think.

5

Re: Error ORA-01426 at export of section of the table

And prompt please if not difficultly, patchset 11.2.0.4 if it to roll on 11.2.0.1 does not rescue casually the father of Russian democracy?

6

Re: Error ORA-01426 at export of section of the table

drevil1993 wrote:

And prompt please if not difficultly, patchset 11.2.0.4 if it to roll on 11.2.0.1 does not rescue casually the father of Russian democracy?

And if eye to undress? [spoiler] [/spoiler]

7

Re: Error ORA-01426 at export of section of the table

till 12.2.0.4 and about happiness, all plowed!!! Thanks for the help once again.

8

Re: Error ORA-01426 at export of section of the table

drevil1993 wrote:

Proagprejdilsja till 12.2.0.4

you Say lies.

9

Re: Error ORA-01426 at export of section of the table

Elic;
smile)))

10

Re: Error ORA-01426 at export of section of the table

... Certainly 11.2.0.4 smile At me already all. 12 at a head sat down:)