Re: Delete a BIG table.

From: AlexJent <alexjent_at_aol.com>
Date: 1997/02/15
Message-ID: <19970215032400.WAA19782@ladder01.news.aol.com>#1/1

Ken asks:
>>Dose anybody know how to disable the ROLLBACK when you delete a BIG
>>table ( I don't want to drop it) rather than giving you the error
message
>>
>>Unable to extent rollback segment ......

Ken:
If all data in the table is to be removed, user TRUNCATE TABLE <table name> instead of deleting...truncate is quicker and/because it doesn't need rollback space.

Good luck.

Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: infosys_at_aol.com

E-Mail Work: jentilucci_at_notes.seagate.com

Home: AlexJent_at_aol.com Received on Sat Feb 15 1997 - 00:00:00 CST