Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by biggusdeeus

  1. biggusdeeus

    Bulkloading Performance Question

    Well, I was not asking specific for our tools, just for any bulkloader. But to answer your question - I don't know about complex triggers or foreign keys - I don't think so. But we don't have huge tables. There are a lot of relationships ...
  2. biggusdeeus

    Bulkloading Performance Question

    Hi Dima. Actually, it's our s/w interface to sql - I was just needing a point of reference, you know the customer will always want something faster. But there is a big difference between my 1.8 sec per object and their .072 sec per object (~ 13 objects per second). I am inclined to tell them...
  3. biggusdeeus

    Bulkloading Performance Question

    This is one of those "depends" questions, but I need a general idea for reference; Customer complains that 7,888 objects take 9 min 30 secs to load. That translates to .072 seconds per object. Using the same load file, I can only get 1.8 sec per object. I assume the difference is mostly with the...
  4. biggusdeeus

    ORACLE error 1452 on Virtual machine

    Thanks, Dima. Makes sense, so I dropped user and tablespace from the command line before reattempting the import, but same results drop user spf36admin1 cascade; drop tablespace spf36admin1space including contents cascade constraints;
  5. biggusdeeus

    ORACLE error 1452 on Virtual machine

    Thanks - but the problem is that the user and tablespace were dropped (via bat file) prior to the import - so there should be nothing there to truncate, correct?
  6. biggusdeeus

    ORACLE error 1452 on Virtual machine

    Hi - I'm having problems importing a customer's dump files on a virtual pc. I have imported the same files on a host pc with no problem. The users and tablespaces are unique. So it's confusing as to why it happens on one and not the other. The error is happening once about 1/3 into the import...

Part and Inventory Search

Back
Top