Oracle-L: FW: import...dead or alive?

From: Morrin, Liam <Liam.Morrin_at_pinkroccade.co.uk>
Date: Wed, 30 Apr 2003 09:46:59 -0800
Message-ID: <F001.0058CDA9.20030430094659@fatcity.com>

Hi Saira,

If the import has told you how many rows it has imported it will now be creating the indexes which may well take some time. You can query the number of indexes for that table in another session to see if it is has hung. I have had a problem recently where the import created the normal indexes but hung when trying to create bitmap indexes. I had to cntrl-C to move onto the next table and then manually create the bitmap indexes afterwards. This may be a bug in 8.1.7 - I haven't chased it up yet. If anybody has any info on this I would be grateful.

HTH
Liam

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 30/04/03 15:06

How can I find out if an import is dead or alive? I have an import of 1.6M+ rows that's been running for over 45 minutes.

Oracle 8.1.7.0.0
AIX 4.3.3 What can I check?

Thanks,
Saira

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Saira Somani
INET: saira_somani_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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).

This e-mail has been scanned for viruses by the WorldCom Internet Managed Scanning Service - powered by MessageLabs. For further information visit http://www.worldcom.com

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/

This communication and the information it contains: - (a) Is intended for the person(s) or organisation(s) named above and for no other person(s) or organisation(s). Access to this mail by anyone else is unauthorised. (b) Is confidential, and may be legally privileged or otherwise protected in law. Unauthorised use, circulation, copying or disclosure of any part of this communication may be unlawful. (c) May be susceptible to interference, and should not be assumed that it has come in its original form and/or from the stated sender or PinkRoccade UK accepts no responsibility for information, errors or omissions in this e-mail or use or misuse thereof or any act done or omitted to be done in connection with this communication. If you are not the intended recipient, please inform postmaster_at_pinkroccade.co.uk immediately and delete it and all copies from your system.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Morrin, Liam
INET: Liam.Morrin_at_pinkroccade.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------