September 2010 Blog Posts (14)

Recover Dropped tablespace Using Flashback Oracle 11g R2

You can use this way to recover your dropped tablespace...

Added by Mohamed Azar on September 30, 2010 at 1:00pm — No Comments

yum to update kernel with Unbreakable Enterprise Kernel

I blog about using yum to update kernel, after Oracle has released the Unbreakable Enterprise Kernel for x86_64 servers via the Oracle Public Yum Server.

Added by Surachart Opun on September 29, 2010 at 12:36pm — No Comments

50% Discount on EBS R12 Financials Training Karachi

Any Business That hope to Survive, and Thrive,

Must Become an E-Business…


Added by Techno-Ed on September 28, 2010 at 12:29am — No Comments EDITION Attribute of a Database Service

11g Release 2 ( New Features - EDITION Attribute of a Database Service…


Added by Surachart Opun on September 27, 2010 at 10:00pm — No Comments

Snapshot Standby Database in Action

What happens if you increase the datafile size on the Snapshot Standby? Or if you create a new tablespace on it?
For the answers, look at

Added by Uwe Hesse on September 27, 2010 at 12:36am — No Comments

Find string in current schema

In some cases developer ask us to find some string in the particular
schema. So, I have develop one anonymous block to find the string in
tables. It will return the table name and column name in which value is

You can find the post at:

Added by GurJass on September 16, 2010 at 4:55am — No Comments

Oracle Champions is LIVE!!!!!

Please check out the BEST Oracle Community based forum available online at

here you can post and find oracle jobs, make new connections with other oracle consultants and post your suggestions and…

Added by Ashish on September 15, 2010 at 11:07am — No Comments

upgrade database =>

After I wrote about Oracle Database 11gR2 ( is available on Linux x86-64, x86.

It's time to test for upgrading. On my test system, I install Oracle

Grid Infrastructure for Standalone Server (ASM) and Database,

then test to upgrade =>…


Added by Surachart Opun on September 15, 2010 at 10:49am — 2 Comments

Oracle EBS Financial Module Training in Karachi

Dear Students

We do have many courses design as per student requirement . We are starting our new Oracle R12 E-business Suite Financial Module Customize Trainings . We will start From GL in Saturday & Sunday from 25th September 2010 .…


Added by Techno-Ed on September 14, 2010 at 5:44am — No Comments

Calling Web Services in PL/SQL using UTL_HTTP package

I wrote an article describes how to consume WebServices using the package UTL_HTTP and UTL_RAW. To create a testing WebService is used tools SoapUI. Finally, it describes the real consumption of WebService CDYNE Weather - Link to… Continue

Added by Martin Mareš on September 13, 2010 at 12:52am — No Comments

Data Guard & Oracle Restart in 11gR2

About the interaction of Oracle Restart (11gR2 New Feature) and Data Guard:

Added by Uwe Hesse on September 7, 2010 at 11:00am — No Comments

How to count arguments passed to an sql script?

Hi Legends,

May I know how can we count arguments passed to an sql script?


$sqlplus scott/tiger @abc.sql london tokyo singapore new_york toronto

Like here, i have passed 5 arguments to abc.sql.
How can I check in the script itself, the number of arguments passed to it?

Thanks very much in advance. Will appreciate your response.

Best Regards,

Added by Parry on September 3, 2010 at 11:36am — 2 Comments

RMAN:Restore datafiles to Nondefault location

You have just experiences a serious media failure and won't able to restore datafiles to their original location.In this case, you need to restore datafiles to a nondafault location.

You can use set newname and switch commands to restore datafiles to nondefault locations. You must set newaname command and the switch command from within a run{} block.

The switch command updates the target database controlfile with new location of…


Added by Mohamed Azar on September 1, 2010 at 3:13am — No Comments

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on 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



Blog Posts

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service