Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    121

    Unanswered: quickest way to fix check pending

    how to quickly keep table out of check pending after load and strart from scratch?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Assuming you are on LUW,

    Are you looking for something like
    SET INTEGRITY
    statememt

    SQL Reference will have the correct syntax ..

    Please read 'Must Read BEfore Posting' thread at the top of the forum

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2003
    Posts
    121

    Bypass integrity check

    Yes,'set integrity' but we want to bypass integrity check and remove pending status to full acces..
    thanks!

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    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.

  5. #5
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    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.
    David Quigley

  6. #6
    Join Date
    Aug 2004
    Posts
    330
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •