import hangs database

I'm a relatively inexperienced database admin.

I'm importing a fairly large file (290M) into an Oracle 8.0.5 instance. Whenever i try to import it, I get a certain portion thru the process, and then my import hangs, keeping a lock on the table that it last was trying to load. If I go in with a sqlplus session and try to query the table I get:

ORA-00054: resource busy and acquire with NOWAIT specified

This seems to hang the database in a couple consistant spots during the load, depending on whether I clear out the tablespace before the import or not. So if I start with a clean database, then I hang when loading table 7, if I don't clean it out, I hang while loading table 12. I tried just re-running it ad- nauseum, but i think table 14 is too large, and it never gets done.

I've been stopping the hang by doing a shutdown abort, as I don't really know how to get rid of the problem any other way.

So two things: Where do I look to try to figure out what is going wrong with the import, it seems like I should be able to tell the database to do some logging, and how can I release the table lock without bouncing the DB?

I've looked at space, and since this is on a 45G RAID drive, I don't think that's the problem. I don't have autoarchive on, but i've looked around and don't know where the redo-logs are written to, so potentially I'm swamping them?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon May 03 1999 - 19:44:01 CDT