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

Monthly Archives

2017

2016

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

Oracle Blogosphere

Loading… Loading feed

Badge

Loading…

Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…

Continue

Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…

Continue

Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…

Continue

Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…

Continue

Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service