Does your schema owner have privs enough on hsd_navgrp_kw? If you swap that
out for an explicitly specified datatype for l_active_trigger, does it make
any difference?
Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-Original Message-
Sent: Tuesday, June 17,
Yes, it does. I just double checked that.
David Ehresmann.
-Original Message-
Sent: Tuesday, June 17, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
Does your schema owner have privs enough on hsd_navgrp_kw? If you swap that
out for an explicitly specified datatype for
Do 'other users' have any quota on 'BABAR_PAPERS_DATA' tablespace (where LOB
is stored)?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 8:15 AM
One of our developers has written
Resource on the tablespace should not matter. I don't want them to be able to create
segments, but to perform DML on the lob_segment already there. If I use sqlplus and
the dbms_lob functions in an anonymous pl/sql block then the insert is successful when
the privileges on the table are
A correction to my last the sql*plus program works with roles as well as direct grants.
Ian
-Original Message-
Sent: Tuesday, November 20, 2001 6:30 AM
To: Multiple recipients of list ORACLE-L
Perl
Do 'other users' have any quota on 'BABAR_PAPERS_DATA' tablespace (where LOB
is
Solved??. It seems update privileges are needed on the table even though the perl
script is doing an insert.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, November 20, 2001 5:15 AM
To: Multiple recipients of list ORACLE-L
Perl
Could it be, that it first creates a record with NULL in blob column using
EMPTY_BLOB(), and then updates blob column?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 3:35 PM
erl
Check your $ORACLE_HOME/rdbms/audit directory. If it is full, you will
get this error, as every time you try to login to svrmgrl connect
connect internal, a .aud file is created here.
Terry
Chuan Zhang wrote:
Dear all,I have this problem. When connect internal or connect /as
sysdba in