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 188.8.131.52.0 Production on Mon Jan 14 23:57:19 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 184.108.40.206.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"
# 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.
firstname.lastname@example.org|M|#9 Example St, Example Town, AZ|999.999.9999
email@example.com|F|#8 Example St, Example Town, AZ|888.888.8888
firstname.lastname@example.org|F|#6 Example St, Example Town, AZ|666.666.6666
email@example.com|F|#2 Example St, Example Town, AZ|222.222.2222
firstname.lastname@example.org|M|#5 Example St, Example Town, AZ|555.555.5555
email@example.com|F|#0 Example St, Example Town, AZ|000.000.0000
firstname.lastname@example.org|M|#1 Example St, Example Town, AZ|111.111.1111
email@example.com|M|#3 Example St, Example Town, AZ|333.333.3333
firstname.lastname@example.org|F|#4 Example St, Example Town, AZ|444.444.4444
email@example.com|M|#7 Example St, Example Town, AZ|777.777.7777
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.