×
Discuss on any other topics
connecting to ORACLE
- Riswana
- Topic Author
- 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*
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.
- durai611
- Offline
- Elite Member
Less
More
- Posts: 300
- Thank you received: 51
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.
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