var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: quickest way to fix check pending
how to quickly keep table out of check pending after load and strart from scratch?
Assuming you are on LUW,
Are you looking for something like
SQL Reference will have the correct syntax ..
Please read 'Must Read BEfore Posting' thread at the top of the forum
Visit the new-look
, register to gain access to the excellent content.
Bypass integrity check
Yes,'set integrity' but we want to bypass integrity check and remove pending status to full acces..
Check pending state is probably because of foreign keys. If you would like to load data without doing the "set integrity" command at the end to move the table from check pending state to normal state, there is one more option:
1. Drop foreign keys,
2. Load tables
3. create foreign keys.
But be carful - droping foreign keys can be dangerous - because you don't have the referencial integrity.
you can use the non-recoverable option on the load command, it will leave the table in a useable state, but it assumes all your data is good. Make sure you have a good data.
There are 2 ways that I know of (the first is more destructive):
1. Drop the tablespace will remove the flag.
2. START ACCESS(FORCE)