Database Tip & Trick

For Loop in PL/SQL

2011-11-25T05:16:00.000-08:00

One of the statement in oracle I use most is for loop in pl/sql. This for loop is very handy to use and the basic statement comes like this: for variable in 1..x loop statement; end loop; The reverse loop statement is: for variable in reverse 1..x loop statement; end loop; The example code comes like this for v_cnt in 1 .. 100 loop insert into table_x (pk,

PL/SQL Best Practices

2011-04-12T13:57:00.000-07:00

PL/SQL Best Practices with Steven Feuerstein Renowned Oracle PL/SQL expert, Steven Feuerstein, presents "PL/SQL Best Practices" -- offering high-level principles to guide our work. Here are some example of the PL/SQL best practices derived from PL_SQL_Best_Practices2.pdf: DEV-01: Set Standards and Guidelines for Your Application Before Anyone Starts Writing DEV-02: Ask for Help if you find

Database Change Tracking for Oracle

2011-04-12T13:51:00.000-07:00

It has often been said that the only constant is change. IT's ability to manage change is an important business success criteria in today's competitive markets. Change can either be planned or unplanned. This presentation will help you understand the effects of change, and how to manage change properly. It will help database administrators better prepare to implement changes and measure the

Automating SQL Optimization

2011-04-12T13:49:00.000-07:00

Quest® SQL Optimizer for Oracle proactively identifies potential performance issues and automates SQL optimization by scanning and analyzing running SQL statements, PL/SQL, or other source code. * The value of SQL tuning to you and your organization * What the ideal solution looks like * How to use the key functions and new features in Quest SQL Optimizer for Oracle v7.2

Common Mistakes in Oracle PL/SQL Programming

2011-04-12T13:27:00.000-07:00

I just came a cross this video about oracle pl/sql programming, which provide good technique to write pl/sql code. Very good video to take a look for pl/sql programmer. You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to skip over unnecessary lines of code? If slip-ups like these sound familiar (or if you don't know why these are

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

2011-03-22T14:43:00.000-07:00

Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has

ORA-12154: TNS:could not resolve the connect identifier specified

2011-03-22T14:26:00.000-07:00

Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could

SQLLoader with text file format

2010-11-11T23:52:00.001-08:00

When loading text file into db via sqlloader, there might be the case that varchar2 column with Thai character data turn out weird (i.e. instead of showing "รถยนต์นั่งไม่เกิน 7 คน" it turn out to be "เธเธฃเธ เธฃเธ–เธขเธเธ•เนเธเธฑเนเธเนเธกเนเน€เธเธดเธ 7 เธเธ"). The cause of this problem, from what I experienced, is that the format/encoding of text file is invalid. To solve this you

Save your foreign key constraint before dropping table

2010-10-28T03:26:00.000-07:00

There might be the case that you find it difficult to recreate the table with another table having foreign keys dependent on it. When you need to recreate the table that mean you need to drop that table first. Apart form losing data and other objects related to that table you will also lost foreign key constraint on every tables which referring to it. There is a little tip top help you get all

solaris UX: useradd: ERROR: Inconsistent password files. See pwconv(1M).

2010-08-22T11:14:00.000-07:00

When trying to add oracle user on unix or linux there might be the case that you get the following error: solaris UX: useradd: ERROR: Inconsistent password files. See pwconv(1M). Here are steps to fix this problem, and what cause this error. The reason behind thi s error is that the /etc/passwd and /etc/shadow files are out of synchronization on your machine. To fix this, run the following

ORACLE RAC 10g

2009-11-05T13:06:00.000-08:00

Oracle Real Application ClusterThe video talk about Oracle RAC architecture there are 2 parts of it.Video IVideo II

Oracle RMAN Demonstration

2009-11-05T13:05:00.000-08:00

Oracle RMAN Setup Tutorial

"Oracle RAC - Why VIPs" by Alex Gorbachev

2009-11-05T13:02:00.000-08:00

This videocast explains Vitrual IP (VIP) usage in Oracle Clusterware 10g and 11g - why they are needed and how they are used. A must know for any Oracle RAC DBA.

Oracle Security Alerts: Oracle Critical Patch Update July 2009

2009-07-15T15:15:00.000-07:00

The Critical Patch Update for July 2009 was released on July 14, 2009. Oracle strongly recommends applying the patches as soon as possible.The Critical Patch Update Advisory is the starting point for relevant information. It includes the list of products affected, pointers to obtain the patches, a summary of the security vulnerabilities for each product suite, and links to other important

What are Data Recovery Services?

2009-05-22T15:23:00.000-07:00

You may notice a lot of online data businesses are nowoffering several different services to customers wholike to play it safe and prepare for the worst.Some of the services they offer include online andoffline secured data storage and data recoveryservices.The purpose is to protect what we spend several hourstyping up and it is like they are saying "We’ve gotyour back" so you don’t need to worry

Ways to prevent Data loss

2009-05-20T15:21:00.000-07:00

When your computer becomes the most used piece ofequipment you have, you spend countless hours sittingdown typing important information down so you don’tlose anything.It may also be the way you earn your living so thelast thing you need is some serious time off becauseyour computer has failed.There are several ways that you can prevent the lossof data and it doesn’t cost a fortune.The most common

Data Recovery Techniques due to Physical Damage

2009-05-20T15:16:00.000-07:00

You may have lost some data recently and you need tobe able to recover it. This is easier than ever to doand the cost is minimal.You can always have your data stored professionally toavoid losing your data and without being invaded andinterrupted.These programs are available online and canperiodically save your data while you relax and keepworking.Data recovery techniques are complicated if you

What Physical Damage can do to your Data?

2009-05-19T15:26:00.000-07:00

Physical damage is not like picking up your computerand slamming it down on the floor or carrying it up aflight of stairs only to drop it at the top.Physical damage can occur in several ways.You use your computer’s hard drive everyday notrealizing that every time you use it you are puttingyour computer at risk of a malfunction that can loseyour data and be hard to recover it all

The importance of Data Recovery

2009-05-19T15:20:00.000-07:00

With technology today records and other importantdocuments are now kept on computers instead of thetraditional pen and paper style of bookkeeping.People put a lot of faith into computers and trustthat they will always provide the documentation thatthey store forever. Most of the time people do not seethe need for a back up system to recover any data thatmay get lost or they may think that it is

Data Recovery Tools

2009-05-19T15:17:00.000-07:00

When you lose your data for what ever reason you wantto be able to recover it with minimal complication andtime.In order to do that you may need to purchase a datarecovery tool kit that is designed to help you recoveryour data on your own without any help on or off line.Data can be lost quickly and may have been importantto you for personal reasons or for work.Sometimes accidents happen and you

Data Recovery Offline Solutions

2009-05-19T15:16:00.001-07:00

Losing your data is an unexpected time consumingproblem that may stop you from working depending onwhy your system crashed to begin with; mechanical orphysical.Either way you are stuck until you fix your system orpurchase a new one.If you purchase a new one you still need to accessyour data from your damaged computer system in orderto transfer files, documents and other importantinformation that

How you can lose Important Data

2009-05-15T15:18:00.000-07:00

When you lose your data you may lose very importantinformation; birthdays, appointments, contactaddresses, homework assignments, work documents andother important information that you stored on yourcomputer not realizing that you could lose it.Maybe it was a page you had pulled up and working onwhen someone came in to talk. During the conversationa button may have been pushed and all of your

Online Data Recovery Solutions

2009-05-10T15:19:00.000-07:00

Losing your data usually occurs when you don’t havethe extra time to fix the problem. You may rely onyour computer for work or you may use your homecomputer to keep track of important personal files.Whatever your reason you are going to be lost withoutyour data so you need to find a quick easy solution torestore your data quickly and easily so you don’t haveto go long without those important

Oracle Compatibility Developer's Guide for DBAs & Application Developers

2009-05-04T03:52:00.000-07:00

Get white paper on Oracle Compatibility Developer's Guide for DBAs & Application Developers by EnterpriseDB at http://research.bizreport.com/detail/RES/1240871902_713.html?li=201125&src=KA_RES_20090504&asrc=EM_KAR_6782029&uid=4401398Below is the abstract.In today's challenging economic climate, organizations running Oracle are struggling to meet rising information demands with constricted budgets

What is Data Recovery?

2009-05-02T15:25:00.000-07:00

Data recovery is the process of saving the informationthat you can no longer get to by using the normalsource. Without being able to reach your data you maylose important documents and information that youcannot find anywhere else.Data recovery will help you to recover thatinformation even if your system has crashed. There areseveral ways you can recover the information and youcan do it yourself