External Table Logs

I created a external table with the following detail.

The external table is created with: NODISCARDFILE NOLOGFILE options.

File is loaded through:
/mydata/myUAT/processing/myfile

Once the file is loaded, I want to know where i can access log of data loaded into external table.?
In sqlloader, i would specify the path for discard file, bad file, where can i find these logs when data is loaded
through external table.


CREATE TABLE myTable
  (
      col1 number,
      col2 varchar2,
      ..
      coln varchar2
ORGANIZATION EXTERNAL
  (
    TYPE ORACLE_LOADER DEFAULT DIRECTORY "myDIR" ACCESS PARAMETERS
      ( records delimited BY newline NODISCARDFILE NOLOGFILE FIELDS TERMINATED BY ','
      OPTIONALLY ENCLOSED BY '"' missing field VALUES are NULL
      ( col1, col2, col3..,coln ) ) LOCATION (
    "myDIR":' dis' )
gram77Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
BADFILE should be in the DEFAULT DIRECTORY.
0
gram77Author Commented:
where do i find the default directory
0
slightwv (䄆 Netminder) Commented:
Look at the command you issued:

...
TYPE ORACLE_LOADER DEFAULT DIRECTORY "myDIR"
...

Y

ou can look in the database view user_directories to confirm "myDIR" is set to: /mydata/myUAT/processing/myfile
0
gram77Author Commented:
/mydata/myUAT/processing/myfile
contains only two files: dis and his

The table defination also contains: NODISCARDFILE NOLOGFILE. Does this mean that no log file will be generated, or the log file will be generated somewhere?
0
slightwv (䄆 Netminder) Commented:
Yes, NOLOGFILE means no log file is created.

Always go to the docs for explanations of parameters:

http://docs.oracle.com/cd/E11882_01/server.112/e22490/et_params.htm

NOLOGFILE is used to prevent creation of a log file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.