May 2010 Blog Posts (17)

Transport the tablespace Same OS platform

You want to transport tablespaces using RMAN backups instead of performing the transportable tablespaces operation on the live production database.

From here also http://mohamedazar.wordpress.com/2010/05/29/transport-the-tablespace-on-same-os-platform/

Source Database : MYTEST

Target Database : MYDB

Transportable…

Continue

Added by Mohamed Azar on May 29, 2010 at 5:53am — No Comments

SOA Case Studies

Have companies been able to realize the promise of SOA? Here is the proof

Financial

Bank of Baroda

First Horizon

Guardian

Helvetia Patria

Synovus Financial

AFLAC Inc.

Standard Bank South Africa

Large Australian bank uses SOA for introducing new products

Large Scandinavian bank uses SOA to reduce personal loan origination…
Continue

Added by SOA Trainer on May 28, 2010 at 9:34am — No Comments

Avail online Oracle Demantra Training: Starts 29th May 2010

Our new batch of online Oracle Demantra Training is commencing on 29 May 2010.



Why this training is…
Continue

Added by Focusthread Ltd on May 28, 2010 at 4:42am — No Comments

Avail online Oracle ERP Development Training- Starts 29th May 2010

Our new online course on Oracle ERP Development Training is commencing on 29th May, 2010



Why this training is necessary?




Oracle Enterprise Resource Planning (ERP) promotes a fully integrated systems approach, enables companies to cut costs, operate more efficiently, be more responsive to Client demand, reduce turnover and assist staff in reaching peak…
Continue

Added by Focusthread Ltd on May 28, 2010 at 4:22am — No Comments

Avail online Oracle Demantra Training- Starts 29th May 2010



Our new batch of online Oracle Demantra Training is commencing on
29 May 2010.



Why this training is…
Continue

Added by Focusthread Ltd on May 28, 2010 at 3:07am — No Comments

Create duplicate database using rman

You want to use RMAN to create a duplicate database on the same server by using RMAN backups.

Source database name is MYTEST

Target (duplicate) database name is MYDB

This is the simple steps to create a duplicate database

You can read from here…

Continue

Added by Mohamed Azar on May 25, 2010 at 11:33am — No Comments

Self-Service Human Resource (SSHR)

Self-Service Human Resource



SSHR stands for Self-Service Human resource. In Organizations this particular module helps in managing self service

functions at both manager level as well as employee level. One basic

advantage in using SSHR is it saves your time & money by giving the

related functions access to employee for changing their Personal

information for eg.: if an… Continue

Added by abhishek sharma on May 25, 2010 at 3:41am — No Comments

Update under the hood ... and some extreme side effects

If you want to read about how UPDATE works at block level and some ugly cases where you can flood the blocks and waste space, follow this link for English version UPDATE under the hood ...and some extreme side effects... or follow this link for Spanish text UPDATE interno... y sus efectos secundarios.



Hope you find it useful, please… Continue

Added by Ignacio Ruiz on May 24, 2010 at 5:00am — No Comments

Restoring old Optimizer Statistics for troubleshooting purpose

Since 10g, we do not simply overwrite old optimizer statistics by gathering new. Instead, the old optimizer statistics are automatically historized and kept for one month by default, so that they can be restored easily if that should be desired. Here we go with a short demonstration of restoring historic optimizer statistics…

Continue

Added by Uwe Hesse on May 19, 2010 at 8:10am — No Comments

Granule size

I wrote about Granule size and some example (and fake to test from granule 4M -> 16M when have memory limited)
http://surachartopun.com/2010/05/granule-size.html

Added by Surachart Opun on May 18, 2010 at 1:10pm — No Comments

Character Set migration Oracle 11g

When i tried to transport the tablespace from linux to windows, during import it shows charachter set error, so I just looked on linux database and windows database character set is different .

Linux is WE8IS08859P1

Windows is AR8ISO8859P6

So i plan to migrate the charater set of windows and change to WE8IS08859P1 character set. Here I provided step by step guide , How to migrate character set. I play with…

Continue

Added by Mohamed Azar on May 18, 2010 at 4:45am — 1 Comment

Oracle HRMS Job Opportunity

I have an excellent opportunity (Permanent) with a client of mine in Kansas City for a senior level Oracle HRMS (Payroll) and Oracle Financials Expert. I have a full job description I can send your way if you or anyone you know might have interest!



• This position will be responsible for the business requirements analysis, process modeling standards, and related business process documentation for both commercial off the shelf (COTS) and custom application environments.

• Leads…

Continue

Added by Jill Dryer on May 17, 2010 at 10:38am — No Comments

Index Dynamics - Part 3

Continuing with this series, where you can explore real life observations for regular Index behavior, within a living ERP system. This post present final results for this experiment, both in English Index Dynamics - Part 3 and Spanish Dinamica de Indices - Parte 3. I'll share a small recommendation derived from experiment: try not rebuild indexes before high… Continue

Added by Ignacio Ruiz on May 12, 2010 at 5:00am — No Comments

BACKUP AND RECOVERY: BLOCK RECOVERY IN RMAN

Block media recovery recovers an individual corrupt datablock or set of datablocks within a datafile. In cases when a small number of blocks

require media recovery, you can selectively restore and recover damaged

blocks rather than whole datafiles.
More please visit.…



Continue

Added by Rajeshkumar Govindarajan on May 7, 2010 at 3:30am — No Comments

Index Dynamics - Part 2

More than a year ago started a series of posts about Index Dynamics (initial post click here), don't know why, but updates on Oracle Community were miserably forgotten... anyway, today will resume and share with you real life results with a set of indexes from a live ERP system, armed with tools like statement ANALYZE INDEX and table INDEX_STATS. Full English text is available here… Continue

Added by Ignacio Ruiz on May 6, 2010 at 6:00am — No Comments

BLOCK RECOVERY Without Having RMAN Backup

Block media recovery recovers an individual corrupt datablock or set of datablocks within a datafile. In cases when a small number of blocks

require media recovery, you can selectively restore and recover damaged

blocks rather than whole datafiles.




for more information and reference

please…
Continue

Added by Rajeshkumar Govindarajan on May 5, 2010 at 1:30pm — 2 Comments

Command Line History and Editing in SQL*Plus and RMAN on Linux

In windows you have option of using up and down arrows for previously used sql statements and rman commands. But in Linux operation system with in sql*plus and rman prompt, not possible to use the up arrows and edit the previous used commands and statements.…
Continue

Added by Rajeshkumar Govindarajan on May 5, 2010 at 5:30am — No Comments

Blog Topics by Tags

Monthly Archives

2015

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

What Benefits Does an MCSE Certification Carry?

MCSE certifications are the most popular certifications around the world. And, their popularity isn't without reason. In the following post I have highlighted the benefits that you can derive from an MCSE certification, so as to help you gauge how useful it can be for your career. Read on to know.…

Continue

Posted by Michael Warne on May 28, 2015 at 1:32am

Default Login Form customize

Dear All, I want to customize oracle 10g default login page. How can I do this. I attached the login page for better understanding.

Posted by Shakaouth Shanto on May 19, 2015 at 10:00pm

Live SAP Hybris Online Training Classes at VirtualNuggets

Web URL      :  http://www.virtualnuggets.com/sap-hybris.html

Email              :  info@virtualnuggets(dot)com

Contact           :  +1-7076668949(USA)         +91-8885560202(India) 

 

Live SAP Hybris Online Training Classes at VirtualNuggets

 

SAP Hybris is a standout amongst the most widely recognized e-commerce platforms       on the Internet…

Continue

Posted by Virtualnuggets on May 12, 2015 at 11:14pm

TIBCO BE Online Training

TIBCO BE Online Training

                                          

            We are Glad To Announce That TIBCO BE Online Training Offered by Industry real time Experts at VirtualNuggets Institute. we are offering TIBCO BE Online Training with a customized course design, The Learners who participate in our online training sessions will able to easily grab the required skills of TIBCO BE Which needed to solve integration challenges in real…

Continue

Posted by Virtualnuggets on May 6, 2015 at 11:27pm

© 2015   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service