Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!e65g2000hsc.googlegroups.com!not-for-mail From: "sealo" Newsgroups: comp.databases.oracle.server Subject: Re: ORA-01466: unable to read data - table definition has changed Date: 31 Mar 2007 21:59:35 -0700 Organization: http://groups.google.com Lines: 75 Message-ID: <1175403575.858681.307320@e65g2000hsc.googlegroups.com> References: <1175243846.064444.152610@o5g2000hsb.googlegroups.com> <1175278302.568858.188650@n59g2000hsh.googlegroups.com> <1175330435.114037.321150@e65g2000hsc.googlegroups.com> <1175347086.612361.279300@y80g2000hsf.googlegroups.com> NNTP-Posting-Host: 62.23.212.169 Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1175403577 32584 127.0.0.1 (1 Apr 2007 04:59:37 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sun, 1 Apr 2007 04:59:37 +0000 (UTC) In-Reply-To: <1175347086.612361.279300@y80g2000hsf.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: e65g2000hsc.googlegroups.com; posting-host=62.23.212.169; posting-account=2eWwZQ0AAADy5RfEX6kjCHk2ph4-9d9E Xref: usenetserver.com comp.databases.oracle.server:425076 X-Received-Date: Sat, 31 Mar 2007 23:59:37 EST (text.usenetserver.com) On 3=D4=C231=C8=D5, =CF=C2=CE=E79=CA=B118=B7=D6, "S L Niemann" wrote: > On Mar 31, 3:40 am, "sealo" wrote: > > > > > > > On 3=D4=C231=C8=D5, =C9=CF=CE=E72=CA=B111=B7=D6, "Arun Mathur" wrote: > > > On Mar 30, 4:37 am, "sealo" wrote: > > > > Hello, > > > > It is very strange issue. When I was doing the exp with "consistent= =3Dy" > > > > to the database, it was failed that "ORA-01466: unable to read data= - > > > > table definition has changed". > > > > > I search all the pages in the web, no proper answer was founded. And > > > > it seems some time error, I also check the all the changed time and > > > > create time in the dba_objects table. But no one of them was exceed > > > > the current time. > > > > > Could you give me some hints to this issue? Now Only if I set the > > > > "consistent=3Dn", the exp can continue to do the data export. > > > > Hello, > > > > See Metalink Note:1011680.102. > > > > Regards, > > > Arun > > > Sorry, I do not have the permission to access the Metalink. > > Could you paste the solution here? > > MetaLink Info: Quoted directly, no notations below are mine > SL > > Solution Description: > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > This is usually caused when some change has been made to the > initialisation parameter FIXED_DATE or the system date. It can occur > Under different circumstances. > > 1. When doing Date testing and the init.ora parameter FIXED_DATE > has been set to a future date. When the database is started, then > that date & TIME does not change. > > So any objects created will have exactly the same Date & Time > stamp as the FIXED_DATE. > > Now When you come to run the EXPORT, it checks the SYSDATE > and the creation dates for the objects. > > You need to modify the TIME in the FIXED_DATE parameter, > i.e. add 1 hour or few minutes, etc and you will not > encounter the error ORA-1466 anymore. > > 2. The Operating System was reinstalled because of the server crash. > The system date was not set correctly. The year was set to 2001 > instead of 1997 when they reinstalled Oracle. After some DB > activity > they realized the date was incorrect and reset it to 1997 causing > some > objects to exist with future dates. > > Perform full database export without specifying consistent=3Dy and > recreate the database.- =D2=FE=B2=D8=B1=BB=D2=FD=D3=C3=CE=C4=D7=D6 - > > - =CF=D4=CA=BE=D2=FD=D3=C3=B5=C4=CE=C4=D7=D6 - Thank you very much!