Question about sql*loader: [message #73134] |
Thu, 12 February 2004 07:24 |
Nauj
Messages: 33 Registered: February 2004
|
Member |
|
|
I have to do a serie of load processes to Oracle tables. The data is
in flat files and I'm going to use the sql*loader utility to load data
into database.
I'm interested in the DIRECT_PATH option because the load time is important
in this processes. I know the with DIRECT_PATH = YES sql*loader is faster
loading because in this case it dosen't makes some validations.
For example: validations abouts blocks space, constraints are disabled,
it doesn't write in Oracle redolog and more...
The load time is important, but also query time. I don't if this kind of load
have an influence in the disposition of the data and in the time of resolving
queries.
With DIRECT_PATH = YES ...will be the queries of the load data lower???
Any information about this option will be good. Thanks in advance.
|
|
|