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 ...
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...
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...
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;
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?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.