Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Staffware on Oracle - deletes are hanging...

Staffware on Oracle - deletes are hanging...

From: Clinton Naude <clintonn_at_meb.co.za>
Date: Tue, 14 May 2002 04:23:19 -0800
Message-ID: <F001.0045FFA7.20020514042319@fatcity.com>


Hi all.  

Anyone that is running Staffware out there on Oracle 8.1.7 - please help me out here.
This is urgent.
We are trying to delete 70 000 rows from a table - via Staffware, so that we can do a restore - via Staffware.
This seems to take over 10 hours, and still does not seem to complete. If I do a truncate table it takes a few seconds, but via Staffware it just hangs...  

Any idea's?  

Thanks  

Clint

Confidentiality Warning


The contents of this message and any attachments are intended solely for the addressee's use and may be legally privileged and/or confidential. If you are not the addressee indicated in this message, any retention, distribution, copying or use of this message is strictly prohibited. If you received this message in error, kindly notify the sender immediately by reply e-mail and then destroy the message and any copies thereof. The content and any views expressed therein are, unless otherwise stated, the views of the author and not those of the company or any of its management or directors.

Whilst all reasonable steps are taken to ensure the accuracy and integrity of information transmitted, the company does not accept responsibility for any corruption of the information or data or breach of confidentiality as a result of electronic submission.

When addressed to the Momentum Employee Benefits clients any opinion or advice contained in this e-mail is subject to the terms and conditions expressed in any applicable terms of business.


Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_000_01C1FB39.197AF240--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Clinton Naude
  INET: clintonn_at_meb.co.za

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Currency.gif
Received on Tue May 14 2002 - 07:23:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US