This discussion is archived
1 Reply Latest reply: Jan 15, 2013 8:53 AM by Charles Lamb RSS

External table

984892 Newbie
Currently Being Moderated
Hi,

I'm trying the new feature in v2 - External table and I got the following error after doing all the required steps:

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 14 23:57:19 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from nosql_data;
select * from nosql_data
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P000
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command /u01/nosql2.0/kv-2.0.23/exttab/bin/nosql_stream
encountered error "/u01/nosql2.0/kv-2.0.23/exttab/bin/nosql_stream: line 18:
java: No such file or directory"


SQL> !ls /u01/nosql2.0/kv-2.0.23/exttab/bin/nosql_stream
/u01/nosql2.0/kv-2.0.23/exttab/bin/nosql_stream

SQL>

--------------------

As you see, the file is exist, so I don't understand what is the problem.

when I do the following command, I get answers:

[oracle@MyHostName bin]$ ll
total 8
-rwxr-xr-x 1 oracle oracle 623 Jan 14 23:52 nosql_stream
-r-xr-xr-x 1 oracle oracle 483 Jan 10 16:25 ORIGINAL_nosql_stream.ORIGINAL
[oracle@MyHostName bin]$
[oracle@MyHostName bin]$
[oracle@MyHostName bin]$ pwd
/u01/nosql2.0/kv-2.0.23/exttab/bin
[oracle@MyHostName bin]$
[oracle@MyHostName bin]$ cat nosql_stream
#!/bin/bash

#
# See the file LICENSE for redistribution information.
#
# Copyright (c) 2010, 2012 Oracle and/or its affiliates. All rights reserved.
#
# Fill in site-appropriate values for PATH, KVHOME, and CLASSPATH
# This script will be executed by the Oracle Database server.
# If you are using user-specified Formatters, by sure to include their home
# in the CLASSPATH.
#

export PATH=$PATH
export KVHOME="/u01/nosql2.0/kv-2.0.23"
#export CLASSPATH="$KVHOME/lib/kvstore-2.0.23.jar"
export CLASSPATH="/u01/nosql2.0/kv-2.0.23/lib/kvstore-2.0.23.jar":"/u01/nosql2.0/kv-2.0.23/examples"
java oracle.kv.exttab.Preproc $*
[oracle@MyHostName bin]$
[oracle@MyHostName bin]$ ./nosql_stream /home/oracle/exercises/noSQL/ExternalTableLocation/nosql.dat

user9@example.com|M|#9 Example St, Example Town, AZ|999.999.9999
user8@example.com|F|#8 Example St, Example Town, AZ|888.888.8888
user6@example.com|F|#6 Example St, Example Town, AZ|666.666.6666
user2@example.com|F|#2 Example St, Example Town, AZ|222.222.2222
user5@example.com|M|#5 Example St, Example Town, AZ|555.555.5555
user0@example.com|F|#0 Example St, Example Town, AZ|000.000.0000
user1@example.com|M|#1 Example St, Example Town, AZ|111.111.1111
user3@example.com|M|#3 Example St, Example Town, AZ|333.333.3333
user4@example.com|F|#4 Example St, Example Town, AZ|444.444.4444
user7@example.com|M|#7 Example St, Example Town, AZ|777.777.7777


------------------------

Thanks in advanced,
Yosik
  • 1. Re: External table
    Charles Lamb Pro
    Currently Being Moderated
    Yosik,

    The problem is that the "java" command is not in $PATH in the Oracle DB environment. You could try to either explicitly put the directory that holds java in the PATH in the nosql_stream script or just put the path right in line 18.

    Charles

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points