AW: AW: [suse-oracle] IMP-00003: oracle 2004-05-05 - By Marcus Heinze
don't think so. I have imported tables with more than 120 million rows here
with no problem at all. Timeouts or undo/rollback errors would generate
different errormessages anyhow. If you think that a timeout is the problem,
do you have any other problems on that machine or on the network to that
machine ? Can you give the command line for the import? I gather it took
rather long ...
Regards
Marcus
Mit freundlichen Grüßen
Marcus Heinze
IT - Consulting
-- ---- ---- ---- ---- ---
ASTRUM Gesellschaft für angewandte Informatik mbH
Am Wolfsmantel 2
91058 Erlangen
Fon: +49 9131 7725-0
Fax: +49 9131 7725-555
-- ---- ---- ---- ---- ---
http://www.astrum.de
mailto:heinze@(protected)
> -- --Ursprüngliche Nachricht-- --
> Von: Miguel Albuquerque [mailto:mfoacs@(protected)]
> Gesendet: Dienstag, 4. Mai 2004 18:05
> An: Marcus Heinze
> Betreff: Re: AW: [suse-oracle] IMP-00003: oracle
>
>
> What about a timeout exceeded ?
>
> I've done an import full and one of the tables had more the 10million
> rows...that's where i got the message...
>
> On Tue, 2004-05-04 at 17:30, Marcus Heinze wrote:
> > Hello,
> >
> > the doumentation states that the user interrupted this
> operation, is that
> > possible in your case ?:
> >
> > ORA-01013 (See ORA-01013.ora-code.com) user requested cancel of current operation
> >
> > Cause: The user interrupted an Oracle operation by entering CTRL-C,
> > Control-C, or another canceling operation. This forces the
> current operation
> > to end. This is an informational message only.
> >
> > Action: Continue with the next operation
> >
> > Regards,
> >
> > Marcus Heinze
> >
> > Mit freundlichen Grüßen
> >
> > Marcus Heinze
> > IT - Consulting
> > -- ---- ---- ---- ---- ---
> > ASTRUM Gesellschaft für angewandte Informatik mbH
> > Am Wolfsmantel 2
> > 91058 Erlangen
> > Fon: +49 9131 7725-0
> > Fax: +49 9131 7725-555
> > -- ---- ---- ---- ---- ---
> > http://www.astrum.de
> > mailto:heinze@(protected)
> >
> >
> > > -- --Ursprüngliche Nachricht-- --
> > > Von: Miguel Albuquerque [mailto:mfoacs@(protected)]
> > > Gesendet: Dienstag, 4. Mai 2004 17:24
> > > An: suse-oracle@(protected)
> > > Betreff: [suse-oracle] IMP-00003: oracle
> > >
> > >
> > > Does anyone know the meaning of this error?
> > >
> > > IMP-00017: following statement failed with ORACLE error 1013:
> > > "ALTER TABLE "SEC_BROWSER_PROPERTIES" ADD PRIMARY KEY
> ("BROWSER_ID",
> > > "MODUL"
> > > "E", "PROPERTY_NAME") USING INDEX PCTFREE 10 INITRANS 2
> MAXTRANS 255
> > > STORAGE"
> > > "(INITIAL 530464768 NEXT 53288960 MINEXTENTS 1 MAXEXTENTS 505
> > > PCTINCREASE 10"
> > > " FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
> > > "MIM_PROD" E"
> > > "NABLE"
> > > IMP-00003: ORACLE error 1013 encountered
> > >
> > > thanks
> > >
> > > --
> > > Macintosh for Productivity
> > > Linux for Development
> > > Palm for Mobility
> > > Windows for Solitaire
> > >
> > > .-. e-SecureNet
> > > /v\ We Run SuSE Project Manager
> > > // \\ *The LINUX Experts* Miguel Albuquerque
> > > /( )\ 77, rue de Carouge
> > > ^^-^^ 1205 - GE, SWITZERLAND
> > > Mobile +41 79 543 1935
> > > http://counter.li.org Linux user #301007
> > > mailto:mfoacs@(protected) http://www.e-securenet.ch/
> > > -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
> > >
> > > --
> > > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> > > For additional commands, email: suse-oracle-help@(protected)
> > > Please see http://www.suse.com/oracle/ before posting
> > >
> --
> Macintosh for Productivity
> Linux for Development
> Palm for Mobility
> Windows for Solitaire
>
> .-. e-SecureNet
> /v\ We Run SuSE Project Manager
> // \\ *The LINUX Experts* Miguel Albuquerque
> /( )\ 77, rue de Carouge
> ^^-^^ 1205 - GE, SWITZERLAND
> Mobile +41 79 543 1935
> http://counter.li.org Linux user #301007
> mailto:mfoacs@(protected) http://www.e-securenet.ch/
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
