Export Problem - Hanging

Is there anything information in the alert.log? Or a .trc in the udump directory?

Nothing in alert file or .trc files...

I'm currently analyzing table.. Let you know!!

grjohnson - Where abouts in york are u? I'm also in york!!

Quote:

---

Originally posted by krw
Nothing in alert file or .trc files...

I'm currently analyzing table.. Let you know!!

grjohnson - Where abouts in york are u? I'm also in york!!

---

PM me and I'll let you know.

Quote:

---

Originally posted by krw
grjohnson - Where abouts in york are u? I'm also in york!!

---

OK, but NO touching!

Interested in the company, thats all!!

Anyway, on a work note :- I tried to analyze the table but after 1 hour it was still running but wasn't getting anywhere!! It wasn't active anymore!!

Any ideas with what I can do?!

Thanks in advance...

Can you do a

select * from table_name where rownum < 50;

It may have a corruption in the table... but a block corruption is usually reported during a FTS or an analyze. Have you got indexes on the table?

This is strange :-

After trying to do a select count(0) with rownum < 50 (which worked) I kept upping the value until I did a FTS with select count(0) and IT WORKED!!!

Could the analyze of fixed this do you think?! I'll try another export and see what happens...?

Has the instance been restarted since yesterday?

Anyway, let us know how you get on.

Cheers,

Greg.