Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    76

    Unanswered: DROP or DISABLE Constraints?

    Hi,

    When importing data using SQL Loader to an Oracle brand new Database what do you suggest??
    1- DROP all constraints (FKs e PKs), import data, and then RE-CREATE all Constraints (FKs e PKs)
    2- DISABLE NOVALIDATE Constraints, import data, and then ENABLE VALIDATE ou NOVALIDATE?

    Additionaly I must Drop any indexes existing before import and Re-Create them after, right?

    Thanks!

    Aucrun
    Last edited by aucrun; 02-10-11 at 12:10.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    2- DISABLE NOVALIDATE Constraints, import data, and then ENABLE VALIDATE ou NOVALIDATE?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Dec 2003
    Posts
    76
    Thanks!

    That was my first option too, and therefore I think I'll use the DISABLE and ENABLE.

Posting Permissions

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