Billy,
I am using external tables to load data from a data file to an Oracle
tables (instead of using SQLLoader).
Before we create an external table, we use CREATE OR REPLACE DIRECTORY
testing AS '/../../../testing/' command.
The data file(s) should be in that (testing) directory.
After creating the external table, we load the data from external
table to the existing table,
then the log files and the bad files go to the 'testing' directory
where the data files are.
Now my request: I need to chang the code so that the log files and the
bad files go to a specified
directory which I specify in the 'create directory.... (.sql) script.
How to specify that ?
vs****@onwe.co.za (Billy Verreynne) wrote in message news:<1a**************************@posting.google. com>...
he*****@yahoo.com (Erohsik) wrote in message
I am using external tables to load data from the data file. But the
log files
are getting created in the datafile's directory (because of CREATE OR
REPLACE DIRECTORY ...)
But I want those log files get created in a perticular directory. How
can I do that ?
Parsing error. Provide more detail.
What external tables? Are you loading into a remote db via an Oracle
db link?
What log files? CREATE DIRECTORY is for using BFILES. Not log files
(as in alert log, sql loader log, import log) files.