simplora.com
Simple Oracle: Copy specific files to another directory
http://www.simplora.com/2014/06/copy-specific-files-to-another-directory.html
A little bit about Oracle and more and more. Saturday, June 7, 2014. Copy specific files to another directory. Find -name "*14.06.07.1600*.dat" -print xargs -n1 -i cp {} /tmp/error. Subscribe to: Post Comments (Atom). Scheduled Job Running Shell Script Fails With ORA-27369. After DML on the Master Table(s) of Local Materialized View, USER MVIEWS.COMPILE STATE becomes 'NEEDS COMPILE' and USER OBJECTS.STATUS becomes 'INVALID' (Doc ID 264036.1). How to check Time Zone of Database. Nic-Out Filter for Smokers.
simplora.com
Simple Oracle: Scheduled Job Running Shell Script Fails With ORA-27369
http://www.simplora.com/2009/12/scheduled-job-running-shell-script.html
A little bit about Oracle and more and more. Sunday, December 20, 2009. Scheduled Job Running Shell Script Fails With ORA-27369. Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4. Oracle Server - Standard Edition - Version: 10.1.0.2 to 10.2.0.4. Sun Solaris SPARC (64-bit). Checked for relevance on 16-MAY-2008. ORA-27369: job of type EXECUTABLE failed with exit code: Operation not permitted. ORA-27369: job of type EXECUTABLE failed with exit code: 274662. 8217;: Permission denied". STANDA...
simplora.com
Simple Oracle: After DML on the Master Table(s) of Local Materialized View, USER_MVIEWS.COMPILE_STATE becomes 'NEEDS_COMPILE' and USER_OBJECTS.STATUS becomes 'INVALID' (Doc ID 264036.1)
http://www.simplora.com/2014/10/after-dml-on-master-tables-of-local.html
A little bit about Oracle and more and more. Friday, October 24, 2014. After DML on the Master Table(s) of Local Materialized View, USER MVIEWS.COMPILE STATE becomes 'NEEDS COMPILE' and USER OBJECTS.STATUS becomes 'INVALID' (Doc ID 264036.1). Oracle Database - Enterprise Edition - Version 9.0.1.0 and later. Information in this document applies to any platform. SQL select object name, object type, status from user objects. 2 where object type = 'MATERIALIZED VIEW';. OBJECT NAME OBJECT TYPE STATUS. This is...
simplora.com
Simple Oracle: Using Ref Cursors To Return Recordsets
http://www.simplora.com/2009/12/using-ref-cursors-to-return-recordsets.html
A little bit about Oracle and more and more. Thursday, December 17, 2009. Using Ref Cursors To Return Recordsets. Since Oracle 7.3 REF CURSORS have been available which allow recordsets to be returned from stored procedures, functions and packages. The example below uses a ref cursor to return a subset of the records in the EMP table. First, a package definition is needed to hold the ref cursor type:. CREATE OR REPLACE PACKAGE Types AS. TYPE cursor type IS REF CURSOR;. OPEN p recordset FOR. Set cmd = Ser...
simplora.com
Simple Oracle: Problem: Agent Start: Start agent fails with "The Oracleagent10gAgent service could not be started."
http://www.simplora.com/2009/12/problem-agent-start-start-agent-fails.html
A little bit about Oracle and more and more. Thursday, December 24, 2009. Problem: Agent Start: Start agent fails with "The Oracleagent10gAgent service could not be started.". Enterprise Manager Grid Control - Version: 10.2.0.1 to 10.2.0.3. Microsoft Windows Server 2003. After Agent installation, the following error occurs when attempting to stop and start agent:. Oracle Enterprise Manager 10g Release 3 Grid Control 10.2.0.3.0. The Oracleagent10gAgent service is not started. Nic-Out Filter for Smokers.
simplora.com
Simple Oracle: Find roles granted to users start with "X" or "T" following by any number
http://www.simplora.com/2013/11/find-roles-granted-to-users-start-with.html
A little bit about Oracle and more and more. Tuesday, November 12, 2013. Find roles granted to users start with "X" or "T" following by any number. Select grantee, GRANTED ROLE. From dba role privs. Where REGEXP LIKE(GRANTEE, ' [X T][0-9] $')order by grantee;. Subscribe to: Post Comments (Atom). Scheduled Job Running Shell Script Fails With ORA-27369. How to check Time Zone of Database. Handling Tricky Oracle Job Scheduling Problem! Nic-Out Filter for Smokers. Nico-Slim Filter for Smokers.
simplora.com
Simple Oracle: How to enable BlackBerry Z10 Rotation Lock
http://www.simplora.com/2013/12/how-to-enable-blackberry-z10-rotation.html
A little bit about Oracle and more and more. Saturday, December 7, 2013. How to enable BlackBerry Z10 Rotation Lock. Originally posted on the Inside BlackBerry Help Blog. Depending on how you are holding your BlackBerry Z10 device, you may want to lock the screen into portrait mode. To do this quickly, complete the following steps:. While viewing the BlackBerry Z10 Home screen, swipe down from the top of screen. Tap the Rotation Lock icon. Learn about a fe. Subscribe to: Post Comments (Atom). WM CONCAT f...
simplora.com
Simple Oracle: How can I improve font appearance in Google chrome?
http://www.simplora.com/2013/08/how-can-i-improve-font-appearance-in.html
A little bit about Oracle and more and more. Thursday, August 8, 2013. How can I improve font appearance in Google chrome? Chrome is reading your ClearType setting which on Windows XP is switched off by default. To fix the issue, first close the Chrome browser. Now right-click anywhere on the desktop and select 'Properties' from the drop-down menu. Click on the 'Appearance' tab found along the top on the new window. And click on the 'Effects' button. Select the "ClearType" option.