OraFAQ Forum: Server Administration » Unable to delete rows from table

Home » RDBMS Server » Server Administration » Unable to delete rows from table

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

Unable to delete rows from table [message #57451]

Tue, 17 June 2003 02:52

Happy
Messages: 2
Registered: June 2003

Junior Member

Hi,

i am unable to delete rows from table ...
table size = 1.3 GB.. and PCT_USED=99 .. how can i do that.

Thanks
Happy

Report message to a moderator

Re: Unable to delete rows from table [message #57453 is a reply to message #57451]

Tue, 17 June 2003 05:35

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

can you pls give the error you are getting

Report message to a moderator

Re: Unable to delete rows from table [message #57454 is a reply to message #57453]

Tue, 17 June 2003 05:46

Happy
Messages: 2
Registered: June 2003

Junior Member

It is not showing any error message .. see below

SQL> set transaction use rollback segment big_rbs;

Transaction set.

SQL> delete from eventlog where eltrkid = -1000;

Does PCTUSED have any impact on this...

Report message to a moderator

Previous Topic:	Can I install Oracle 8.1.7 on Solaris without a monitor?
Next Topic:	blocks in user_segments and user_tables has different values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:25:52 CDT 2024