Top Questions - Stack Overflow (Free subscription) | 21/11/2008
I've got a dbms_scheduler -Job running in Oracle 10.2.0. When I change the system date back to yesterday, the job will wait for one day to continue its work. The reason for this is that next_run_date does not change. Any suggestions on how to keep my job running with the configured interval (without having it to change manually)?
PHP Developper (Free subscription) | 27/10/2008
In this new post to his Oracle blog, Chris Jones shows how to set up DBMS_OUTPUT to work with the OCI8 extension available for PHP. Immediately after OOW, Alison and I have got straight into updating the Underground PHP & Oracle Manual. We've had our heads right down. [...] When reviewing the DBMS_OUTPUT section I tried using a PIPELINED PL/SQL function and found a significant...
Jobs 4 Careers (Free subscription) | yesterday
This is a permanent opportunity in Dayton, Ohio. Responsibilities for this role include performing the following duties: Provides analytical, technical, and administrative support for specific off-the-shelf Database Management Systems (DBMS) and pre/post processing software tools Provides technical assistance and input to project administrators and management on the planning and documentation...
Mixblog Team (Free subscription) | 15 hours ago
... electronic messages, mp3 & avi tags, and logs of MSN and ICQ instant messaging programs - Indexing DBMS fields (Lotus, SQL, Oracle) September 10, 2007 – SearchInform Technologies Inc. announces a new version of SearchInform, a corporate system of full text search and search for documents with similar content in large data volumes, featuring a conceptually new document indexing technology....
Mark Rittman's Oracle Weblog (Free subscription) | yesterday
... was still Bryan’s preferred method), the idea of writing a database function that uses a call to DBMS_LDAP to return a semicolon separated list of group memberships had not really struck me, he also gave the very sound piece of advice if you are implementing SSO, don’t activate it until you have tested your security model, as soon as SSO is on the repository security model is no longer usable...
Softpedia - Latest Mac software (Free subscription) | 23/11/2008
A small, plain-text, dbms written in Python. It can be used either embedded or client/server.
Softpedia - Latest Mac software (Free subscription) | 23/11/2008
A small, plain-text, dbms written in Ruby. It can be used either embedded or client/server.
CISA made easy (Free subscription) | 17/11/2008
1. Proper access control policy should be framed with regard to data file access and directory access while implementing Database Management system (DBMS). 2. Segregation of duties is a key area to... [[ This is a content summary only. Visit my website for full links, other content, and more! ]]
The Register (Free subscription) | 14/11/2008
'Big' data and the BI challenge Mainstream database management system (DBMS) technology faces a challenge from new approaches that reject the relational model. The battleground is set to be the market for business intelligence based on very large databases.…
Arkytek Ltd :: Blog (Free subscription) | 14/11/2008
‘Big’ data and the BI challenge Mainstream database management system (DBMS) technology faces a challenge from new approaches that reject the relational model. The battleground is set to be the market for business intelligence based on very large databases.… Full published article at: http://go.theregister.com/feed/www.theregister.co.uk/2008/11/14/large_databases/
Top Questions - Stack Overflow (Free subscription) | 13/11/2008
Hi everyone, I've got a quick question about default values in PL/SQL functions in Oracle. Take this program as an example; create or replace FUNCTION testFunction ( varNumber IN NUMBER DEFAULT 0 ) RETURN NUMBER AS BEGIN dbms_output.put_line(varNumber); RETURN varNumber; END; The idea here being that if no value is specified for varNumber when this function is called, then it will take the...
Top Questions - Stack Overflow (Free subscription) | 12/11/2008
What is the best way to replicate the update stream to a large (6TB) oracle db into another non-DBMS system? I don't need to "bulk load" the oracle db, but merely want to flow all updates into another home-grown system in near realtime (10s latency or less). Updates happen at the rate of 150 rows/second representing 10s of megabytes per second.
Top Questions - Stack Overflow (Free subscription) | 12/11/2008
My installation of APEX has come pear shaped on a Oracle 9.2.0.5.0 instance, all the packages are invalid. I've tried recompiling everything with DBMS_UTILITY.compile_schema, but still all the packages are invalid. So, tried recompiling individual packages, SQL> ALTER PACKAGE FLOWS_020000.WWV_FLOW_QUERY COMPILE BODY; Warning: Package Body altered with compilation errors. SQL> show err No errors....
Computerworld UK's Roundup (Free subscription) | 19/11/2008
"If for some reason you want to do straightforward high-volume OLTP on an open source DBMS, Ingres could be a decent choice. But in most cases you're better off going with a closed-source product, something from the Postgres family, or -- if it suffices -- MySQL," said Curt Monash, founder of Monash Research. "Having a legacy user base doesn't prove that a system is suitable for new customers...
Oracle in World (Free subscription) | 08/11/2008
Problem Description While I attempt to reorganize a table online whenever I do with DBMS_REDEFINITION.can_redef_table or DBMS_REDEFINITION.START_REDEF_TABLE procedure on the table it fails with error ORA-12091 as below. SQL> exec dbms_redefinition.can_redef_table('CR_2', 'OUT_CDR'); BEGIN dbms_redefinition.can_redef_table('CR_2', 'OUT_CDR'); END; * ERROR at...
