Oracle

Using Multiple Oracle Homes patchset application

Seeking details on how to apply an Oracle patchset using the Multiple Oracle homes technique. Scenario: 1. I have an Oracle home installation 10.2.0.1 in $ORACLE_HOME/db_1 which needs an Oracle patchset apply to it. Using Mulitple Oracle homes implies creating a new Oracle home, say /db_2,...

check box automation in Oracle Forms

I'm developing a form using Oracle Forms6i. I have 10 check boxes and one button named "select all". when i oress the select all button i want all the 10 check boxes to be checked. How to make check box checked automaticallyu. pls help

How to run oracle 10g forms without browser !!

I'm working on application using oracle 10g forms .. im done with it .. but i wanna run my application .. without the need to run browser with it . Is it possible ??? Please let me know and help me with it .

Getting "EXP-00091: Exporting questionable statistics." error on Oracle export

My boss is getting an "EXP-00091: Exporting questionable statistics." error - actually, several identical messages per table - when using the EXP utility to dump several tables in an Oracle database.  I'm not familiar with this utility, so I'm researching the problem for my boss.  The...

The most-watched IT questions this week: Oct. 20, 2009

Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

Does Oracle 6i have a metadata repository tool set

Does Oracle 6i have a metadata repository tool set

get a anr record from databse by using max (one Field) and orderby (one filed) desc

Hi, I have a table. It can have multiple records for the key value. Ex secid   time       source 1       02:04    a 1      02:04    b 2 3 Now i want only one record of secid for a descending orderby of (source) and for a max time stamp. and later i will join the secid with...

Five t-shirts to give away: Upload those profile pictures!

I've been noticing a dropoff in profile pictures lately -- here's a reminder on how to upload yours if you haven't already. If you're participating in the community, we want to know who you are! I'll be mailing out five t-shirts to the first five people (with eligible mailing addresses) to upload...

How do you load a CSV file into Oracle?

HOW TO LOAD .CSV FILE INTO ORACLE

Create an Oracle database in a specified location

how to create database at speciied location in oracle 10g

Deploying Oracle Database

I do have a database BankDB created on oracle 10g. I want to move this database into another machine. In SQL, you know we use attach and dettach to move databases. How could I do this in the oracle 10g? I'm waiting for your help. Thanks a lot Software/Hardware used: Software

Oracle Report 6i and Oracle 11g database

I have oracle 6i report under oracle 9i database.Now database is upgraded from 9i to 11g. So if I try to compile a report 6i under oracle 11g database then which kind of error might raised?

Sample etext template in Oracle BI Publisher

I am trying to create a simple BI publisher report using etext template.  But somehow I am not able to fit things together. I made the rtf format and uploaded into BIP as etext template, but when I view, it doesn't say anything. I guess there is some problem with the template. Is there any log...

regarding networking oracle 10g on linux

hi, this is regarding how to configure listener.ora and tnsnames.ora .can any body pls help me     thank u Software/Hardware used: oracle on linux

Most popular blog posts this week

10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

Bulk update for every 10k rown among 2L

Hi , Have a table in which 2lakh rows are present.I need to update a column and for every 10K i need a commit. Plese help me to write a script for this

calling trigger in oracle db 10g

hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows' history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I'm waiting for your help.                  ...

Oracle 10g Unable to connect the Report server

Im using forms 10g and reports , i have deployed forms and reports in internet explorer, im able to open the forms from the menu, but Reports its shoing unable to connect, i have created batch file for report to start automatically, still it is not connecting, im getting the same error, i guess i...

Community Announcement: Cash in your Knowledge Points for an Amazon gift card

Members who have earned over 1,000 Knowledge Points in the community by December 15th have the opportunity to cash in their points for Amazon gift cards -- just e-mail us at contactus -AT- itknowledgeexchange.com with your handle when you choose to cash out. You can also post here in the discussion...

Oracle 10g Acessing the Mapping between Sequences and tables

How to Find out the List of table name using or sharing any sequence in oracle Is there any Provision in Oracle 10g or upper versions Software/Hardware used: Oracle 10G