View previous topic :: View next topic
|
Author |
Message |
Tim Jones
New User
Joined: 22 Jul 2011 Posts: 11 Location: USA
|
|
|
|
I'm ttrying to reload the table. The first step is to DELETE OLD TABLE ROWS. This is where I am getting the -904. Can anybody tell me how to recover so I can reload the table ????
Thanks |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
If you use RESUME NO REPLACE option on the load then you do not have to delete the rows first.
Now you need to reset the Check Pending and/or the Recovery Pending Flags.
The try your load as stated above. |
|
Back to top |
|
|
Tim Jones
New User
Joined: 22 Jul 2011 Posts: 11 Location: USA
|
|
|
|
Thanks, It appears to have worked. I need to reset the flag and rebuild the indexes.
Thanks Again |
|
Back to top |
|
|
|