	AllExperts > Experts
	Search

About Peter Choi
(Top Expert on this page)

Expertise
I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with 10 years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and 8.9), Oracle RDBMS (7.3 - 10gR2) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.

You are here: Experts > Computing/Technology > Oracle > Oracle

Questions Answered By Expert Peter Choi
In Category Oracle

Subject	Date Asked

DBA Questions	10/10/2008
Q: I have some question can u give me the ansers. 1. If i lost all controlfile and i have no backup ... A: Here's a great reference site for technical interview questions and answers: ...
Oracle 9i and 10g client on same pcs	10/9/2008
Q: I have a property application running on 9i and CadcorpSIS GIS on 10g. I would like to use the same ... A: You should be able to just install and use the Oracle 10g client on your workstation and configure ...
SYS password	10/7/2008
Q: If i forgot my sys password then how can i login as sys user if i am not using password file . ... A: Reference: http://forums.oracle.com/forums/thread.jspa?threadID=375629 Log on to the machine where ...
oracle license	10/6/2008
Q: do license really very important , I want buy CD and install it in one computer which will be the ... A: Oracle has two different licensing plans that allows companies and organizations to choose what ...
Use like in subquery	9/30/2008
Q: I would like to be able to use the results of a subquery in the where clause of the outer query ... A: The LIKE clause is used as part of string/substring type search. What you're looking for is the IN ...
Security	9/24/2008
Q: Some times I cant see the page or component although i have granted access to the page/comp in the ... A: I'm assuming that you're referring to the PeopleSoft application security. When you've been granted ...
Ms Sql and Oracle Back up	9/23/2008
Q: What is the procedure for taking backup of a database created in MsSql and Oracle A: I'll refer you to http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ on the subject ...
Global Temp Table in Oracle 9i	9/22/2008
Q: Can i drop a global temporary table in Oracle 9i?? Gives an error if i try! A: If you have DBA privileges, you can drop the global temporary table in Oracle 9i. If, however, you ...
Using Group By by Date with subquery	9/19/2008
Q: I am writing a query to consolidate data in a table by Date. Currently data in this table are sells ... A: The error is caused by this: http://www.dba-oracle.com/t_ora_00979_not_a_group_by_expression.htm ...
SQL statements explained in layman terms	9/11/2008
Q: I am learning Oracle and am trying to understand what this SQl statement is saying in Layman's ... A: The SQL construct is meant to be an easy to follow language. Now having said that, it can get ...
Inactive/Active session	8/28/2008
Q: i have a doubt,can you please inform/clarify if an Databae Inactive session having last_call_et as ... A: The LAST_CALL_ET column indicates how long the session has been idle. So yes it is possible for it ...
Listener	8/20/2008
Q: Here I'm again, I don't have enough knowledge about Oracle, I read something about listener but how ... A: ---------- Listener ---------- There are three ways to add a second database instance to your ...
switching instances	8/18/2008
Q: I have a server running Oracle on Linux, and I need two data bases (one for testing, and one for ... A: You can have two database instances running on the same server. If they are the exact same Oracle ...
Oracle 10gR2	7/29/2008
Q: PLEASEEEEEEEEEEEEEEEEEEEEE HELP ME:((( I'm a newbie in Oracle and I'm totally confused. I've ... A: To check your services, click on > START \| SETTINGS \| CONTROL PANEL \| ADMINISTRATIVE TOOLS \| ...
TAB view	7/23/2008
Q: I saw a previous answer that the TAB is a view of the USER_TABLES. But, I'm seeing system tables, ... A: TAB and TABS are diffirent from each other. you can execute >desc tab, SQL> desc tab Name ...
Regarding Oracle DBA	7/15/2008
Q: I want to learn Oracle Apps DBA. But to learn Apps some said I shud have a prior knowledge of ... A: While you may be able to learn Oracle Apps DBA without first having an Oracle DBA background, you ...
Bill of Materials	7/11/2008
Q: hope that u r very fine. I have a table in oracle 9i, named 'BOM'. It has fields main_product_code, ... A: If your table BOM only has these three columns: MAIN_PRODUCT_CODE, PART_CODE, QTY A ...
Regarding Oracle DBA	7/10/2008
Q: I want to learn Oracle Apps DBA. But to learn Apps some said I shud have a prior knowledge of ... A: Oracle 9i and 10g are still in production use. These two represent almost 90%+ of the companies ...
Oracle8i- TNS could not resolve service name	6/26/2008
Q: i am thivya working as a software developer. we got a project with VB as front end and oracle8i ... A: An ORA-12154 covers a lot of possible errors. For starters, can you connect to the database using ...
How to move database from Microsoft SQL Server 2005 to Oracle 9i?	6/25/2008
Q: I have a question regarding moving from another platform to Oracle 9i platform. Is there a tool ... A: Oracle does have a migration path for SQL Server to Oracle 10g and 11g (although it's similar for ...
oracle	6/24/2008
Q: i just passed the OCP exam, can i get the entry level job or internship in USA. A: Congratulations on passing your OCP exam. You can certainly apply for position in your local market ...
export security	6/21/2008
Q: If i have dump file from other schema i can easily create newuser and write imp newuser/password ... A: I was referring to the Oracle ROLES (DBA_ROLES, USER_ROLES) that are associated and granted to ...
export security	6/18/2008
Q: If i have dump file from other schema i can easily create newuser and write imp newuser/password ... A: Oracle assumes the individual taking the backup will be responsible for securing the dump file. ...
Oracle commands from Windows command line...	6/16/2008
Q: Peter, a couple of years ago you asked the"Is there a way to run oracle commands directly from the ... A: With Oracle 8i and higher, you can now invoke SQL*PLUS from a MS-DOS command line in Windows. The ...
Oracle exp and import	6/13/2008
Q: I have 2 questions : 1.I want to export and than import specific sequences ( only some of the ... A: Here's an answer from Ari Kaplan, one of many Oracle gurus: When exporting on the TABLE level, ...
question related to import .dmp file	6/6/2008
Q: .. I recently installed oracle9i in to my system.and I am having one .dmp file.I want to import .dmp ... A: 1. Can you connect to your database using SQL*Plus? If yes, then 2. The syntax for the command-line ...
ORA-22905	6/5/2008
Q: I'm trying to install the Oracle Warehouse Builder but when I'm configuring the Repository, appear ... A: http://www.orafaq.com/forum/t/70983/0/ It may be possible that the version of OWH that you are ...
dba questions	6/3/2008
Q: Can one load data into multiple tables at once? What tuning indicators can one use? . What should ... A: 1. Generally, Oracle DBA perfer to load tables one at a time. While it is possible to load multiple ...
Stored Outlines.	5/30/2008
Q: Does setting USE_STORED_OUTLINES = TRUE or CREATE_STORED_OUTLINES = TRUE cause outlines to be stored ... A: When an outline is enabled for your session, the optimizer looks in your category for the SQL ...
EXp error	5/22/2008
Q: sir, i have imported data from oracle 8.1.7 (configured in redhat9 /32 bit ) to oracle 10g (in ... A: The problem appears to be a difference of the database language character set. Your 8.1.7 database ...
oracle 10g	5/19/2008
Q: sir, i installed oracle 10g on Rhel5 and imported data from 8.1.7 to 10g Now i am connecting from ... A: The encrypted value of password, are you referring to the user password that has changed once you ...
Tablespace query-Oracle	5/19/2008
Q: I have total 18 tablespace in oracle in which 8 tablespace has >99% usage. It should be noted that ... A: Your tablespaces is reaching (or has reached) the maximum allocated storage. There are two options: ...
Find records created until 1 year ago	5/16/2008
Q: I am trying to write the SQL for a query that will show me all the records created from date A until ... A: In Oracle SQL*Plus, the equivalent of a getdate() would be sysdate. Thus SELECT ...
help please...	5/14/2008
Q: \| Id \| A \| B \| C \| 1 25 30 60 1 50 70 26 1 10 50 40 ... A: The code would be similar, except you have a UNION between each one. In your case where you have 3 ...
help please...	5/13/2008
Q: \| Id \| A \| B \| C \| 1 25 30 60 1 50 70 26 1 10 50 40 ... A: The SQL would look something like this: SELECT TAB.ID, TAB.COLA, TAB,COLB, TAB.COLC FROM TABLE ...
Retrieving Data	5/8/2008
Q: I have sql query that uses a max() function along with a group by clause. It retrieves n number of ... A: If you're looking for an about similar to this: Item Count ------ ----- Chair 5 ...
SQLquery - Assign prevoius value	5/6/2008
Q: I have 2 tables. Claims table- claim ID, Member_ID, service_from_date, service_end_date. Plan ... A: I'm not sure if you got a response to your question (it doesn't seem to appear here in allexperts). ...
SQLquery - Assign prevoius value	5/5/2008
Q: I have 2 tables. Claims table- claim ID, Member_ID, service_from_date, service_end_date. Plan ... A: For that second query, select a.plan_id from plan_tbl a, claims_tbl b where ...
SQLquery - Assign prevoius value	5/5/2008
Q: I have 2 tables. Claims table- claim ID, Member_ID, service_from_date, service_end_date. Plan ... A: The query for the first part of your question would look something like this select ...
Oracle 10g	5/4/2008
Q: Due to installation of oracle 10g- enterprise edition is internet connection necessary? Beacause i ... A: While an Internet connection is not required, a (local) network connection is recommended if you ...
oracle	4/30/2008
Q: can you tell me the method for backup ,recovery ,import export for database ; also can you tell me ... A: With Oracle 10gR2, there are two ways backups can be done. The first (and traditional way) is using ...
oracle	4/30/2008
Q: i have done my BCA from reputed university.i want to become master either in jawa or oracle or sap ... A: You should also take a look at the environment (i.e. job market) and what your priorities are. ...
difference between Oracle 9i AS & DS	4/18/2008
Q: I have a few queries related to oracle: 1. What is the difference between Oracle 9iAS and Oracle 9i ... A: Oracle 9i Development Suite (DS) is just a collection of development tools. Oracle 9i Application ...
query	4/17/2008
Q: how can i get date from table date wise if date and time mersed in one column A: If your date-time column is defined as a date, then you can simply apply a mask within your SELECT ...
"theta join" and "ANSI join"	4/16/2008
Q: I saw "theta join" and "ANSI join" on the web. do you know that? Thanks, lzzzz A: Theta Join is part of relational algebra ... a notation on representing tuples of data. Reference: ...
Oracle database updgrade impacting on application	4/16/2008
Q: I would like to know if we are upgrading an application running on Oracle database 10 release 1 to ... A: Enclosed are steps 1 and 2 from the actual Oracle 10gR2 upgrade. These first two steps assumes that ...
Oracle database updgrade impacting on application	4/15/2008
Q: I would like to know if we are upgrading an application running on Oracle database 10 release 1 to ... A: Not knowing the details of your application, if you are using anything that is being deprecated or ...
Error while Connecting to database	4/15/2008
Q: i m working on a software which is built using VB6.0 & backend is an oracle database. when i m ... A: Not sure the what the error code that your are seeing. You may wish to check that you have ...
oracle username unable to retrive	4/10/2008
Q: i am unable to retrive the username and password in oracle 9i which i have recently installed i ... A: What is the Oracle user you are trying to connect with (was it created or a default Oracle account ...
Oracle table size	4/9/2008
Q: How do you determine the size of a table in oracle. A: select segment_name table_name, sum(bytes)/(1024*1024) table_size_meg from ...
Import Dump	4/8/2008
Q: I have to import some set of tables from a oracle dump file. I dont know the specific numbers of ... A: In the TABLES parameter, use the % character as a wildcard. This is typically for one character ...
undotable space management.	4/8/2008
Q: how can i see which all transactions are consuming in undo tablespaces? A: What you're looking for is the monitoring of the UNDO tablespaces. The following dynamic ...
Oracle	4/7/2008
Q: I've been using Access for some time and I'm looking to expand my database background. I see a lot ... A: Believe it or not, ALL of the Oracle documentation is available online and for download for free. ...
Import Dump	4/7/2008
Q: I have to import some set of tables from a oracle dump file. I dont know the specific numbers of ... A: If you have the actual names of the tables, then you can import using a parm (also known as a ...
Oracle .dmp vs Scripts	4/1/2008
Q: We have an Oracle (11) .dmp file from an application vendor. Our IS team does not want to use it ... A: An Oracle .DMP file is produced using the Oracle utility EXPORT. It produces a binary file that can ...
Doubt on the Table	4/1/2008
Q: Is there anything to be called as "pseudo Tables" if so whats the purpose of the tables? A: There is no official table called PSEUDO TABLES within an Oracle database. You can create a table ...
BCNF Normalization	3/20/2008
Q: I have a question regarding BCNF normalization. What I understood so far is that with BCNF ... A: In theory, you can normalize it further as such: EMPLOYEE (EMP-ID, <NAME>) PROMOTION HISTORY ...
oracle database	3/13/2008
Q: how to export oracle tables or data base from one computer to another? A: You can use the EXPORT command. This executable, "exp" is usually located on your $ORACLE_HOME/bin ...
changing IP of oracle 7.34 cluster	3/12/2008
Q: I have to move a 2-nodes Oracle 7.34 cluster into different network. I shall change old IP of the ... A: When you're moving the Oracle cluster to a different network, you will need to change the IP address ...
Oracle Database	3/7/2008
Q: All off my development databases are in unix. From a particualr date all the databases are ... A: Performance changes are usually as a result of a change to the environment. Changes such as new bulk ...
oracle 9i	3/4/2008
Q: i have two database on my single machine. i want to connect them for query from one to another with ... A: http://www.idevelopment.info/data/Programming/java/jdbc/ConnectionExample.java contains a sample set ...
Snapshot	3/3/2008
Q: Sir my database is in 9i and i have to create a snapshot from 8.0.5 database its not creating my ... A: The error that you are reporting is an Oracle internal error message. You should also take a look at ...
pl/sql	3/3/2008
Q: 1)What is use of Ignore=y in import? 2) How to db convert sql server to oracle? Please reply ... A: Hey Meyyappan, 1) If you specify IGNORE=y, Import overlooks object creation errors when it attempts ...
oracle 9i	2/28/2008
Q: i have two database on my single machine. i want to connect them for query from one to another with ... A: If you can invoke your stored procedure manually, then batchiong it should be simple. Suppose that ...
select statement	2/27/2008
Q: this is parth, i have problem in select query.i want to fetch a paticaular column from a table. my ... A: What you are looking for is the DECODE syntax. The syntax is decode( expression , search , result ...
Oracle 8.1.7	2/27/2008
Q: Sir, Sir whether i can install oracle 8.1.7 on Redhat Enterprise linux 5? Will u plse send me a ... A: You can use this link for generic Linux : http://download.oracle.com/docs/pdf/A86017_02.pdf The ...
oracle 9i	2/22/2008
Q: i have two database on my single machine. i want to connect them for query from one to another with ... A: Your create database link syntax should read something like .. Login to your database O92. CREATE ...
sql	2/22/2008
Q: What is inline view and use of that give with example? Plz reply A: Don Burleson has a great text that describes and gives an example of an Oracle Inline View: Using ...
oracle 9i	2/21/2008
Q: i am new to oracle9i and have been assigned in a new project that is completely in oracle9i.the ... A: 1. Here's a quick tutorial on how to create, write, manage and administer Oracle Stored Procedures ...
oracle 9i	2/20/2008
Q: in regarding with the previous question ,actually i have no right on the server side, can we create ... A: 1. Here's a quick tutorial on how to create, write, manage and administer Oracle Stored Procedures ...
Oracle 10g -> 9i backout	2/20/2008
Q: Can you let me know how to back out if something goes wrong with Oracle 9i-10g upgrade using DBUA A: Assuming that the you were successfully able to upgrade your database from Orale 9i to 10g using the ...
Decode (sql33+)	2/20/2008
Q: I understand the methodology behind the decode feature & can get it to return single entries no ... A: You can use nested DECODE statements to achieve a similar result: Examples courtesy of ...
doudt about export command	2/20/2008
Q: ..I am having a dump file(.dmp file) and I want to export that file in to my database(oracle ... A: You need to use the import command. On Unix it is imp. On Windows it is IMP.EXE. Here's a quick ...
oracle 9i	2/18/2008
Q: in regarding with the previous question ,actually i have no right on the server side, can we create ... A: You will need to contact your server admin or DBA to discuss implementing Data Guard. Data Guard ...
Oracle global variable	2/18/2008
Q: I having an oracle 3 tier design, i have a hp-ux based oracle database, and windows 2003 base oracle ... A: Are you having this problem only in your production environment? Does the same error occur any of ...
pl/sql	2/18/2008
Q: I am having a Table that contains 30 Lacks of records. Now i select or update in that Table that ... A: You may want to consider running an explain plan to see where exactly is your problem. ...
export data from Oracle 7.2.3 SCO unix OS	2/17/2008
Q: We have Oracle 7.2.3 ver running on SCO unix OS. We wish to export all the tables from oracle to MS ... A: You can download the appropriate Oracle ODBC drivers for use with your MS SQL Server 2000 from this ...
importing a.dmp file into empty oracle 9i	2/15/2008
Q: sir. i want importing a file into our oracle 9i .i got succeeded in that but i am unable to see the ... A: You are now looking at near-real time data replication (data entered on a Master database. The data ...
DBMS & RDBMS	2/14/2008
Q: Difference between DBMS & RDBMS with examples A: Today, DBMS and RDBMS are pretty much used interchangeably. However, there is a distinction between ...
issues after upgrade from 9i to 10.2.0.2	2/11/2008
Q: what are the possible problems we will have to face if database is upgraded from 9i to 10g version ... A: Essentially if you are not using Oracle 9i functions or features that have been deprecated in Oracle ...
importing	2/11/2008
Q: Sir, while importing dump in oracle 8 which has taken from 9i error is comming whether i can import ... A: Although you can easily and successfully export data from and earlier Oracle version to a later ...
importing a.dmp file into empty oracle 9i	2/8/2008
Q: sir. i want importing a file into our oracle 9i .i got succeeded in that but i am unable to see the ... A: You cannot OPEN the .DMP file. The simplest solution to accessing the tables within is to create a ...
importing a.dmp file into empty oracle 9i	2/7/2008
Q: sir. i want importing a file into our oracle 9i .i got succeeded in that but i am unable to see the ... A: The .DMP file is an Oracle binary file. It is created as a result of an EXPORT (or Oracle backup). ...
Incomplete Recovery.	2/1/2008
Q: Can the database be open during an incomplete recovery? Can you please explain this? A: Oracle's formal definition is as follows: "To begin media recovery operations when your database is ...
SQL query inside Shell script	1/30/2008
Q: I have a shell script to execute a sql query. I need to do some control logic on the select result ... A: Here are some sites with examples: http://www.computing.net/unix/wwwboard/forum/6500.html ...
Installation	1/29/2008
Q: Sir, can u pls send me good document for installing oracle 9.2.0.1 in rehat linux 9 ? while i ... A: Linux (Intel 32 Bit) http://download.oracle.com/docs/html/A97349_01/toc.htm Unix (General, ...
Clients are disconnected intermittently	1/25/2008
Q: Peter, We see clients receive: "Your log on session has become invalid." while working in Oracle. ... A: One thing comes to mind would be that the users have exceeded their idle time and thus is ...
about oracle9i	1/24/2008
Q: how to store binary values in a data base?Is there any specific data type,to store it? If it is a ... A: http://www.psoug.org/reference/dbms_lob.html ...
mirroring database	1/12/2008
Q: An Oracle Database 8i SE is running on Sun Solaris Machine in one location. Now we want to make ... A: Good day Muhammad, With Oracle 8i, you have two choices, using Oracle Parallel Server (it's called ...
Import from 9i to 10g	1/9/2008
Q: Respected Sir, when i am tried to import database ,the following types of error occurs, 'Export ... A: What is the error message that you get? The text you quoted is just the header from the IMPORT log ...
how 9i OMS deal with 8i/10g agent	12/18/2007
Q: Hope you are well. I was wondering if Oracle 9i OMS can detect 10g agent in a networked ... A: You'll need to read up on Oracle 10g's Grid Control and Oracle Enterprise Manager. ...
Oracle 10g db down often	12/17/2007
Q: I've installed Oracle 10g on Windows Server 2003 machine. We have MS Server 2005 and MySQL on this ... A: Fri Dec 14 14:10:09 2007 Memory Notification: Library Cache Object loaded into SGA Heap size 2201K ...
how 9i OMS deal with 8i/10g agent	12/17/2007
Q: Hope you are well. I was wondering if Oracle 9i OMS can detect 10g agent in a networked ... A: http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/oms-9i-o10g-agent-o10g-agent-lis ...
conn / as sysdba	12/7/2007
Q: I have a doubts.. In windows ,I have two databases created test1 &test2.. oracle_sid variable is not ... A: ON the safe side, I always set my ORACLE_SID parameter as well as specify the database which I would ...
IP address change on unix server	12/5/2007
Q: We have oracle 8i installtion in a Alpha 800 server on Unix version 4.0D. The oracle applications ... A: 1. In your database server, anywhere where you've hardcoded an IP address will be affected. Thus ...
ORA 01033 Error	12/4/2007
Q: ORA 01033 Error Help HI there, We are using Oracle 9 as our Back end Database Manager, and VB as ... A: I do no understand what you mean by "The Database is Password Protected by the Vendor and can not be ...
ORA 01033 Error	12/4/2007
Q: ORA 01033 Error Help HI there, We are using Oracle 9 as our Back end Database Manager, and VB as ... A: The problem that you are encountering is with the database. When your PC/database server crashed, ...
Upgradation from Oracle 8.1.5 version to Oracle 8.1.6 version	11/17/2007
Q: I have following queries : 1) Whether i can install Oracle 8.1.6 Personal edition on P-IV 3.00 GHZ, ... A: 1. 8.1.6 is best on NT/2000. 2. Yes should be able to. 3. You may wish to consider upgrading to ...
Oracle	11/14/2007
Q: I'd like to learn more information about replication in oracle DB ? A: http://www.akadia.com/services/ora_replication_guide.html ...
Importing in ORacle	11/7/2007
Q: Sir, I am using Oracle 8I on Windows 2000. I have exported a user named savior40 & has created a ... A: When you run the IMPORT command in interactive mode ((by answering the prompted questions), you can ...
ORACLE DB Backup	11/5/2007
Q: Am very new to oracle. I want to back up the oracle database with data using TOAD. how can i get ... A: http://searchoracle.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid41_gci1219816_tax299411,00 ...
Alter Or Drop Global Temp Table	10/30/2007
Q: I created one global temp table with on commit delete rows options. But i want to alter the table to ... A: Using Oracle 10gR2: SQL> create global temporary table gtt_table 2 (col1 integer, col2 ...
Oracle	10/30/2007
Q: I am developing a computer based testing application, which will be used by around 200 people at a ... A: It depends on what type of infrastructure (hardware, network, software license, etc.) that you have ...
Oracle Installation	10/17/2007
Q: I want to know what configuration required for oracle 9i (9.0.1) installation means which operating ... A: Oracle 9i (9.0.1) is no longer supported by Oracle. The latest and terminal version of the Oracle 9i ...
question related pl/sql	10/17/2007
Q: which three are true statements about dependent objects? 1. Invalid objects cannot be described. 2. ... A: 2, 4, and 6 are my choices. The USER_OBJECTS data dictionary view contains the list of user owned ...
Oracle 9i to 10g	10/16/2007
Q: I have got to upgrade from oracle 9i to 10g. Basically I want to know what all methods I can use, ... A: Enclosed is the link to Oracle's Upgrade Guide ...
Capacity Planning	10/15/2007
Q: How to do the capacity planning of a database? means what are the steps involved in capacity ... A: Here's a great article that walks you through the steps involved with capacity planning for a ...
Database updation	10/13/2007
Q: My question seems like vague , but I would like to know about that for my work.. In case when ... A: What you are talking about is an automated batch process. For this discussion, I assume that your ...
Migrating Oracle DB for peoplesoft	10/12/2007
Q: I saw your post on moving Oracle DB from 9i to 10g. You recommended full export from 9i and import ... A: When using the EXPORT - IMPORT method, you're not moving the physical DBFs that make up the ...
peoplesoft installation with oracle	10/12/2007
Q: can you give me the procedure to install peoplesoft HRMS 8.8 with Oracle 9i on windows vista. I am ... A: You can find the reference documentation here: PeopleTools 8.49 ...
Explain plan	10/11/2007
Q: How the explain plan of sql statement automatically changed? what is the format of explain plan ... A: An explain plan will show how Oracle will process a given set of SQL statement. Based on the outcome ...
No Listener	10/10/2007
Q: Reason for this message is because everytime I log into the SQL Plus error states theres no ... A: Have you started up the LISTENER services? There are two quick checks: 1. At a DOS/CMD line prompt, ...
getting a good advisment	10/10/2007
Q: i am a student of IT and i want to do a course in data base but i am a little bit confused about ... A: Take a look at the job market in your area (i.e. via internet job postings, newspaper advertisements ...
Statspack Report	10/9/2007
Q: how statspack report looks means what is the format of statspack report? A: Oracle's STATSPACK is a set of utilities to help monitor and tune the performance of your database. ...
Development database	10/8/2007
Q: I want to know what is a development database and what is the importance of development database? i ... A: Your development database is where you allow your developers to develop their applications and SQL ...
getting a good advisment	10/7/2007
Q: i am a student of IT and i want to do a course in data base but i am a little bit confused about ... A: Each of the different database vendor follows ANSI standards, thus their SQL looks similar. That's ...
i m very confuse	10/6/2007
Q: sir i have passed my Btech frm CS in 2007 batch and i want to make my carrer in oracle DBA bcoz i m ... A: Developer 2000 (D2K) is being slowly phased out. If you plan on pursuing a career in the development ...
Question regarding system tablespace	10/4/2007
Q: I want to know can we drop the system tablespace in oracle 9i ? and if not, why we can't drop the ... A: Technically, you can drop the system and rollback tablespace. Here's why you DO NOT want to do ...
diff between Orderby and Group by	10/4/2007
Q: difference between Order by and Group by? suppose i have students table which has id number ,sname ... A: The ORDER BY performs a sort operation. So think of a telephone phone directory. The SELECT NAME ...
Firing DML Triggers during Parent-Child Inserts	10/3/2007
Q: I have a question regarding firing of DML-Triggers during inserts, especially parent-child inserts. ... A: Given that you don't know how many child records will be inserted with each parent, you might need ...
How do we define for PASSWORD	10/2/2007
Q: I would like to know how do we define for Password in Oracle SQL. For example we define a) login by ... A: If you are planning on storing your password in a table in clear text, that is unencrypted, then ...
ORA-01033	10/2/2007
Q: I have restored and recovered a database (9.2.0.4 standard edition on AIX) from a hot backup. The ... A: Tom, When you shutdown your database, did you use just SHUTDOWN or SHUTDOWN IMMEDIATE? The latter ...
ORA-01033	10/2/2007
Q: I have restored and recovered a database (9.2.0.4 standard edition on AIX) from a hot backup. The ... A: Log in as SYSDBA. 1. Shutdown your database using the "SHUTDOWN" command. 2. STARTUP MOUNT your ...
.DMP file	9/29/2007
Q: How to import or export database from/to DMP file ? A: Good morning Mohammed, In Oracle 10g, the EXPORT and IMPORT tools are giving way to a new tool ...
Did you ever get an answer to this queston?	9/28/2007
Q: I noticed someone attempted to answer your question, but in talked about every other than what you ... A: set heading off select case when count(*) = 0 then 'Database started using PFILE(init.ora)' else ...
UPDATE w/ sub-queries	9/12/2007
Q: I have two tables DOCUMENT and DOC_TYPE. The description (DOC_TYPE.DT_DESC) value in currently ... A: Your sub-select returns more than one row (as you've indicated in your question). You will need to ...
Random record	9/11/2007
Q: I have a oracle table with 500 records.. I need to select one random record from the table ... A: A possible query could look like this (this selects 10 values from a given table): SELECT * FROM ...
PeopleSoft vs Oracle	9/11/2007
Q: I am currently using PeopleSoft 8.8 at my job. I am going on an interview today with a company that ... A: PeopleSoft is an Oracle Product. Oracle has retained the brand name, but is slowly moving into its ...
Oracle8i, Visual Basic6	9/10/2007
Q: Sir, I developed one project using Visual Basic 6 as front end and Oracle8i as back end... how to ... A: That depends on what your intent is for. If you want it only to be able to perform a disaster ...
PFILE	9/10/2007
Q: i have lot of init.ora files in my default location.How can i find which pfile my database is ... A: select name,value from v$parameter where name = 'spfile' / That should help you decide which ...
multi-table validation (pl/sql)	8/29/2007
Q: Peter, I have three large tables that relationed together by a primary key. Over time some not ... A: You need to identify which of the three tables would serve as your master record. Essentially if you ...
car rental database	8/29/2007
Q: in a car rental database, what are the important schemas in it? i need the answer ASAP.. thanks A: That depends on your requirements. If I assume that I own a car rental facility, then my ...
Oracle ODBC connection to MS Access	8/23/2007
Q: how can I pass Oracle credentials thru an MS Access ODBC connection? This might be more of an Access ... A: If you have admin privileges, you can configure your ODBC to add a new ODBC source called Oracle. ...
Upgrading to Oracle 10g Release 2	8/9/2007
Q: We currently operate an Oracle database (Server version 9.2.0.6) on Windows NT. The client software ... A: It is usually recommended that the client version can be a higher release than the database it is ...
About OCP-DBA certification	8/7/2007
Q: I want to give my OCP-DBA certification. Can you help me by telling which is the best book to pass ... A: I just did a query on the online book retailer AMAZON.COM and here's a list of books available: ...
Suitable Oracle Certification	8/5/2007
Q: I am a .NET Developer and run my own mISV firm. I deliver solutions as demanded. I use both SQL ... A: The certification depends on the work that you hope to perform. As indicated, the OCP (DBA Track) ...
Oracle service suddenly stopped.	8/3/2007
Q: My Oracle 9i Database suddenly stopped working. Just an hour ago, I successfully worked on it and ... A: 1. Can you login to the database as SYSDBA or with the /NOLOG. If you can, can you issue the ...
Performance issue	8/2/2007
Q: I am hoping you have run across a problem similar to what I am experiencing now. We have a large ... A: I've had to give this a bit of thought (It's a strange one). I don't believe that statistics alone ...
Oracle service suddenly stopped.	8/2/2007
Q: My Oracle 9i Database suddenly stopped working. Just an hour ago, I successfully worked on it and ... A: The error message tells me that someone has instructed the database to shutdown or to startup. It ...
Installation Problem	7/31/2007
Q: Peter, Hope this message finds you in the best of health. I am a student and very new to ... A: Try to run the install again. Oracle might be able to detect that you're installed and might bring ...
Network	7/31/2007
Q: we have searched in internet the ways to optimise the network utilisation by oracle. We have ... A: Here are some checks that should be performed against the database. 1. What is the current various ...
Service starting problem	7/30/2007
Q: this is steve, i got a problem with oracle services, i am not able to start OracleDBConsoleOrcl its ... A: Steve, What's the content in that log file mentioned by the error message. Note that this only ...
Service starting problem	7/30/2007
Q: this is steve, i got a problem with oracle services, i am not able to start OracleDBConsoleOrcl its ... A: Have you made any changes to the HOST file or TNSNAMES.ORA or SQLNET.ORA files of late? I do know ...
Service starting problem	7/30/2007
Q: this is steve, i got a problem with oracle services, i am not able to start OracleDBConsoleOrcl its ... A: Steve, 1. Has this process worked before (if so when was the last time). If it did, was there any ...
Service starting problem	7/30/2007
Q: this is steve, i got a problem with oracle services, i am not able to start OracleDBConsoleOrcl its ... A: Can you take a look at the Windows Events Viewer Console (START \| SETTING \| CONTROL PANEL \| ...
inner/outer join	7/27/2007
Q: Given, Customer table has two column: id and name Product table has two column: id and number C_P_AS ... A: Sorry was sick the last few days. To answer your first question, it can be restated as follows: 1. ...
inner/outer join	7/27/2007
Q: Given, Customer table has two column: id and name Product table has two column: id and number C_P_AS ... A: For a given name, I am matching it to a CUST_ID in the CUSTOMER table. From there, I match that ...
inner/outer join	7/26/2007
Q: Given, Customer table has two column: id and name Product table has two column: id and number C_P_AS ... A: You can try something like this (using Inner Joins) SELECT A.PRODUCT_ID, A.NUMBER FROM PRODUCT A, ...
Import /Export Problem	7/26/2007
Q: I have a export dump file & i have to import it into another schema but the problem is that i don't ... A: Assuming that you can already log in to the target database, and assuming that you have the granted ...
Import /Export Problem	7/26/2007
Q: I have a export dump file & i have to import it into another schema but the problem is that i don't ... A: You can create a new schema (Oracle account) with a different password, and then import the DMP to ...
Import /Export Problem	7/26/2007
Q: I have a export dump file & i have to import it into another schema but the problem is that i don't ... A: You can use the TOUSER flag to have the exported information imported into your schema. So the ...
Help-Urgent please	7/25/2007
Q: i am kalyan, doing a project for my course, i am struck with the connectivity problem, i m using ... A: Have you ever had Oracle 9i installed before Oracle 10g? Do you have Oracle 9i installed as well as ...
oracle 9i	7/25/2007
Q: what is the partition of table and insertion, selection, updation in the partition table? A: Partitioning in Oracle allows you to spread your data across different physical tables. The nice ...
TOAD Data Importer Error	7/23/2007
Q: I'm using TOAD's DATA Importer utility to import data into my Oracle database table. The data is in ... A: Oracle uses ROWID to uniquely identify each and every row in the database. It's not a visible ...
Oracle and web	7/22/2007
Q: I have an oracle application (I don't have source code or access to DB) and web application(I have ... A: .FMX files are created using Oracle Forms (using Oracle Forms 4 to 6i or Developer 2000, or a later ...
Backup	7/20/2007
Q: Sir, How r u? Hoping that u r doing well Sir, i have all my dbf files with me wht r the steps i ... A: What you are doing amounts to what Oracle would call a "COLD BACKUP". Essentially, it's taking all ...
Application hangs when user navigates across multiple forms	7/19/2007
Q: Our system runs on Forms 9i front end and Oracle 9i backend. For testing, we were navigating from ... A: This almost sounds like there's a java issue than a locking issue. When you're just navigating a ...
How to Import .dmp file into Oracle8i	7/19/2007
Q: I dont know anything about Oracle. Here is my situation. We are SQL Server shop not Oracle. However ... A: You'll still run into the problem with the existing data that are in the tables. You can remove the ...
How to Import .dmp file into Oracle8i	7/19/2007
Q: I dont know anything about Oracle. Here is my situation. We are SQL Server shop not Oracle. However ... A: Jay, As a follow up to your previous question, if you wanted to delete the data from specific ...
How to Import .dmp file into Oracle8i	7/19/2007
Q: I dont know anything about Oracle. Here is my situation. We are SQL Server shop not Oracle. However ... A: The error message indicate that the IMPORT cannot import due to existing data that matches what you ...
How to Import .dmp file into Oracle8i	7/19/2007
Q: I dont know anything about Oracle. Here is my situation. We are SQL Server shop not Oracle. However ... A: It sounds like you may not have the proper privilege to import the file. You should take a look at ...
How to Import .dmp file into Oracle8i	7/19/2007
Q: I dont know anything about Oracle. Here is my situation. We are SQL Server shop not Oracle. However ... A: RMAN isn't really available until Oracle 9i or higher. As you're on Oracle 8i, you don't have that ...
Logging trigger	7/19/2007
Q: Is it possible to switch on the oracle logging for only a particular user or a number of user? ... A: I am assuming that you wish to audit actions transpire within SQL*PLUS for a given user (e.g. DBA). ...
Oracle	7/19/2007
Q: Difference between Oracle 8i and 9i in Simple words A: Some easy to follow reference on this topic: http://www.geekinterview.com/question_details/22717 ...
How to Import .dmp file into Oracle8i	7/18/2007
Q: I dont know anything about Oracle. Here is my situation. We are SQL Server shop not Oracle. However ... A: If you need to refresh the ENTIRE database, you will need to have the DBA/SYSTEM privilege. This ...
Account Expiry.	7/17/2007
Q: In Oracle, is it possible to create a user account with an expiry date? i.e. creating an account ... A: It's not exactly an expiry date, but you can expire a password after xx days through the use of ...
ora 1555 snapshot too old	7/13/2007
Q: sir, When i am running a proc (C + oracle) One oracle error is comming ie snap shot is too old bt ... A: The references contain some helpful information and detail of issues with the resolution (included ...
Admin Database	7/10/2007
Q: i work as a software test engineer.I have one requirement to test in which a portal's database has ... A: You can test it by being an end-user. The DB upgrade and subsequent data migration to the new DB ...
usernames & passwords	7/10/2007
Q: sir,I m facing a problem in opening the sql plus.i supplied "scott" as username and "tiger" as ... A: Unless you are using an Oracle database with the default install and SCOTT user enabled (along with ...
how i can import database from dmp file	6/27/2007
Q: .n give tips wht i sud do in a step by step manner. A: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1023560 will ...
Link Table 00604 Error	6/25/2007
Q: Peter, I just joined a team where an Access 2003 database is used to truncate and insert records ... A: According to Oracle: ORA-00604 error occurred at recursive SQL level string Cause: An error ...
Paritioning	6/23/2007
Q: hey What is the difference between Horizontal Partitioning and Vertical Partitioning? Thanks A: Wikipedia has a great definition of the Horizontal and Vertical Partitioning: ...
Backup	6/23/2007
Q: Peter,Could you please tell me about compress attribute in exp-imp utility?how it makes import fast ... A: In general, when you enable compression, there is a performance impact on system resources (in this ...
importing xcel data to oracle table	6/22/2007
Q: i want import the excel sheet data to a single table , i converted to excel file to csv and created ... A: Possible cause 1: You are loading the data (CSV file) on a unix server. If this is the case, then ...
UNIX shell script function	6/20/2007
Q: i am having UNIX shell script function which uses SQL Query to return the day of the particular ... A: This site has an excellent example of something similar to what you're looking for. ...
Difference b/w oracle 9i and 10g?	6/19/2007
Q: What is the exact difference between oracle 9i and oracle 10g and What is the difference b/w normal ... A: http://www.orafaq.com/faq/features_introduced_in_the_various_server_releases The above link shows ...
oracle	6/18/2007
Q: Sir, I am a dairy professional, I need to design processes and equipments as well. How would oracle ... A: Oracle's strength lies in its database software. The database can be used to capture information ...
SQL Trace	6/15/2007
Q: Using Toad, how can i check the sql from the application to the Oracle database (9i). Doing a trace ... A: Oracle doesn't have a tool that's network based as SQL Server's SQL Profiler. Oracle (and Toad) uses ...
Database disconnects	6/14/2007
Q: I have an Oracle 10g database running with a client that uses the Oracle client to connect. We were ... A: Based on your list of errors, there are two possible causes: 1. Network problems. You may have an ...
Import in order to tables	6/13/2007
Q: i had used the same commond what happend here is, it is imported same sequence using at the time of ... A: You can create a PAR file ...
Import in order to tables	6/13/2007
Q: This is regarding import tables, Actually i am importing 50 table and i want to import in order or ... A: Using Oracle IMPORT, you can get some generic HELP information by typing IMPORT.EXE -HELP (for ...
Report 10g	6/10/2007
Q: Iam facing problem in oracle 10g reports, when one client run a report, others client should wait ... A: Does the report perform INSERT/UPDATE/DELETE SQL commands? If it does, then as a matter of data ...
Oracle querry	6/8/2007
Q: Sir i want the differences among Oracle 9i,10g and 11i plz let me know. My contact no is : ... A: No formal information about Oracle RDBMS 11i / 11g has been released. Oracle 9i New Features ...
Import of dmp(Oracle 9i dump) file	6/7/2007
Q: I have exported the oracle 9i dump onto my windows environment. I need to synchronize my databases. ... A: There isn't any way to have your database server recognize the server where your dump file is ...
Oracle 7.3.4 installation on Sco Unix	5/28/2007
Q: I tried to install oracle7.3.4 to SCO UNIX, but some errors occured while installing. 1.while ... A: FOr your first question, You may wish to check certification of Oracle 7.3.4 on Sco Unix 6.x. ...
Difference between oracle 9i and 10g database object.	5/24/2007
Q: please explain the diffence between oracle 9i and 10g database objects. Also define queue ANSWER: ... A: As indicated in the release notes for Oracle 10g (enclosed in original email), there are no net new ...
Difference between oracle 9i and 10g database object.	5/23/2007
Q: please explain the diffence between oracle 9i and 10g database objects. Also define queue A: Oracle 10g New Features Guide ...
Dedicated Server.	5/23/2007
Q: How do you request a dedicated server connection in a shared server configuration? A: http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm ...
installation	5/19/2007
Q: Sir , i was trying to install oracle 7i on sco unix 6,0.0 First was oracle7.3 but i couldnot ... A: I'm not sure what that error is. However, I would recommend that you upgrade to at least Oracle 10g ...
oracle perfomance DBA Fresher	5/16/2007
Q: i am using oracle 9i in windows 2003 server. Last four month back database crashed. i have created ... A: 1. Are you updating your statistics? Are you using the Cost based optimizer (CBO - Default) or ...
Oracle	5/15/2007
Q: Sir When i tried to start my oracle databae the following error resultedORA-01100: database already ... A: You've got an interesting problem. Symptoms Following errors are reported in the alert log file: ...
a query on sql	5/7/2007
Q: we can create views like TAB & DUAL.if it is possible tell me the procedure for creating these ... A: The Oracle delivered views, really alias to other views, can be created using the CREATE VIEW ...
STRDB80 error in Oracle 8i	5/4/2007
Q: After installing oracle 8i a error is generated saying abt STRDB80 .........how can i remove the ... A: There is one solution, for which I will provide the link to you. In the first one, you will need to ...
Installing Oracle Client in XP	4/10/2007
Q: What are the steps to install oracle client in my pc? Do I need to change any setting or file after ... A: http://download-east.oracle.com/docs/cd/B19306_01/install.102/b14314/toc.htm provides the official ...
Importing DMP file	4/7/2007
Q: i need help for importing DMP and log file to my Database. 1, what is the command for Importing DMP ... A: You may want to copy the files from your CD to your local disk. This allows you have have easier ...
*SQLplus question**	4/6/2007
Q: I have a littel question. I'm new to oracle, but few weeks back I got some sql training. I installed ... A: SQLPlus is the command line version of the interactive SQL interface. iSQLPlus is the java version ...
Oracle 10g version for PC Home	4/6/2007
Q: I have installed oracle 10g on my stand-alone PC at home (windows XP service pack 2), I choose ... A: After (assuming default) installation, you should have received a dialog box that provided all the ...
Read Consistency.	3/29/2007
Q: What's read consistency? Is it when you don't see uncommitted transactions or you see the database ... A: Enclosed is a great link that explains READ CONSISTENCY. ...
Point connection to differrent schema	3/28/2007
Q: 1). How do I point my connection to different schema from SQL*Plus? Is there a command to do this? ... A: In Oracle, you typically have one (SQL Server's definition of a Schema) database per instance. In ...
Point connection to differrent schema	3/27/2007
Q: 1). How do I point my connection to different schema from SQLPlus? Is there a command to do this? ... A: 1. To reference objects owned or belonging to another schema is SQLPlus, just prefix the ...
oracle	3/27/2007
Q: I am a fresher joined in a small company as a trainee software engineer and am into the Forms ... A: Enclosed are some resources that you will find useful in your day-to-day work: Development / Forms ...
user creation	3/26/2007
Q: I have installed oracle 10g and trying login from sqlplus command prompt with scott tiger it's ... A: During the installation steps, you may have been asked to setup and unlock specific user accounts. ...
Oracle 10g & SAN	3/21/2007
Q: I need some advice on best layout for PROD DB (Solaris 10/Oracle 10.2.0.2) as it pertains to SAN ... A: There's no hard and fast rule in terms of how to size your production database. Oracle does provide ...
Read Consistency.	3/21/2007
Q: When there are two transactions and one commits, does the other transaction see the changed data or ... A: The UNDO_RETENTION replaces the Rollback Segments feature that existed until version 8i. The ideal ...
Oracle 10g & SAN	3/21/2007
Q: I need some advice on best layout for PROD DB (Solaris 10/Oracle 10.2.0.2) as it pertains to SAN ... A: The size requirements is dependent on the volume of data and the poetential growth that you are ...
Read Consistency.	3/20/2007
Q: When there are two transactions and one commits, does the other transaction see the changed data or ... A: Within a given session (e.g. via SQL*Plus), if you commit the first transaction, but not the second, ...
Help for Oracle 9i SQL	3/13/2007
Q: I have Debit and credit transactions for each of month days. The fields are :- account,DrCr_Code(D ... A: The code would look something like this: break on value_dt skip 2 compute sum of DEBIT CREDIT on ...
Help for Oracle 9i SQL	3/10/2007
Q: I have Debit and credit transactions for each of month days. The fields are :- account,DrCr_Code(D ... A: You can use the syntax (applicable to Oracle's SQL*Plus only) preceding your query: COMPUTE SUM OF ...
what are the "tab" and "dual"?	3/6/2007
Q: I always use "select * from tab" and "select SYSDATE from dual", what are the "tab" and "dual"? are ... A: TAB and DUAL or Oracle specific views. TAB is short for USER_TABLES. The DUAL table is a ...
Is there such thing as	3/6/2007
Q: what are these two types of triggers different from the database trigger? Thanks, lzzzzHi, Is ... A: An "application trigger" is a functional type trigger. An event within the application would cause a ...
Is there such thing as "application trigger" or "system event trigger" ?	3/6/2007
Q: Is there such thing as "application trigger" or "system event trigger" ? Thanks, lzzzz A: There are a few system event triggers that are defined (out of the box) from Oracle: ...
How to display a package specification ?	3/5/2007
Q: We can display a package body from user_source. How to display a package specification ? Thanks, ... A: The Body and Spec of a package can be viewed by querying DBA_SOURCE (or USER_SOURCE). The ...
All schema objects have a status that is recorded in the datat dictionary.	2/20/2007
Q: I found this sentence as follows, is it right? All schema objects have a status that is recorded in ... A: The publicly viewable data dictionary portions of schema objects are available via the DBA_ views ...
What is the DBMS_DESCRIBE package used for?	2/20/2007
Q: What is the DBMS_DESCRIBE package used for? Thanks, lzzzz A: You can use the DBMS_DESCRIBE package to get information about a PL/SQL object. When you specify an ...
Import dmp file	2/16/2007
Q: when I added in my statement ignore=n then a different error received, as given below: Connected ... A: This is not too bad of an issue. Essentially a synonym exist so that other users can reference your ...
Import dmp file	2/15/2007
Q: I am new to Oracle database. I tried frollowing command to import data from an existing backup dmp ... A: The problem is you're trying to import data that already exist. ORA-00001: Unique constraint (...) ...
Database up vs Instance running	2/6/2007
Q: What I understand from your reply is that, If we are using one database for one instance and our ... A: That is correct. Some more info about the ORATAB file: ...
Database up vs Instance running	2/5/2007
Q: I would like to know :- 1) What is difference between database up and instance running. 2) We can ... A: A database instance is the shell or the process that you would see in a Unix's PS and grep PMON. ...
Oracle jobs and learning sequence	2/2/2007
Q: Peter, Is it true that Oracle DBAs have high demand in the market and earn more salary then other ... A: Mastering the ability to manage and maintain an Oracle database as a DBA requires a lot of knowledge ...
Prevent	2/2/2007
Q: Peter, How do very large databases like Banking Transactions handle this? Can this situation happen ... A: Large organizations build in to the infrastructure the ability to handle large volumes. This ...
Oracle 10g - loosing connection	2/2/2007
Q: I do know that we are running hot backups at night. We see the disconnects happening at all ... A: I would check the Process Scheduler logs. These logs are produced on the server where the Process ...
Oracle 10g - loosing connection	2/2/2007
Q: We've recently moved from Oracle 9i to Oracle 10g. We're running PeopleSoft HRMS / tools 8.46. ... A: If the disconnection only occurs during the off hours (i.e. when you have your batch process ...
Prevent "primary-key violation"	2/1/2007
Q: I have a test VB.NET 2003 app. It has a form with one button only. On click of a button, a function ... A: You might want to introduce a randomizer that allows one user at a time to access the database, even ...
Automated guaranteed backups ... 10g	1/29/2007
Q: Peter, What about RMAN? Oracle is giving more stress on it. If it is a more improved form then why ... A: RMAN, like the EXPort, is a tool that you can use. You will still need to write some scripts (batch ...
Automated guaranteed backups ... 10g	1/27/2007
Q: I installed Oracle 10g Express edition. In the Windows XP start menu I cannot see any Backup menu ... A: There is no delivered tool to perform an automated backup with the Express edition (or the Standard ...
Migration	1/16/2007
Q: I want to migrate oracle database /vms operating system to mysql / windows 2003 server. Its asking ... A: The Oracle System Identifier (SID) is the name of the given database instance. If you look at your ...
Connection	12/21/2006
Q: Can you tell me how to connect oracle database through mysql using odbc. Regards A: The easiest way is to configure an ODBC connection for Oracle is through this tutorial (It's for ...
Oracle migration tool	12/20/2006
Q: But my app. is a standalone desktop app.I want to migrate my existing MS Access database to Oracle. ... A: You can chose either option, which ever best suits your requirement. With Option 2, the MS-Access ...
Oracle migration tool	12/19/2006
Q: I want to migrate my existing MS Access database to Oracle. There are various tools available for ... A: There are two possibilities. Option 1 - Extract MS-Access data to a CSV file, then load it into ...
Migration	12/19/2006
Q: Can you tell me how to migrate Oracle database from VMS operating system to MySql in Windows XP. ... A: There are commercial tools available that you can purchase that can accomplish the migration. An ...
Date	12/15/2006
Q: i am inserting date through the dynamic SQL e.g. var := 'insert into tab values(v_date)' but when I ... A: Oracle's display default is DD-MON-YYYY. Their date field generally includes a timestamp component ...
Date	12/14/2006
Q: i am inserting date through the dynamic SQL e.g. var := 'insert into tab values(v_date)' but when I ... A: When you query a date field in the database (e.g. using SQL*Plus), Oracle will only show ...
oracle replication	11/27/2006
Q: Can you please explain in brief the differences between:- Oracle Replication,Database ... A: Oracle replication and standby database are the same. As transactions are entered into the archived ...
exp_imp problem in oracle	11/24/2006
Q: 0.1.and i am trying to import the dmp file created in oracle 9.2.but it is not importing. plz help ... A: Good morning Shivaa, If you have more details about the problem that you are encountering (e.g. ...
Configuration of a DB	11/20/2006
Q: I want ask you about how to configure an Oracle 9 data base for an application that handle too many ... A: The Oracle database, with sufficient disk allocation (usually via a SAN-Storage Attached Network ...
*How import .dmp file in my Oracle 9i?**	11/14/2006
Q: i m sheetal.Plz tell me how i m import my all tables in my own Pc.I m telling u that actually i had ... A: The error ORA-00992 : invalid format for REVOKE command, indicates that a REVOKE command was ...
inserting data into oracle through shell scripting	11/12/2006
Q: Hai Mr choi, i want to insert data into oracle database using shell scripting eg:i hv ... A: Here's a sample shell script sqlplus -s usr/pwd << EOF > audit.log select * from emp; exit EOF ...
Oracle commit	11/6/2006
Q: Is there any way to commit rows in dml commands as they go on instead of wait the end of it. For ... A: Because Oracle treats the transaction as a unit of work, it won't commit until the transaction, in ...
Oracle DBA 10G Certification Guide/Manual	11/6/2006
Q: I need Oracle DBA 10G Certification Guide/Manual. Plz. help in this regards.. Regards, Abdul ... A: The link below is a list of Oracle 10g DBA Certification books that is available for purchase from ...
normalizing tables	11/4/2006
Q: Actually, a co-worker told me that this say 100 records and 100 fields table should be reduced to ... A: It depends on the what exactly the query and desired outcome is. Indices are used to speed up search ...
Query	11/4/2006
Q: I HAVE A TABLE CALLED "CALLDETAIL" IN THAT TABLE THERE IS A FIELD CALLED"STARTTIME" IS OF TYPE DATE. ... A: Assuming that your table CALLDETAILS contains at least the following columns (order no specified), ...
normalizing tables	11/2/2006
Q: I have a table in excel to move to oracle. It has an equal number of fields and rows. The rows have ... A: To load data into Oracle from Excel, you can use SQL*Loader for bulk load. If the data records are ...
"LIKE" or "=" ?	10/29/2006
Q: Is using "LIKE" or "=" the same if LIKE has no percentage sign in the where clause? Thannks, lzzzz ... A: "LIKE" is used for wildcard searches. It should be noted that the wildcard symbol in the example ...
surrogate key ?	10/24/2006
Q: I never heard surrogate key before, how to generate that? what is the difference between surrogate ... A: Here's a great definition of a surrogate key: http://en.wikipedia.org/wiki/Surrogate_key It is ...
10g	10/23/2006
Q: i am an it student i have to present a seminar on Oracle 10g will u please send me a document for ... A: Oracle 10g (RDBMS) is Oracle's flagship application. Build on at least 20+ years of experience and ...
ora-12560	10/20/2006
Q: please am new into oracle and am trying to clone a database but when i want to login into this new ... A: Enclosed is a detailed step for cloning an Oracle database. It should include the detailed steps for ...
Example System Using Oracle 10gy	10/18/2006
Q: . Im a degree student from Malaysia taking a degree in Business Computing. I would to ask you did ... A: By Oracle 10g I am assuming the Oracle relational database management system (RDBMS) or database. ...
Can we create a schema such as user1, but without a user by that name?	10/18/2006
Q: Can we create a schema such as user1, but without a user by that name? it seems like we can do that ... A: To create a schema in Oracle, it has to be associated with an Owner (typically it's a user). That ...
DBA	10/18/2006
Q: I am a student of MCA,Sir I want to be a sccessful person inOracle field. what can i do. ... A: I am assuming in "Oracle field" you were looking at being a DBA. There's no substitute for actual ...
proc programming	10/13/2006
Q: i have installed oracle 8i on my windows xp i want to write proc program and run . what are the ... A: You can download Oracle 10g from www.oracle.com/technology \| DOWNLOADS. Once you have installed the ...
ORA-27101	10/12/2006
Q: Am new to oracle and am just OCA. Pls can u give theoder in which to manually create a database. I ... A: The steps to creating a database from the command line (assuming Oracle 10g) can be found here: ...
HWM	10/12/2006
Q: What is High Water Mark? Please Explain in detail. And also how to check the HWM and change HWM? ... A: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:669044239081 AskTom's websit has ...
Databackup	10/4/2006
Q: Sir What are options availible while exporting the data?. Now we are daily exporting the entire ... A: Incremental back up is available with tools from Oracle. If you are using ORacle 10gR2, then RMAN is ...
Insert Rights in a table	10/3/2006
Q: I could not go to the rate the expert screen for the past 2 instalces dur to some error One more ... A: If a user is granted SELECT, INSERT, UPDATE, DELETE on table A, for example, they can issue SQL ...
oracle 7i installation	10/3/2006
Q: sir, i have to install oracle 7i on unix sco openserver 6 will you please send me the ... A: http://www.oracle.com/technology/documentation/oracle7.html is the reference that you will need for ...
ORACLE SQL PLUS VERSION 9 LOGIN PROBLEM	9/16/2006
Q: I have this question again about logging in to sql server plus. By the way, the answer you provided ... A: http://forums.oracle.com/forums/message.jspa?messageID=1079515 The above link has a step-by-step ...
ORACLE SQL PLUS VERSION 9 LOGIN PROBLEM	9/15/2006
Q: Iam having this problem of logging in to the sql plus, what should be the username that i will enter ... A: You can use the SYSTEM username and password to log in to your database. Be advsied that this is a ...
Sql Loader	9/15/2006
Q: Can u send me some links or doc related to SQL Loader Thanks Rakesh A: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/part_ldr.htm#i436326 is the ...
raw datatype?	9/14/2006
Q: I realize there is a raw type in Oracle, when should I use it? is it a standard SQL type? which ... A: RAW AND LONG RAW DATATYPES The RAW and LONG RAW datatypes are used for byte-oriented data ...
Direct-Load Inserts.	9/13/2006
Q: Is it when you use INSERT INTO <table-name> VALUES ?I have a simple question. What is a direct-load ... A: From http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tables.htm#sthref2238, ...
Command Line	9/13/2006
Q: Is there a way to run oracle commands directly from the windows command line? In other words, is ... A: From a command line, if you want to connect and execute a SQL script, say MyCode.sql the syntax on ...
Direct-Load Inserts.	9/12/2006
Q: I have a simple question. What is a direct-load insert? A: Direct-load insert is a quick way of loading data using DML (i.e. via a INSERT command) instead of ...
*How to display the value of a BLOB column in SQLPLUS?**	9/11/2006
Q: How to display the value of a BLOB column in SQL*PLUS? I got an error message "SP2-0678: Column or ... A: http://dba.ipbhost.com/lofiversion/index.php/t2817.html provides sample code on how to view content ...
Software	9/11/2006
Q: What are the features that differentiate them one from the other? For example, is Oracle just ... A: Microsoft SQL Server is a proprietary Relational Database Management System (RDBMS) and is one of ...
Software	9/9/2006
Q: What is the difference between MsAccess, Oracle, Microsoft SQL Server, IBM DB2 and Sybase? A: THey are all different (some proprietary) implementation of a database software. Just like there are ...
Can we create a foreign key based on a view ?	9/5/2006
Q: Can we create a foreign key based on a view ? Thanks, lzzzz A: Yes you can but there are some contraints as to what you can or cannot do. Enclosed is a reference ...
About Forms 9i	8/29/2006
Q: Can forms 9i be run without an application server? Thanks. A: The forms can be run without an application server. You may need to pre-compile the code to an ...
TNS listner recreation	8/27/2006
Q: I am having a problem with the listner on the oracle databse version 8.1.6.0 on windows 2000. Can ... A: The easiest way is to use the GUI. From your Windows' START\|PROGRAMS\|ORACLE\|CONFIGURATION AND ...
oracle 9i on linux	8/26/2006
Q: sir i created a database successfully.next day when i made some changes to that it is giving an ... A: 1. What was your change to the database that then caused it not to open? 2. What is the error ...
Oracle (Basics)	8/25/2006
Q: Sir, What is Oracle? How is it useful for Data Mangement in clinical research in Pharmaceutical ... A: Oracle RDBMS is the Oracle Database. The database is capable of storing vast information. Usually ...
tnsnames.ora.	8/24/2006
Q: What if I just want to connect to Scott/Tiger? MarkI installed Oracle 9i on my computer and I ... A: To connect to your Oracle database on your computer, you have to have the configurations (i.e. ...
tnsnames.ora.	8/23/2006
Q: I installed Oracle 9i on my computer and I didn't know what to input for the host string, so I asked ... A: I am assuming that you;ve installed Oracle 9i on your desktop/laptop running either Windows 2000 or ...
Upgrade from 9i to 10g	8/2/2006
Q: We are doin a peoplesoft upgrade from 8.0 to 8.9 and would like to upgrade our database from 9i to ... A: You will have to make a choice in terms of upgrading PeopleSoft first then Oracle, or vice-versa ...
*run a SQL script file outside SQLPlus?**	7/31/2006
Q: one more question, We usually use the following syntax to run a SQL script file within SQL*Plus, is ... A: from the command line, you can also issue a sqlplus <user>/<password>@<Oracle_sid> <script.sql>. ...
about SQL command	7/31/2006
Q: I wonder if the "PRIMARY KEY and FOREIGN KEY" are SQL commands like the command "CREATE TABLE" or ... A: The "Primary Key" and "Foreign Key" keywords that are defined in the SQL92 standarads ...
Login Problem	7/28/2006
Q: I am student i offen facing problem loging problem everytime i login it gives the error login fail ... A: There are a number of checks that you need to do when you get this type of error: 1. Is the ...
ORA-00979: not a GROUP BY EXPRESSION	7/28/2006
Q: Here is My problem, SELECT POTENTIAL_CALC_MASTER.POTENTIAL_CALC_MASTER_ID, ... A: SELECT POTENTIAL_CALC_MASTER.POTENTIAL_CALC_MASTER_ID, MAX(POTENTIAL_CALC_MASTER.TARGET_YEAR), ...
Tune Oracle System table	7/27/2006
Q: I am using Oracle10g release 2 Express edition and I am new about these concepts. I need to know ... A: http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/logical.htm#i8531 is a great ...
ORA-00979: not a GROUP BY EXPRESSION	7/20/2006
Q: Here is My problem, SELECT POTENTIAL_CALC_MASTER.POTENTIAL_CALC_MASTER_ID, ... A: Your GROUP BY expression has to be against what you have in your select clause. Thus: SELECT ...
oracle developer	7/19/2006
Q: i am bikashraj. i am asking to you, what is grid computing in feature of oracle 10g. i want to know ... A: THe Grid computing theory is you should be able to network many smally servers (or desktops) to be ...
I can not start my Oracle	7/18/2006
Q: Peter, I start it by the order :Oracle DB, listener, EM. And when I try Start-Oracle 10g ... A: 1. Does your database start up correctly? When it is started, can you connect using SQLPLUS? If yes, ...
Advanced SQL.	7/17/2006
Q: I took a class to learn Oracle 9i, but it wasn't Oracle University. Can you tell me all about ... A: These functions are specific to the generation of business intelligence results set that can then be ...
oracle	7/13/2006
Q: plz. tell me difference between oracle8i,9i and 10g. thanks A: Oracle RDBMS 8i, 9i and 10g are all different versions of Oracle. The current supported releases are ...
*How to import file .dmp into oracle???**	7/10/2006
Q: I install oracle server 9i on windows xp system, i have camau_db.dmp file, but i don't know How to ... A: To import a dump (.DMP) file into Oracle, you need to do this from your MS-DOS command line and not ...
Oracle Error	7/8/2006
Q: 1. I am using Oracle 8.1.6 But some times i get error: ORA-00600:Internal error code arguments: ... A: I'm afraid I don't quite understand question #2. Could you please elaborate? As for question #1, ...
Career.	7/6/2006
Q: Can you please tell me how you got your start working with databases, particularly Oracle? A: I acutually started off my career working with some legacy databases (some hand me down applications ...
oracle Exception handling in dos script	7/5/2006
Q: I have written few batch file/Script in dos to select data from a oracle table and creating a text ... A: Within the SQL, you can insert the command WHENEVER SQLERROR EXIT 1; SET TERM ON; SPOOL <output ...
About Select Statement	6/27/2006
Q: previous questions. It cleared my doubts regarding subquery. This is my question now. ... A: If you want to see the rows as they go by, you can do one of two things: (a) Spool the output to a ...
problem while importing .dmp file in oracle	6/24/2006
Q: I am given a .dmp file to import into a database. I am trying to import as given below, which is ... A: To grant a role or privilege, SQL> GRANT <role\|privilege> TO <Oracle_user>; Normally your DBA ...
About Subquery	6/24/2006
Q: But I am afraid you got me wrong . May be the way I asked the question was wrong. ... A: As Subquery is used to resolve a "multi-part" query or question. For example, if you hyave a DEPT ...
*oracle sqlplus reports**	6/9/2006
Q: I am new to oracle and am wondering how I would create a report in sql*plus that was grouped ... A: The SQL syntax that you are looking for is the "GROUP BY". Within your SELECT statement you can use ...
conf. OEM (Oracle 9i Client)	6/8/2006
Q: I have installed Oracle 9i client on my laptop to access 9i database server. I got ORA-12541 error: ... A: Is the OEM installed on your laptop or are you trying to access the WEB-based version of OEM? It's ...
How to reduce execution time for query	6/7/2006
Q: This is Gowreenath once again & thanks for your suggestion. Oracle runs against Java. I refered ... A: I have a suspiscion that your query is performing cartesian products (joining each row with every ...
How to reduce execution time for query	6/6/2006
Q: This is Gowreenath and I am Java developer, when I tried with following query: "SELECT ... A: The error suggests that your JVM heapsize may be insufficient (source: ...
varify after whole database import	6/5/2006
Q: I am going to migrate a small database from oracle 8i to oracle 9i(OP:window2003) using ... A: If you import and export the entire database from 8i to 9i, you should consider looking into ...
Oracle database 7.3.4	6/5/2006
Q: We are currently running an Oracle 7.3.4 database on AIX 4.3. Both of these products are no longer ... A: Oracle 7.3.4 is no longer supported on AIX 5L platform (including 5.1 and higher). The mimimum ...
about interview	6/4/2006
Q: How are you. This is nageswara rao Bollu. my qualification is m.sc(chemistry), and i did post ... A: Good day sir, To become an Oracle DBA, you need to understand the functionalities and capabilities ...
Creating a script file to run a report.	6/3/2006
Q: Do you write the progrmming code in a script file? How do you create a script file from within ... A: A script file on Windows can be created using Notepad or any non-gui based text editor (It is better ...
Creating a script file to run a report.	6/2/2006
Q: I have notes, which are powerpoint slides that were made by Oracle, for Oracle 9i and there were a ... A: The "script file" in the slide refers to the .SQL file (either an SQL report or SQL Query). The ...
oracle coulmn alias more tahn 30 character length	6/2/2006
Q: ------------------------- Hi peter thanks for your reply. But these reports will be generated ... A: The COLUMN format can be place at the start of your .SQL file. This COLUMN FORMAT HEADER will ...
oracle coulmn alias more tahn 30 character length	6/1/2006
Q: I am creating some reports. In select statement iw iould like to have an alias length more than 30 ... A: Generally you would use abbreviations, acronyms or other known short form to represent the column. ...
Thru SQL want to fetch in specifc date format	5/29/2006
Q: In one table i have a colunm called CREATE_DT and date values are in '5/20/2006 6:22:53 AM' format. ... A: Yes it is possible, however you will need to change your column definition for CREATE_DT to be able ...
Thru SQL want to fetch in specifc date format	5/29/2006
Q: In one table i have a colunm called CREATE_DT and date values are in '5/20/2006 6:22:53 AM' format. ... A: In Oracle, you can use the TO_CHAR() function that convert and query your table. The function has ...
What is a synonym?	5/24/2006
Q: What is a synonym, does it exist in other RDBMS? Thanks, lzzzz A: In their article, "What are database objects?", the explain that a synonym is "Synonym: A synonym ...
oracle	5/22/2006
Q: what is the major difference between oracle 8,8i,9i and 10g.. thanks A: AS with any piece of software, Oracle has been evolving its RDBMS product. The latest, 10g R2, ...
how to minimize the query execution time	5/16/2006
Q: I am working as a DBA in a private hospital,Kindly provide me solution for mininizing the query ... A: While the query is running next time, using your DBA tools, capture the SQL and run an EXPLAIN PLAN ...
dbca in japanese	5/16/2006
Q: I have the same pb you use to have : I installed Oracle in japan on WinXP japanese machine. The ... A: My original answer was provided here "http://experts.about.com/q/Oracle-1451/language.htm" . ...
Skewed columns	5/13/2006
Q: In creating histograms,i read a term called "skewed data columns",Can you explain me what does it ... A: In a table of PERSONNEL the gender column would contain non-skewed data. In an INVOICE table the ...
Sid,service,service_name	5/13/2006
Q: In TNSNAMES.ORA file entry for CONNECT_DATA,i've seen three types of entries,one with SID,other