| Subject | Date Asked | Expert |
|
| Describe command in oracle 10g | 11/19/2009 | Suchitra Joshi |
Q: Please help me with describe command for oracle 10g. I am getting error ora00900 for 'desc ...
A: You are getting this error because you must be using it in a SQL statement. 'desc' is not a SQL ...
|
| Using Sql Loader to run multiple instance parallely | 11/17/2009 | Peter Choi |
Q: I want to know , how to use the the sql loader to rum multiple instances parallely,Right now its ...
A: Here's an example of the syntax that invoke three SQL*Loader direct path load sessions on the same ...
|
| regarding CSV upload ! | 11/15/2009 | Suchitra Joshi |
Q: i would like to upload a CSV format file into my oracle database. As n when the file is loaded, i ...
A: To load the CSV file you can use the SQL*Loader utility. All the errors related to table constraints ...
|
| compare data in two columns | 11/11/2009 | Elliot Mak |
Q: I need to monitor the changes in two columns,example: Table 1 Line Id,Ship Date,Ordered Qty EAK ...
A: Jing, Assuming that the line_id is the primary key of the table. You can add an additional ...
|
| compare data in two columns | 11/11/2009 | Elliot Mak |
Q: I need to monitor the changes in two columns,example: Table 1 Line Id,Ship Date,Ordered Qty EAK ...
A: Jing, The solution that I had before is assumed the line_id is unique. Without an unique column, ...
|
| Connecting to Oracle server through firewall via VPN | 11/11/2009 | Peter Choi |
Q: I have a configuration where my Oracle client is located on my computer (Windows XP) in my office. ...
A: Two things you may wish to verify on your Oracle client (Windows XP). 1. Host file. Do you have a ...
|
| compare data in two columns | 11/10/2009 | Elliot Mak |
Q: I need to monitor the changes in two columns,example: Table 1 Line Id,Ship Date,Ordered Qty EAK ...
A: Good day Jing, Here is what you can do TABLE1 - data from yesterday TABLE2 - data from today The ...
|
| High load sql | 11/10/2009 | Peter Choi |
Q: How can i find out top high load sql queries in oracle. by querying performance views insted of ...
A: You can use STATSPACK (this is a separately licensed product from Oracle and is NOT free. It does ...
|
| Data Migration | 11/9/2009 | Peter Choi |
Q: I have to migrate my oracle database from oracle 9.2 to 10g release 2 on windows platform wht are ...
A: There are two popular ways (Oracle lists 4): Option A 1. Export your data from Oracle 9.2 2. ...
|
| awr report | 11/7/2009 | Suchitra Joshi |
Q: Respected Sir/Mam Question Number (1) drop table table1; FLASHBACK TABLE table1 TO BEFORE DROP ...
A: Check whether your table is in SYSTEM tablespace. If yes, then flashback drop won't work. Please see ...
|
| awr report | 11/7/2009 | Peter Choi |
Q: Respected Sir/Mam Question Number (1) drop table table1; FLASHBACK TABLE table1 TO BEFORE DROP ...
A: The detailed steps are listed here: ...
|
| awr report | 11/7/2009 | Binosh Mullassery-Padman |
Q: Respected Sir/Mam Question Number (1) drop table table1; FLASHBACK TABLE table1 TO BEFORE DROP ...
A: Hey San, How are you doing? Q1: Please run the following sql and check the value of VALUE ...
|
| oracle | 11/5/2009 | Binosh Mullassery-Padman |
Q: Respected Sir/Mam I am using oracle10gXe but I am not able to see the my database name. Is ...
A: How are you doing? If you want to see all the users in your database, then run the following ...
|
| oracle database | 11/5/2009 | Elliot Mak |
Q: Respected Sir/Mam I am using oracle10gXe but I am not able to see the my database name. Is ...
A: Good day San I assume that you are using Oacle10gXE on WIndows Platform. There is no table to ...
|
| RMAN Backup Database Instance | 11/5/2009 | Peter Choi |
Q: Can you explain me, is it possible to backup database instance by using RMAN. I have one database ...
A: What is RMAN? ...
|
| URGENT!!! pleaaaaaaaaaaseeeee | 11/4/2009 | Peter Choi |
Q: i've got a *.dmp file that i can't open! i've just read your answer to another question similar to ...
A: Here's a quick and simple Frequently Asked Question (FAQ) document from OracleFAQ's website. ...
|
| Data Guard Physical database | 11/4/2009 | Elliot Mak |
Q: Right now, I'm configuring DG Physical Standby on two separates servers, and I have to create ...
A: Good day This is what I understand from your question. (1) Configuration of DG Physical Standby ...
|
| Oracle data Guard Physical Standby Database | 11/4/2009 | Elliot Mak |
Q: Right now, I'm configuring DG Physical Standby on two separates servers, and I have to create ...
A: Good day This is what I understand from your question. (1) Configuration of DG Physical Standby ...
|
| save image using oracle10gXE | 11/4/2009 | Suchitra Joshi |
Q: Respected mam i am using oracle10gXE I want to store image on oracle 1og using sqlplus i ...
A: 1) Check that you have read permission on the directory mydir. If not grant it as follows - GRANT ...
|
| Regarding PL-SQL Developer Requirement | 11/3/2009 | Suchitra Joshi |
Q: I am having 2.10Yrs of experience in Application Support including PL-SQL.I have done OCP(DBA) and ...
A: Even if your project was only data related, you can add some points to indicate that you have used ...
|
| forms 6i | 11/3/2009 | Suchitra Joshi |
Q: I hav developed a form in forms 6i. This form is having one tabular layout data block say D1. No of ...
A: You can try the following code in your 'when-button-pressed' trigger on blk D2. go_block('D1'); ...
|
| Active sesions Problem | 11/3/2009 | Peter Choi |
Q: we are using 10g server, Every day from 10Pm to 11Pm Active sessions are increasing and effecting ...
A: Do you have any batch processing scheduled to run at or around 10PM? By scheduled batch process, it ...
|
| oracle 8i installation | 10/28/2009 | Suchitra Joshi |
Q: After installation, the SQL plus is started with scott/tiger.But once system restarts again the ...
A: I will require more information on this like what is the error shown for connection failed, which OS ...
|
| SQL Tuning | 10/27/2009 | Suchitra Joshi |
Q: I need you favor to tune the SQL, See below. The same kind of SQL is running parallely (9 SQL's) ...
A: You can check the following to fine tune this query - 1) Index created on table MCCDSS_QTR_HPFU_STG ...
|
| Oracle (No of Rows Into Single row) | 10/24/2009 | Suchitra Joshi |
Q: In Oracle I want to select No of rows into Single Row. For example (In the huge records) Name ...
A: There are multiple ways to get this result. The possible ways are listed at this site - ...
|
| oracle tuning | 10/24/2009 | Suchitra Joshi |
Q: Respected Sir I want to become a tuning expert of oracle but i dont know that which ...
A: Here are some links for performance tuning - ...
|
| oracle tuning | 10/24/2009 | Binosh Mullassery-Padman |
Q: Respected Sir I want to become a tuning expert of oracle but i dont know that which ...
A: How are you doing? These are the books I am using. And these are my bible for tuning ...
|
| Oracle | 10/23/2009 | Peter Choi |
Q: How to connect another machine Oracle database using Oracle SQL developer? I am using Oracle 11g. ...
A: http://download.oracle.com/docs/cd/E11882_01/doc.112/e12152/intro.htm#CHDHIFGJ and ...
|
| Csv data into oracle | 10/22/2009 | Suchitra Joshi |
Q: at present i am using mysql database but i want to convert my whole "mysql data" into oracle data ...
A: I am not sure of MySQL. But you could try a mysqldump to take backup. Basically create a customised ...
|
| Csv data into oracle | 10/22/2009 | Peter Choi |
Q: at present i am using mysql database but i want to convert my whole "mysql data" into oracle data ...
A: Take a look here: ...
|
| Csv data into oracle | 10/22/2009 | Suchitra Joshi |
Q: I want to load data from csv file into oracle database can u tell me step by step process for this
A: You will have to use SQL*Loader to load csv file to Oracle tables. For this you will have to create ...
|
| Csv data into oracle | 10/22/2009 | Binosh Mullassery-Padman |
Q: I want to load data from csv file into oracle database can u tell me step by step process for this
A: These are the steps. lets take the example of DEPT table in scott schema Description of this ...
|
| Csv data into oracle | 10/22/2009 | Edson |
Q: I want to load data from csv file into oracle database can u tell me step by step process for this
A: SQL Loader SQL*Loader (sqlldr ) is the utility to use for high performance data loads. The data can ...
|
| Oracle 11g install laptop spec | 10/21/2009 | Elliot Mak |
Q: Elliot, I wish to port my ORACLE 11g application and for demonstration purposes onto a laptop. what ...
A: Good day Debra, AS you know, Oracle database is mostly run on memory. Therefore, I will recommend ...
|
| howto map a user to a shared schema | 10/16/2009 | Peter Choi |
Q: we are using oracle 8.0.5...we have all tables in one schema called I_local..how can i map all users ...
A: You can create public synonyms and then grant privileges (SELECT, INSERT, UPDATE, DELETE) to a role. ...
|
| Creating multiple tables with Shell Script | 10/12/2009 | Suchitra Joshi |
Q: I'm looking for a pure sql Cum Shell solution to the problem described below. I'm a beginner in ...
A: Since I do not have access to any Unix m/c, I cannot try and test this code. But I suggest you do ...
|
| Creating multiple tables with Shell Script | 10/9/2009 | Suchitra Joshi |
Q: I'm looking for a pure sql Cum Shell solution to the problem described below. I'm a beginner in ...
A: Try the following - [code] #! /bin/bash tname="table" for i in * do sqlstr="create table $tname$i ...
|
| date in forms | 10/9/2009 | Suchitra Joshi |
Q: In my form there is 3 field 1)header_id 2)so_date 3) description here header_id is a disabled feild ...
A: I will require more details for this - 1) Is date field required field ? If yes, are you entering ...
|
| openings | 10/8/2009 | Suchitra Joshi |
Q: how are you? I required some information from you about opportunities on oracle. i am planning ...
A: You have many opportunities in Oracle - PL/SQL Developer, Oracle Forms/Reports developer, Oracle DBA ...
|
| oracle | 10/7/2009 | Suchitra Joshi |
Q: what are the differences between oracle 10g and 11g version? how can i check version of oracle from ...
A: 1) You can check the Oracle 11g features so that you can identify the differences with 10g for each ...
|
