| Subject | Date Asked | Expert |
|
| 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 ...
|
| About Advanced Replication (Updatable MView) and recovery of System datafile | 10/7/2009 | Suchitra Joshi |
Q: This is Mahesh, DBA - Reflexis Systems India Pvt. Ltd. from Pune(M.H), India 1. I want to Set an ...
A: Both of these are DBA questions and I think these can be answered properly by some expert DBAs. I ...
|
| opportunties | 10/7/2009 | Suchitra Joshi |
Q: how are you? I required some information from you about opportunities on oracle. i am planning to ...
A: You have many opportunities in Oracle - PL/SQL Developer, Oracle Forms/Reports developer, Oracle DBA ...
|
| orecal | 10/1/2009 | Suchitra Joshi |
Q: v can see the procedure that v created by select * from user_object where user_object ='procedure'.. ...
A: To check your procedure code, you can check the table user_source or all_source. select line, text ...
|
| sql query or cursor | 9/30/2009 | Suchitra Joshi |
Q: Fullname TIT NAME MIDDLENAME surname Mr rahul kumar shukla Mr rahul ...
A: Given the data with possible spaces in Title, middlename and lastname positions, this query is not ...
|
| impdp/expdp problem | 9/30/2009 | Peter Choi |
Q: I am using window server 2003 sp 1 and oracle 10g. When I am trying to import database using IMPDP ...
A: If you took a look at Reference 3, you will see that your error message is the same for IMPDP (the ...
|
| sql query or cursor | 9/29/2009 | Elliot Mak |
Q: Fullname TIT NAME MIDDLENAME surname Mr rahul kumar shukla Mr rahul ...
A: Here are the rules that I assume according to your question (1) If fullname contains [TITLE] [NAME] ...
|
| sql query or cursor | 9/29/2009 | Suchitra Joshi |
Q: Fullname TIT NAME MIDDLENAME surname Mr rahul kumar shukla Mr rahul ...
A: I did not understand your question properly. If anything is missing in fullname, do you want the ...
|
| impdp/expdp problem | 9/29/2009 | Peter Choi |
Q: I am using window server 2003 sp 1 and oracle 10g. When I am trying to import database using IMPDP ...
A: As you know, starting with Oracle 10g and higher, Oracle is recommending the use of the DataPump ...
|
| sql query | 9/26/2009 | Edson |
Q: I want to know that how to use flash back query if anybook please tell me I want to rollback The ...
A: ---Examples of FlashBack create table test_flashback (ab number(2)); insert into test_flashback ...
|
| sql query | 9/26/2009 | Binosh Mullassery-Padman |
Q: I want to know that how to use flash back query if anybook please tell me I want to rollback The ...
A: Good to see you again. How are you doing? I believe your requirement is to restore a table if ...
|
| sql query | 9/26/2009 | Peter Choi |
Q: I want to know that how to use flash back query if anybook please tell me I want to rollback The ...
A: Here's an excellent reference to Oracle Flashback. Reference: http://www.orafaq.com/node/50 In it, ...
|
| 10g specifications | 9/26/2009 | Peter Choi |
Q: at present iam using 1.HP make 2.Dual core intelxenon@3GHZ processor 3.6MB L2cache 4.667MHZS FSB ...
A: Which version of the OS are you running? Is it 32-bit or 64-bit version? Three things to take a ...
|
