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
