Re: insert or load ? best practices and performance
Posted by:
Rick James
Date: September 20, 2010 06:28PM
> perror 2
OS error code 2: No such file or directory
forward slashes? backward slashes? spelling of filename?
I deliberately put the RENAME after the LOAD -- that way the old table would be available until the instant the RENAME is done. (This may not be important for your situation; it is for some people.)
Subject
Views
Written By
Posted
3579
September 16, 2010 01:19PM
1070
September 17, 2010 09:27AM
989
September 21, 2010 11:16AM
970
September 21, 2010 03:29PM
1009
September 17, 2010 06:37PM
954
September 20, 2010 06:44AM
898
September 20, 2010 10:43AM
1030
September 20, 2010 12:49PM
Re: insert or load ? best practices and performance
1088
September 20, 2010 06:28PM
969
September 21, 2010 06:52AM
941
September 21, 2010 11:07AM
942
September 22, 2010 12:14PM
1019
September 22, 2010 07:20PM
1044
September 23, 2010 08:17AM
881
September 23, 2010 09:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.