OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL*Loader-926

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*Loader-926 [message #74732]

Thu, 10 February 2005 07:45

thumsup9
Messages: 4
Registered: February 2005

Junior Member

SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table SUPPLIES
ORA-30036: unable to extend segment by 128 in undo tablespace 'UNDOTBS1'

pls let me know in detail,how to solve this,im totally new to this.

Thanks for help.
Vthums

Report message to a moderator

Re: SQL*Loader-926 [message #74733 is a reply to message #74732]

Thu, 10 February 2005 08:01

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Your undo retention is not configured right.
Please have a look here
http://www.orafaq.com/forum/t/23533/0/

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Re: SQL*Loader-926 [message #74734 is a reply to message #74732]

Thu, 10 February 2005 08:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

or it may be the other way around.
try this logged in as DBA user.
I

sql>alter system set undo_retention=0;

Report message to a moderator

Re: SQL*Loader-926 [message #74735 is a reply to message #74733]

Thu, 10 February 2005 08:39

thumsup9
Messages: 4
Registered: February 2005

Junior Member

thanks mahesh,that worked.

Report message to a moderator

Previous Topic:	Cloning
Next Topic:	IMPORT-DESIGNER 2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 09:29:18 CDT 2024