1 Reply Latest reply: Aug 2, 2013 9:04 AM by Chrisjenkins-Oracle RSS

    ttMigrate numThreads Option


      Can you please elaborate what is the numThreads option in ttMigrate restore?? Can it be used in all cases like DB backup have lot of tables with huge volume of data with FK reference?


      When I try to restore DB Backup using numThreads 2 I am getting the below error and its not restoring.


      tMigrate: Error received while restoring foreign key TABLE1_FK on table DG.TABLE1 -- 37000: [TimesTen][TimesTen ODBC Driver][TimesTen]TT3005: There is no unique index on the referenced columns for foreign key defined on table DG.TABLE1 -- file "eeConstr.c", lineno 990, procedure "sbEeFKConstrInit()" (TimesTen error code = 3005).

      Dropping partially-restored table DG.TABLE1...

      *** Table DG.TABLE1 was not restored.






      What could be the issue?

        • 1. Re: ttMigrate numThreads Option

          The numThreads option is intended to speed up restoration by performing some processing in parallel using multiple threads. The main operations that benefit are (a) restoring the data for large tables (many rows) and (b) index creation. When operating with multiple threads dependency checking is necessary to ensure that one thread is not performign an operation that may depend on an object that has not yet been created by another thread. This can slow things down in cases where there are not many large tables with many indexes.


          The error that you are seeing would appear to be a dependency checking bug. Please file an SR with all the necessary details so we can investigate.