Tag Info

Hot answers tagged

5

I usually use a number(1) type combined with a check constraint: some_flag number(1) not null check (some_flag in (1,0)) To make things crystal clear I also add a comment to that table: comment on column some_table.some_flag is '0 is false, 1 is true'; so that the explanation on what "true" means can be seen when looking at the definition of the ...


1

Wouter got, hopefully, useful answers here: https://community.oracle.com/message/12608939 That said, being the Oracle ACE Director for this technology. Oracle XMLDB functionality is nowadays so interwoven with the Oracle database that this is an MANDATORY (install) functionality for Oracle 12c and onwards. It is the basis for much in the database like ACL ...


1

The alert log never has been under ORACLE_HOME/log. It is in $ORACLE_BASE/diag/rdbms/<sid>/<sid>/trace and is named alert_<sid>.log If you don't have $ORACLE_BASE, this typically is equivalent to $ORACLE_HOME/../../.. This is no different in 12c than it was in 11g (or 10g if I recall correctly). You can also use the ADRCI tool: ...


1

I can't personally think of anything better for on-the-fly resource throttling based on to-the-second stats than Resource Manager. It can be a bit of a hassle to set up, but I don't imagine how writing custom code wouldn't just be reinventing the wheel that is Resource Manager. I'm not aware of any reliable 3rd party vendors at this time. I do know that ...


1

It looks to me like the string you're passing in is too long for the UTL_RAW procedure you're trying to call. From the Oracle documentation: There is an error if the sum of the lengths of the inputs exceeds the maximum allowable length for a RAW, which is 32767 bytes. found here: http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/u_raw.htm#ARPLS072 ...


1

I recommend you use a SMALLINT column with a default value required (1=true, 0=false, default value = 0)



Only top voted, non community-wiki answers of a minimum length are eligible