× Discuss on any other topics

connecting to ORACLE

  • Riswana
  • Topic Author
  • Visitor
  • Visitor
13 years 7 months ago #7280 by Riswana
connecting to ORACLE was created by Riswana
I installed ORACLE in my system and I could access it from sqlplus , sqlplus browser, enterprise manager... It works good and able to create table with my user TRGUSER (I granted all permissions to this user).

While I connect from jbase, the connection is successful and then i tried to create a ORACLE TYPE table FROM jsh as,

jsh-> CREATE.FILE TEST1 TYPE=XMLORACLE
It raises error as,

CREATE-FILE: *** ERROR *** Check XMLdriver.log for more details.

** Error [ JEDI_FILEOP_FAIL ] **
File operation failed, rc 5, for file TEST2]D

XMLdriver.log file shows error as,


R10.91634 - 6424 - (create-file.b,11) - Fri Apr 15 05:13:08 - - D_TEST2 - Error - ORA-01031: insufficient privileges


R10.91634 - 6424 - (create-file.b,11) - Fri Apr 15 05:13:08 - - D_TEST2 - comCreateTable: *** ERROR *** accCreateTable failed
R10.91634 - 6424 - (create-file.b,11) - Fri Apr 15 05:13:08 - - D_TEST2 - drvCreateFile: *** ERROR *** Failed to create the Database table


Could anyone please help me on this?

*THANKS IN ADVANCE*

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #10174 by durai611
Replied by durai611 on topic Re: connecting to ORACLE
Hi,

You can check the oracle error using the command,

$ oerr ora 01031

Kindly check the privileges of your user. Your user should have unlimited quota on tablespaces.

Please Log in or Create an account to join the conversation.

Time to create page: 0.068 seconds