Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

unable to reinstall ORDS Beta 3.0 after uninstalling it

Summco_ChoiMar 30 2015 — edited Apr 1 2015

Tried to reinstall ORDS Beta 3.0 after uninstalling it but got below error. Pls provide clean steps to reinstall. Thx.

java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:58)

Caused by: java.io.IOException: Error executing script: ords_create_rest_users.sql Error: ORA-00922: missing or invalid option

Error starting at line : 48 in command -

create user ORDS_PUBLIC_USER identified by xx account unlock default tablespace USERS temporary tablespace TEMP

Error at Command Line : 48 Column : 54

Error report -

SQL Error: ORA-00922: missing or invalid option

Comments

unknown-7404
>
We have an excel sheet which contains a table(with datas) along with some comments(some extra information on table columns) below the table.We need to import only table data into oracle table.We dont need those comments data to be imported into the oracle table.Can you please let us know how to do it?

We have tried using import option and external table in sql developer.But we are not getting the desired result.
>
Well the obvious way is to delete the comments and load the data the traditional way.

If you are using 11g you could also write a simple filter program to filter the data and then specify the filter app in the external table PREPROCESSOR parameter.

See this Oracle article on how to use this feature
http://www.oracle.com/technetwork/issue-archive/2011/11-mar/o21nanda-312277.html

And this example Oracle-base article has an examplel also
http://www.oracle-base.com/articles/9i/external-tables-9i.php
>
11gR2 Updates
Oracle 11g Release 2 introduced the PREPROCESSOR clause to identify a directory object and script used to process the files before they are read by the external table. This feature was backported to 11gR1 (11.1.0.7). The PREPROCESSOR clause is especially useful for reading compressed files, since they are unzipped and piped straight into the external table process without ever having to be unzipped on the file system.
935684
Can you please tell how to write a filter preprocessor program for eliminating comments and only picking up desired table?
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2015
Added on Mar 30 2015
1 comment
1,733 views