Oracle - Oracle - Computing/Technology

	AllExperts > Oracle
	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 - 11gR1) 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

Using Sql Loader to run multiple instance parallely	11/17/2009
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 ...
Connecting to Oracle server through firewall via VPN	11/11/2009
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 ...
High load sql	11/10/2009
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
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
Q: Respected Sir/Mam Question Number (1) drop table table1; FLASHBACK TABLE table1 TO BEFORE DROP ... A: The detailed steps are listed here: ...
RMAN Backup Database Instance	11/5/2009
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
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. ...
Active sesions Problem	11/3/2009
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	10/23/2009
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
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: ...
howto map a user to a shared schema	10/16/2009
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. ...
impdp/expdp problem	9/30/2009
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 ...
impdp/expdp problem	9/29/2009
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
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
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 ...
Resetlogs	9/19/2009
Q: My question is , when we do incomplete recovery we open the database in resetlogs Why we open the ... A: Here's a great reference that explains the resetlogs: ...
Hot Backup	9/19/2009
Q: My question, can i execute "alter tablesapce begin backup comand" in no archive mode if yes what ... A: If your database is not using ARCHIVELOGMODE, performing a hot backup (through the use of "ALTER ...
oracle DBA	9/16/2009
Q: diffrence between oracle 9i to 10g A: You can find the information here in the Oracle 10gR2 Release Notes: ...
Need Guidance on Oracle	9/9/2009
Q: Iam an engineer and working in ITO from last 3 years after graduation. I need to do an Oracle ... A: Here's the official link to Oracle's Certification page: ...
Oracle Certification	9/3/2009
Q: Sir, I am a graduate in IT I would like to know about oracle certification , I mean where to start ... A: You may wish to start looking within your locale as to what type of training is available for you to ...
oracle dba	8/30/2009
Q: Sir i am i B.Com graduate and i want to do a oracle dba certification i have 3 years exp. in IT ... A: The Oracle DBA certification makes sense if you intend to pursue work with the Oracle database. ...
impdp from another server	8/18/2009
Q: Sorry for disturbing you again. But some moments are still not properly understood for me. In ... A: 1. USER DEFAULT TABLESPACE. Before Oracle 9i, by default, when you created an Oracle user, they ...
oracle sql	8/18/2009
Q: Mr. Peter Choi first I'd like to generate a random subject code in the following form: 'cccc999', ... A: 1. Randon characters/numbers. You can make use of the DBMS_RANDOM() function: Sample and usage URLs ...
Default Tablespace for USER	8/15/2009
Q: I have some questions, but before ... Several time ago I asked about how to clean all data from ... A: 1. You can use the EXCLUDE/INCLUDE function to specify specific meta data (e.g. tables obejects) or ...
impdp different schema	8/12/2009
Q: I try to impdp dump file from one user and remap schema from another but get an error ORA-39146. ... A: The ORA-39146 indicates the target schema that you are trying to map to is incorrect or does not ...
View Tablespaces	8/11/2009
Q: Can you show me the oracle sql comand which can help me to: determine which tablespace belogs to ... A: 1. You can use this code snippet: SET ECHO OFF set newpage 0 ttitle center 'Database Usage by user ...
sql query	7/27/2009
Q: emp001 emp002 14 emp002 emp003 8 emp003 emp001 12 emp003 ... A: I don't know what your two columns represents, the one containing EMP001 EMP002 EMP002 EMP003 ... ...
structure of db	7/26/2009
Q: I am developing a site with mulitilingual feature.its working fine without any problem.first, the ... A: It is not uncommon for your user (or any user) to deliver requirements that technically sound ...
listing table names	7/22/2009
Q: Peter, I am a sometimes SQL user, and never seem to remember the basics - how do I find the table ... A: To look up table names in a schema, you can use the following metadata view: USER_TABLES (for ...
Oracle Database	7/22/2009
Q: i am very new to oracle..I want to learn, how to make database and how to make them secure with ... A: You can use this quick reference to install Oracle 11g R1 on ...
query for deleting rows	7/21/2009
Q: I am sandeep gupta i want to know that how can i delete all the duplicate rows using single sql ... A: There are 3 possible ways to remove duplicate rows (one does involve ROWID): (Reprint from ...
Oracle-DBA	7/13/2009
Q: my database is accessing by many users(500users),some users (120users) are reported that they unable ... A: That depends on how those 120 users' privileges are defined. Typically, an Oracle user is assigned ...
oracle	7/9/2009
Q: how to install oracle 10 i in vista 32 bit A: Oracle has an quick easy-to-follow visual guide available here: ...
Clearing Oracle Database	7/7/2009
Q: I have a question about how to clearing Oracle 10.2.0.3 Database (clearing database files, free it) ... A: NOTE: This will remove the database as well as all the data in this database. Tables and tablespaces ...
SQL	6/23/2009
Q: Sir, Kindly give me the difference between the Tracing and Auditing in SQL A: When you're performing a trace you are following step by step what the SQL is doing. This is ...
Oracle 7.3.3	6/22/2009
Q: Where I will get the Oracle 7.3.3 version for download?? A: Oracle 7.3.3 is no longer supported and is not officially available for download. You might want to ...
Zero Length condition	6/20/2009
Q: While creating table, there is options like allow null or not, similarly is it possible to implement ... A: You may wish to consult the Oracle 10gR2 CREATE TABLE reference: ...
Default Constraint	6/20/2009
Q: Will you please help me to implement Default constraint for multiple columns using alter statement. ... A: Not understanding your business requirements, I can point you to several good references on creating ...
dynamically creating table as per the csv file	6/15/2009
Q: I want a help in creating dynamic table as per the csv file. The csv file which is to be uploaded ... A: There isn't an easy way to create a table based on a dynamic data set (i.e. varying columns and ...
data transfer from CSV file to database.	6/5/2009
Q: I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table. Can ... A: You can use SQL Loader ...
Oracle Surrogate key on OLTP Loads	5/29/2009
Q: I am loading normalized structres from denormalized inputs and want high concurrency and fast load ... A: Here's a great thread from Oracle guru, Tom Kyte, on what's the best way for managing large/high ...
pl/sql	5/28/2009
Q: am going through a plsql procedure by which an xls file is created using util_file. My question is ... A: Here's a great article and example of creating an XLS (MS-Excel) file using utl_file. ...
oracle error	5/28/2009
Q: I install Oracle 9i on my Windows Xp platform..but during login it shows me error no adapter ... A: The official installation documentation for Oracle 9i (9.2.x) on the Microsoft Windows 32-Bit ...
Performance issue fetching millions of rows	5/27/2009
Q: I need your input on a decision. We have a 10g db running on Linux and want to do selects of say 500 ... A: Oracle's Real Application Cluster (RAC) provides higger availability and allow for multiple nodes ...
imp in system..... (2)	5/23/2009
Q: Two days ago I asked advise on cleaning out my system user after importing a dump file rather ... A: Which ever way that you are comfortable with, will work. In the case of using 1a (Excel) you ...
imp in system.....	5/21/2009
Q: I have a question and I really hope you have an answer :-) I received an Oracle dump without ... A: Ideally, you would have taken a database backup before you imported objects into your database. ...
Two Oracle 10g DBs under two different AIX users	5/12/2009
Q: I have AIX Server 5.3 and installed Oracle 10g (10.2). One DataBase (DB1) already working under ... A: By using the ALTER SYSTEM SET LOCAL_LISTENER, you are forcing that database to use the specified ...
Two Oracle 10g DBs under two different AIX users	5/11/2009
Q: I have AIX Server 5.3 and installed Oracle 10g (10.2). One DataBase (DB1) already working under ... A: 1. You need to make sure that you have defined 2 separate Oracle Homes. If user oracle1's ...
Peoplesoft Tuxedo traffic	4/21/2009
Q: Peoplesoft 8 and 9 utilizes Tuxedo as the underlying technology)it handles traffic from the ... A: From a networking / infrastrcuture perspective ---------------------------------------------- In the ...
Oracle error	4/21/2009
Q: Sir , My orcle 7.3 database is in Sco open server 5.6 RAM is 4GB while starting the oracle database ... A: Your problem may be related to how much memory is allocated to the SGA vs. what RAM is physically ...
table	4/20/2009
Q: What is table? what is field, record,column and row and their difference? A: In databases, a table is composed of attributes, typically called columns. Theses columns (or ...
import dmp into oracle8i	4/8/2009
Q: i ve a dmp file in my pen drive, which i copied, precisely exported from my SQL --oracle 8i in my ... A: 1. It is possible using IMP and EXP commands to transfer data from one Oracle system to another. To ...
about ORACLE DB	3/30/2009
Q: What is the current capacity of ORACLE DB? A: On a Windows systems, the largest database that can be supported is 4 petabytes. See the paper for ...
sql on oracle 8i not started after restart	3/24/2009
Q: sql plus is not started after restarting the system. though before restart it is running ... A: On an Oracle 8i database, you need to follow the checklist below: 1. After restarting your database ...
Import & Export Data	3/23/2009
Q: Q. 1 I have TOAD software .My Question is i am unable to "employees table" of "HR" user to Export ... A: Answer to your first question, this comes form a user forum: ...
Query	3/21/2009
Q: How i can get all_available schema/owner in oracle ANSWER: Hi, You can query the ALL_USERS view to ... A: http://www.oracle.com/technology/sample_code/tech/windows/odpnet/howto/connect/index.html Here's a ...
10g As R2	3/9/2009
Q: sir , I have installed oracle 10GAS R2 on redhat enterprise linux 4 first i installed the OracleAS ... A: Here's the documentation from Oracle on configuring your forms to work on the web: ...
design of db	3/5/2009
Q: we are developing a site for classfieds.the site will have different categories and different ... A: The design needs to be flexible, but you also need to put some limitation to your scope. You will ...
dataretrieval	3/4/2009
Q: i am using oracle 10g with windows xp in my system. my question is.. i have entered 10 times ... A: You can use the DBA account that allows you to login and a) reset your Oracle password; b) unlock ...
illegal data retrieval by locked usesrs	3/3/2009
Q: i am sivakumar studing 2/3 MCA . i am using oracle 10g with windows-xp. my question is.... through a ... A: If a user is "locked" its priviledges need to reflect that. Issue the command: SQL> ALTER USER ...
Re-Attach Oracle DB	2/25/2009
Q: I'm running Oracle 10g on Windows Server 2003. The machine has an OS drive and Data drive. The OS ... A: You may have to implement your DR plan for these Oracle databases. If you do have a good backup (via ...
Re-Attach Oracle DB	2/24/2009
Q: I'm running Oracle 10g on Windows Server 2003. The machine has an OS drive and Data drive. The OS ... A: 1. What version of Oracle was your database at when the failure occurred? Was it at 10.2.0.1 or ...
Re-Attach Oracle DB	2/23/2009
Q: I'm running Oracle 10g on Windows Server 2003. The machine has an OS drive and Data drive. The OS ... A: What you need to do is configure the listener so that you can start up that process. You can use the ...
ORACLE Remote DataBase Access	2/21/2009
Q: I am facing 2 problems in the distributed database 1) By using a DataBase Link i am able to issue ... A: StoredProcedure when invoked is inserting data but not committing it. ...
ORACLE Remote DataBase Access	2/20/2009
Q: I am facing 2 problems in the distributed database 1) By using a DataBase Link i am able to issue ... A: 1. You might want to conduct a test in the target system, using the USER that the database link ...
que.	2/18/2009
Q: differance between oracle 9i,10g,11i,11g A: http://www.orafaq.com/faq/features_introduced_in_the_various_server_releases This highlights major ...
error on runing .fmx on the web	2/18/2009
Q: i try to deploy my .fmx application on the web (local network). i have set the formsweb.cfg file and ... A: You probably need an entry that follows this syntax: userid=username/password@connect_string ...
Database Rollback & recovery	2/17/2009
Q: I have two scenarios in front of me. Please try to guide me. 1. I have a cold backup of my database ... A: 1. You cannot rollback if you have a backup only of the 19-Jan-2009. If you had a backup of ...
**- Setting up Database -**	2/6/2009
Q: I'm a student doing business computing and I am in my final year. We just started using Oracle ... A: Here's where you can go to download the software: ...
Calling SQL from UNIX	1/30/2009
Q: I have written a unix script to fetch the files from server to local, read the data from the file ... A: I am assuming that you are using /bin/sh (the generic SHell script that's available on all unix ...
Exception in Inserting Data	1/30/2009
Q: I will explain my doubt with an example. Let us take one anonymous block... In that Block, am ... A: Here's an example of inserting values into a table, but when a divide by zero is encountered, a null ...
strtdb80.exe	1/23/2009
Q: whenever i boot the system,it works very slowly and shows the error message in strtdb80.exe. A: Oracle 8 and 8i are out of support from Oracle. You can take a look at Oracle 9i (due to be out of ...
Oracle Locks	1/22/2009
Q: Please look into below case, Environment : Oracle 10G (10.2.0.1) OS is RHEL4.5 Application : 3 ... A: Good morning Pradeep, My first take would be that this is an application error that is causing the ...
dual table	1/16/2009
Q: i added a column in dual table but now i am not able to drop that using sys schema also what should ... A: Can you please send me the script and the oracle user that you used to create the column into the ...
DBA career	1/15/2009
Q: I'm hoping you can help me. I have a good working knowledge of computers, and I quite enjoy ... A: When you talk about being a DBA, for the sake of this forum, I'll assume that it's working with the ...
sga per session	1/15/2009
Q: Please tell me how can I check which session utilize the how much sga memory Please reply asap. ... A: Refernce: http://www.oracle-training.cc/t_viewing_sga_performance.htm VIEW DESCRIPTION v$sga ...
Oracle 9i Forms	1/15/2009
Q: Choi. i m using oracle 9i form builder and oracle 9i database server. i want to connect a form with ... A: 1. Using the Oracle Forms, you need to set up an Oracle user with the privileges that you need. You ...
RAC	12/4/2008
Q: i am an oracle 9i certified dba i want to learn 'real application cluster'please advice me there is ... A: Here's the Oracle 11g information about Real Application Clustering: ...
queries regarding DBA	12/1/2008
Q: I wanted to do DBA. i have seen your profile.. can you advise me regarding DBA scope? i am working ... A: To become a database administrator, you need to understand how a database works and how that ...
PS security	11/17/2008
Q: If the user has two roles for example with access to the same page and if i remove one of the roles, ... A: Assuming the two roles with access to the same page had the same access (e.g. read-write), then with ...
oracle 8i	11/13/2008
Q: how to import .dmp files from oracle 8i A: Here's a great reference about import (it can apply to 8i, 9i and 10g- so long as you're not using ...
Select and Group BY	11/8/2008
Q: I've got this select which works just fine: SELECT a.partNum, MIN(a.Quote) as "Price" FROM ... A: I'll use a simple example from my earlier one. If I wanted to count how many members are in each ...
Select and Group BY	11/8/2008
Q: I've got this select which works just fine: SELECT a.partNum, MIN(a.Quote) as "Price" FROM ... A: If I extended my example query so show me the lowest student id in the query: SELECT ...
Select and Group BY	11/8/2008
Q: I've got this select which works just fine: SELECT a.partNum, MIN(a.Quote) as "Price" FROM ... A: Your select statement can include selecting from both tables. What you need to look at is the ...
Oracle index internals	11/7/2008
Q: When index is created on a column of a table, what exactly is stored in the index. If every value of ... A: In an Oracle table, each row in every table is assigned a unique ROW ID identifier (You can't see ...
Trace of an oracle stored procedure	10/31/2008
Q: How can I get the statistics of an oracle stored procedure, like cpu,timing statistics etc. Can we ... A: In Oracle 10gR2, the SQL TRACE utility is available to generate some statistics: * Parse, ...
About NVL	10/29/2008
Q: I write a query with huge data with NVL function in C#.Net for Oracle 11g then i see that the result ... A: It's possible for that query, you might need a function-based index: i.e. an index on that column ...
Normalization	10/26/2008
Q: what is 1st-NF(normal form) A: Here's a great reference as to what the 1st normal form is: ...
PS Security	10/23/2008
Q: I am getting an error message "Authorization Error -- Contact your Security Administrator " when i ... A: If you have copied or cloned your user/role/privilege from an existing user/role/privilege and then ...
logging on to oracle to unpoplulate db	10/22/2008
Q: I am a new hire for my company and running thru a set of instructions i have received from them. In ... A: Without knowing what your script is doing, here are some things to look at or note: 1. It would ...
sudo columns	10/20/2008
Q: could u tell me where oracle store sudo colums values i know this is not an actual column but when ... A: The pseudo column values are not stored anywhere in Oracle. Rather, it is derived. For example, when ...
sudo columns	10/20/2008
Q: could u tell me where oracle store sudo colums values i know this is not an actual column but when ... A: Dual table is like your scratch-pad. you can try different queries & functions using Dual. For. e.g. ...
scn	10/20/2008
Q: I want to understand what is a SCN in oracle what is use and important. please explain me brefily . ... A: The system change number (SCN) is an ever-increasing value that uniquely identifies a committed ...
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 with ... A: Good morning Malru, 1. SID corresponds to Oracle Instance Identifier (usually Database name) ...
OracleServices	5/13/2006
Q: Can you explain me,what is the need of creating Oracle Services for a database using ORADIM? How ... A: http://www.orafaq.com/faqwinnt.htm#services is a good starting reference point. The service to ...
Creating users	5/10/2006
Q: how can we create user account in Oracle8i, and grant the permissions, setting up the password A: The syntax to use is: <...> denotes user supplied information. [...] denotes optional command ...
Importing Data into Oracle	5/9/2006
Q: This is Murthy. I've a Problem in Importing Data Into Oracle From .dmp File I've got a .dmp file ... A: What is the IMP command (along with the flags) that ou used to import the data? The other ...
decode function in oralce sql/pl	5/8/2006
Q: Peter , thanks a mill for the quick reply,at the moment I am cramming for the exam for tomorrow I ... A: The DECODE function works its magic the same way as explained in your instructor's note and in the ...
decode function in oralce sql/pl	5/8/2006
Q: have you any good exaamples of the decode function doe beginners here are a few sample questions ... A: 1. Here's a web linnk to shows a great example of how the DECODE function works within Oracle's ...
Calculate time scale difference	4/29/2006
Q: SQL> desc xx_time Name Type ---------------- ------------------- STANDARD_START ... A: You might want to change the column from a NUMBER(4) to the datatype DATE. This way you can use DATE ...
Oracle 9i	4/27/2006
Q: Can you explain me in detail about,in oracle,what is active session and inactive session? And Is it ... A: I'm not sure in what context you are referring to. I will assume that you are referring to ...
questions	4/25/2006
Q: so when using databases, I heard mysql was the best, is mysql usable with oracle, I just want ... A: First thing's first. A database is used to store and maintain a collection of data. Thus you can ...
questions	4/25/2006
Q: So I can use it to build databases regularly for people as a professional web designer, coder, ... A: With the tools and the link that I provided, yes you can use them to develop various solutions for ...
Importing a database	4/20/2006
Q: We have a Oracle Database on an old Server. We want to copy its database to a new server so that ... A: The answer to your question comes courtesy of Mr. Don Burleson ...
questions	4/19/2006
Q: I need to know something though, I don't use a server, I use an internet server, my clients normally ... A: You can download Oracle for free (singler-user developer version) at ...
questions	4/13/2006
Q: I have some questions, answer what you can, please number them some so I don't get confused, like if ... A: 1. SQL is defined by the IEEE and ANSI as a standard (SQL92 to be precise). Thus all database ...
oracle	4/11/2006
Q: how to display the duplicate records of the table. What is the diff b /w union and union all. How ... A: Here's an excellent web site that illustrates the difference beween UNION and UNION ALL. Reference: ...
Oracle Database Backup options	4/9/2006
Q: I am using VB.NET 2003 as a front-end for Oracle 9i database. I want to know how many types of ... A: Oracle database comes with two types of popular and easy forms of backup, three implementation. ...
Oracle 8.0 on Unix with D2K	4/7/2006
Q: My client has developed an application for billing on D2K forms and is using Oracle 8.0 on UNIX as ... A: I've enclosed two reference for you as I'm not sure which version of Hindi you may be using. ...
is there any way to run oracle enterprise edition on win98	4/4/2006
Q: i want toknow is there any way to install oracle 8i enterprise edition on windows 98. note:any exe ... A: It's not recommended to install Oracle 8i Enterprise Edition on Windows98. The Enterprise Edition ...
Analyzing Partitions	3/28/2006
Q: I have an Oracle 9i database with a couple of tables that have been partitioned by date. I want to ... A: You might wish to refine your DBMS_STATS to tune it to your requirements. If your performance is ...
Dear Anonymous I m working...	3/27/2006
Q: I m working as a DBA in a hospital .Currently there are two servers(Hp proliant ml 370,ORACLE8i) ... A: Enclosed is an article from Oracle that may help: SCOPE & APPLICATION The audience for this ...
Oracle Capacity Planning	3/27/2006
Q: I am asked to do capacity planning for our oracle database. Can I get more information for the ... A: Basic capacity planning should take into account the following: 1. Table structures and the max ...
I just want to create a table...	3/20/2006
Q: I just want to create a table in oracle which contains the hierarchial view for eg science ... A: Following is an example: To implement the hierarchal structure, you can create a table called ...
Trouble running repository reports	3/14/2006
Q: Running Oracle9i Designer. Cannot run any reports in the repository as a normal user. I get the ... A: Here's a tech tip from Oracle: Subject: CDI-21338 'No Results to display' when running some ...
Italy	3/9/2006
Q: Who discovered Italy? Thank you. A: I think you have the wrong category (This is an Oracle forum). Might I direct you to ...
sql query	2/23/2006
Q: ora9i using, i want to reterive data from a transaction table of employees their last balance ... A: I am assuming that your tables contains the columns with Leave Dates, Employee Number, Balance Days. ...
oracle9i import-export through OEM	2/20/2006
Q: -Windows 2000. I want to import a dump file(from another Oracle database) given to me in *.DMP ... A: Instead of using the GUI, try it from the command line. Make sure you've defined your $ORALCE_SID ...
oracle	1/16/2006
Q: Is any command in oracle thow the all data send to excel sheet from the database . A: There is no Oracle commmand that can automatically send data to an excel sheet. You can, however, ...
Ref: databases	1/15/2006
Q: Good day, Can you tell me: 1. What is involved in building a database. 2. Are there online services ... A: Take a look at technet.oracle.com. You can register for a free account. Oracle does provide a free ...
Oracle database space issue	1/14/2006
Q: I am using Oracle 9i. Is defrag tablespace the best and only way to free up space on the database? ... A: It depends on how badly defragmented your tablespace. If you have a lot of free space but are ...
Oracle 10g installation	1/12/2006
Q: I am a GIS specialist in Montreal, Canada and look to install a single user Oracle 10g Dbase on a ... A: The major difference between XP Professional and XP Home is in the communications packaging. XP ...
oracle database	1/10/2006
Q: i want to know how in oracle we can find MOST USED TABLES (in terms of ... A: Other than using auditting, the next best thing might be to create triggers on the tables. This ...
Copying Oracle Database	1/7/2006
Q: How do I copy Oracle Database or Oracle Database instance from a network to my local machine. We are ... A: You can either backup the Source database using EXPORT to produce an Oracle .DMP file. This can be ...
TKPROF analysis of Oracle reports	1/6/2006
Q: Peter I have followed these steps. These steps are great for trace of SQL script. The report is run ... A: If you are using SQL TRACE within SQLPlus, it only works for that session. * WARNING ! *** ...
TKPROF analysis of Oracle reports	1/6/2006
Q: Peter- I did all that already. The main query runs in less than 2 minutes when run outside the ... A: Option 1: --------- As outline in the Oracle manual ...
TKPROF analysis of Oracle reports	1/6/2006
Q: Report execution time went from 2 minutes to 30 minutes... I need to see a TKPROF formatted ... A: Before hitting TKPROF, I would suggest that you run your SQL in question through an Explain Plan. ...
I installed Oracle xe on my...	12/9/2005
Q: I installed Oracle xe on my pc windows xp, every time when I tried to connect into database, it gave ... A: Causes of ORA-27101 Unable to locate shared memory realm. So it may be one of this 1. You may ...
Using Stored Functions within a View	12/8/2005
Q: I've got a table from which I want to retrieve 3 different values based on the same key (one of ... A: Just a thought. Instead of having to create a function to lookup date x, x-1, x-2, why not use a sub ...
language	12/7/2005
Q: I am running the Dbca tool on the windows operating system for the database creation.My windows ... A: You will probably need to change the Windows OS default language to English for the DBCA application ...
oracle database	12/5/2005
Q: sir we are running oracle9i on server(LINUX) and space on server is less. so we want to take export ... A: If you are exercising the exp/imp feature, that should be easily done (note that you'll be importing ...
Indexes.	11/28/2005
Q: As you go down from the root of the B*tree, how does the information get divided between the left ... A: Here's some great sites that will further explain how Oracle Indexing works: ...
oracle db clone - oracle 9.2	11/28/2005
Q: I have to start TEST from PROD .TEST db was already running earlier. Now while staring I get error ... A: Enclose link is a full checklist to restarting your database. ...
Indexes.	11/25/2005
Q: What is an index? A: Think of a telephone directory or yellow pages. Image that you needed to look for a somone. If the ...
Materialized View	11/25/2005
Q: I have created a "Materialized View" on Table "Student_Record" and mantained a "Materialized View ... A: Reference: http://www.databasejournal.com/features/oracle/article.php/2192071 The materialized ...
oracle database	11/16/2005
Q: sir we want to get statistics of a remort database to be stored in the table of our local database ... A: Enclosed is a note from Oracle on how to accomplish what you are looking for. Hope this helps! ...
database links	11/16/2005
Q: I am doing database links but giving this error ORA-2019...I am totally confused that wether i am ... A: The error that you've encountered is described by Oracle as ORA-02019 connection description for ...
Explicit cursor	11/16/2005
Q: Can u please tell me when will we use explicit cursor apart from this condition that " when query ... A: Take a look at Chap 6.3.3. http://www.unix.org.ua/orelly/oracle/prog2/ch06_03.htm Excplicit cursors ...
to connect to remort server	11/15/2005
Q: sir we have following information of a remort server running oracle 9i with us 1-service name 2-host ... A: on your remote client, you will need the Oracle Client ...
Oracle 10g	11/12/2005
Q: and as I hear is Oracle DBA really the highest paid in the IT department.. Lets say I studied DBA ... A: The basic Oracle administrative work has not changed all that much between 8, 9, and 10g. However, ...
IT @ home	11/10/2005
Q: In which IT careers & position have you noticed it to be a common practice and/or reasonably ... A: Many employers do allow employees to telework on a part time bases (max 3 times a week for example). ...
Oracle 10g	11/9/2005
Q: What is Oracle 10g and how it is different from Oracle 8i and 9i? A: On the surface of it, 10g is not all that much different from 9i, especially if you're using only ...
Remote Database Access Techs	11/8/2005
Q: I'm doing R&D into accessing oracle databases remotely and I wanted some suggestions for other ... A: Using Oracle's DBLinks is the easiest way to access content from another remote Oracle database. ...
where can i do training for...	10/22/2005
Q: where can i do training for oracle application DBA. what are the topics covered in the course ware. ... A: For starters, you can always check http://www.oracle.com/education to identify the closest training ...
Problem with Oracle 9i	10/19/2005
Q: My name is shakeel and i am student of BS honors I have installed Oracle 9i on my system and having ... A: I usually use the SQLPLUS.EXE (Windows GUI for SQL*Plus). This version is usually located in ...
SQL Query	10/17/2005
Q: I want the query for giving the records...which shows all the employees with same salary..... if ... A: The query would look something like this (depending on your table(s) structure: select NAME (of ...
oracle not responding	10/12/2005
Q: i am trying to create a table in an oracle7 database but the database is not responding. i can ... A: Are you getting any response back, such as an Oracle error code (ORA-xxxx <descriptive text> or is ...
temp dbf file	10/8/2005
Q: I have one query that in my database one of the tempfile size become almost 9GB. I created another ... A: 1. I am assuming that you are referring to a tempoary tablespace file (DBF). Here's some info from ...
why important database programming	8/22/2005
Q: What is database programming and why is it important? A: Database (DB) programming follows SQL-92 standards as defined by the ISO (International Standards ...
Setting entries in ORACLE_HOME	8/18/2005
Q: I need to set the entries in ORACLE_HOME for my Oracle 10g database and 9i Client Libraries together ... A: The easiest is to maintain TWO separate ORACLE_HOME. That way you can keep the two clients (and ...
Website links	8/13/2005
Q: Peter! As a "newbie" I understand (?) linking / spiders / ranking. What I don't understand is the ... A: There are some interest groups that create "webrings" that is essentially a link to the next web ...
query by letters	8/11/2005
Q: How do I make a SELECT statements where I want results from everything that starts with certain ... A: You can use ... SELECT ..... FROM ... WHERE NAME LIKE 'A%' The "%" is a wildcard symbol. So in the ...
Query	8/10/2005
Q: One of my users have a query that provides a resultset for his reports. This query runs fine when it ... A: It sounds like the query is perfoming a full-table scan against the table. You might want to run an ...
Managing Rollback Segment Manually	8/9/2005
Q: I have been asked by our new client, that the the Table are not deleted completely Information ... A: If you have lots of rows to delete from a table, using the DELETE DDL is not a great idea. DELETE, ...
Enable cache option for tables	8/8/2005
Q: In Oracle 9i, how to enable 'cache' option for certain tables frequently used? In the following ddl ... A: Enclosed is a link to the Oracle documenation (and example) on how you can "pin" your database in ...
career in dbms	8/6/2005
Q: sir, Thanks for your valuable suggestions. According to you ,one should have working experience to ... A: You can look for co-operative experience or any volunteer work or employment with smaller ...
career in dbms	8/3/2005
Q: sir, I am a 3rd yr student of B.Tech(CSE)in india.My aoi is DBMS.I want to know about career ... A: Getting the certifications would give you an edge over the competition. However, you will need to ...
Comparing two versions of a database columns	8/2/2005
Q: How can I compare two database versions' columns and attribute size changes. I have a dataabse in ... A: You can setup a database link from DB version 1 to DB version 2 (or vice-versa). You want to set one ...
how to set the BEa weblogic for SAp or peoplesoft	7/27/2005
Q: i want to know how to set up the weblogic server and weblogic integration as well for people ... A: PeopleSoft actually delivers the documentation to setup Weblogic. Installing weblogic is straight ...
Related to Oracle query	7/26/2005
Q: I have a situation where the names of oracle tables are given dynamically, so are not known to us ... A: You can define variables in within SQL and assign the value to the variable. Static: UNDEF ...
Indexes	7/20/2005
Q: What are the types of the indexes and which is the most commonly used. How to check whether query is ... A: Of all the indexes, the most commonly used is the B*-Tree index. It's a B-Tree ...
dba question	7/19/2005
Q: I hope you rember me my name is ahmed i asked two week a go about tips in oracle dba. I want to ask ... A: Start with Oracle 9i and 10g. These two are the most current release. Start with the Oracle ...
creating columns & deleting tables	7/16/2005
Q: I'm a newbie in Oracle/Sql*Plus 2 very basic questions I can't seem to find in my course: about ... A: 1 - Adding an extra column can be done in two ways. Prior to Oracle 8i, you would have had to copy ...
Create TEMP Table dinamically	7/12/2005
Q: I have to perform a VERY difficult task. I need to create a TEMP table dinamically that will load ... A: I am assuming that the meta data for the temp table that you have to create dynamically contains all ...
experince question	7/10/2005
Q: Peter Choi thanks for your kind replay for my question, I hope to you all sucess. If you may i have ... A: I believe in learning how to walk properly then learn how to run. The same applies for Oracle. The ...
Oracle 9i database and Oracle 9i Application server.	7/8/2005
Q: Our oraganization there is three tier solution Oracle 9i databse server as database server ... A: There are a number of places that you can check to see where the latency is occuring. But the number ...
work question	7/7/2005
Q: Peter Choi i am very happy to talk with a Senior ORACLE DBA, my question is i am a fresh gradute in ... A: Don't give up hope! You're starting off in the right work. DBAs not only do work setting up and ...
ORA-01033 Error	6/28/2005
Q: I still was not able to connect using your two suggested methods, however I was able to use "DBA ... A: Try the following steps in sequence. If you get an error, please let me know. 1. Shutdown database ...
ORA-01033 Error	6/25/2005
Q: Your explanations seems very logical and I'm confident that it is the solution to my problem. I am ... A: My bad. The command that you would be looking for is SVRMGR (on some unix servers it's SVRMGRL) ...
extracting fmb/fmx files	6/25/2005
Q: I have oracle forms developer 9i installed and oracle itself installed(putty) if that means ... A: Putty is not an Oracle delivered product. It is often used to setup a secure connection (i.e. ...
extracting fmb/fmx files	6/23/2005
Q: i would like to know how you would go about copying a .fmb and an .fmx file from oracle to my ... A: .FMB and .FMX files are created using the Developer 2000 or Oracle Forms Designer (6i) application. ...
ORA-01033 Error	6/23/2005
Q: I took my older computer in to a shop to get a card installed for it to be able to interact with a ... A: It seems like when you got your card installed, the computer was shutdown with the database still up ...
Queries regarding training	6/19/2005
Q: Resp sir , I the undersigned has completed my BE(MECH) in 2001 and then worked in a ... A: If you wanted to further your career as a developer, Oracle recommends the following technology ...
Oracle JDeveloper	6/13/2005
Q: What is Oracle JDeveloper and why is it so hard to find people with that particular skill set? A: Oracle JDeveloper is an integrated development environment with end-to-end support for modeling, ...
Re:How do I get Oracle Clinical	6/2/2005
Q: Hullo, How do I get oracle clinical. I want to install it on my computer and start using it. JP A: Most Oracle software is available here: http://www.oracle.com/technology/software/index.html. You ...
Export Import	5/24/2005
Q: I am an Asp programmer.Not well versed in Oracle. Exp.exe and Imp.exe of my oracle server are nor ... A: Before you run the EXP or IMP commands, you have to make sure that the ORACLE_SID variable is ...
vsb format for databases	5/19/2005
Q: I am sorry but I do not know where to ask my question given it is quite particular. I would like to ... A: Salut Jean-Michel, Oracle only supports its native format, .DBF. You can write Oracle SQL code that ...
Avoiding hardcoding column names	5/11/2005
Q: I'm trying to pull data form tableA without ever specifying colulmn names. My requirement is to pull ... A: You can use the INSERT statement that incorporates a select, thus insteading of doing two actions ...
database configuration	5/4/2005
Q: i am an oracle dba into dba job. i would like to know what things you consider while configuring ... A: The DB configurations depend on the behaviour of your database. For starters, since your DB is 24/7, ...
Lost pasword!	5/1/2005
Q: I forgot SYS password and I cannot connect to DB with using console! what should I do? Please help ... A: You don't mention the OS. If it is unix, you can login as internal (DBA group user doesn't need to ...
SQLPLUS/ OEM	4/29/2005
Q: I can read tables from the OEM. I can select all rows from the OEM logged in as the ... A: I think you've gotteen the wrong Peter (I'm from Canada and have never heard of Ace Computer ...
SQLPLUS/ OEM	4/28/2005
Q: I can read tables from the OEM. I can select all rows from the OEM logged in as the ... A: You can always try to prefix the tables with <schema>.<table> ex: select * from charlie.department; ...
oracle dba	4/27/2005
Q: i am an oracle dba hv exp.5+. years. i hv a gap of 1 year after that i am struggling to get a job in ... A: You may wish to send out your resume to consulting companies or companies that you know have Oracle ...
Software Design Proposal	4/26/2005
Q: I am writing a design proposal for a software that could be used for a charity organization. The ... A: You might also wish to try out the experts with Microsoft (this is the Oracle forum). You seem to ...
strtdb80.exe problem	4/26/2005
Q: I am using developer 6i at client end on windows xp 2002. When I start windows, I recevied ... A: You might want to check with Oracle Support for this problem. I've looked into this, and most of the ...
login problem in oracle management server 9i	4/19/2005
Q: Sir I am able to log in standalone mode in but cant able to login in oracle management server. ... A: You might want to make sure that your TNSNAMES.ORA is configured to connect your database. Another ...
Question!!!	4/18/2005
Q: i have an error message when installing report services 10g as below: Oracle Application Server 10g ... A: Oracle must be installed in a new oracle home location for every new version. The software itself is ...
pfile	3/11/2005
Q: sir i hav my init.ora file at c:\oracle\admin\test\pfile\init.ora i copied this file to another ... A: Until Oracle 8i DBAs have been using a text file called the pfile (parameter file)to store the ...
What is correlated subquery?	3/8/2005
Q: What is correlated subquery? Thanks, lzzzz A: "In SQL, a query that cannot be evaluated independently, but that depends on the outer query for its ...
Presort	3/4/2005
Q: I want to use presorting for deleteing records satisfying a date condition from a huge table(20 ... A: You may want to make sure that you have an index with the fields that you would be using as your ...
Clone PeopleSoft 8.8 Oracle DB	3/3/2005
Q: Cloning a PeopleSoft 7.5 Oracle database (making a copy of production DB and renaming to a testing ... A: Cloning the 8.8 database still follows the procedure for a 7.5 database. That does not change. You ...
ROLLBACK SEGMENT	2/22/2005
Q: does rollback segment keep uncommitted data or committed data according to oracle student guide ... A: The RBS stores only uncommitted transactions. It is only once you issue a COMMIT statement, that the ...
oracle architectue	2/22/2005
Q: while performing rollforward does smon reads from logfiles and does it writes to database buffer ... A: INTRODUCTION ============ This article discusses the most common concepts of backup and recovery ...
Version and build control	2/21/2005
Q: I want to ask about build and version control. I intend to reverse engineer an existing SQL Server ... A: The way that you have suggest would work, but it would be a labour intensive on your part (i.e. ...
unable to connect database server	2/3/2005
Q: Thanx for ur quick response Peter Yes I have done all both the pcs r on the network. Also developer ... A: Can you ping the PC with the database on it? If you can, can you run TNSPING [dbname]. The latter ...
unable to connect database server	2/2/2005
Q: I have installed oracle server i.e.,oracle 9i database in one pc and oracle developer on another pc ... A: You need to make sure that both your database and developer PC are on a network. The next thing to ...
selective Transfer of Data	2/2/2005
Q: Which has some 450 tables with thousands of records. Now for another application, the data is ... A: One solution is to create views of only those columns that the application needs. The application ...
Oracle Certification.	2/1/2005
Q: Can you tell me how you got your oracle certification and how you got your first experience using ... A: To get an Oracle certification, you need to take the Oracle certification exam. You can find out ...
First Step	2/1/2005
Q: I am using MS Access Database So far. I want to learn Oracle. what should be my first step toward ... A: There are a number of books and web sites where you can go to get information about Oracle. There ...
Creating a Database	1/27/2005
Q: Sir, 1). I have been using Oracle 8i in my computer. I commonly enter into Oracle using the ... A: 1. Create Oracle 8i database: CREATING THE INSTANCE AND SERVICES 8.1 ...
oracle	1/25/2005
Q: What is the diffrence between 7i,8i,9i and 10g A: Oracle periodically puts out different releases of its database, just like Microsoft puts out ...
Query on position of column	1/18/2005
Q: When i give that syntax, Its displaying all the 3s in each rows but not the value of the column.plz ... A: Sorry the code I had previously provided is not correct. The correct code to look at would look like ...
Tables getting tiomedout	11/25/2004
Q: Mr.Peter, Is there any means by which we can list down all the tables that were waited for, since ... A: I would strongly recommend that you install the Oracle Enterprise Manager that comes with the RDBMS ...
*about SQLPlus command**	11/24/2004
Q: When spool SQL result to text file, there are too many space at the end of line (row) For example: ... A: You can use the LINESIZE or TRIMSPOOL (reccommended). As for sorting, you can try to include your ...
oracle	11/23/2004
Q: Peter, I have two question . 1.why data fetching is so fast after creating a index and want to know ... A: Data fetching is faster because an index tells you where to look. It's like looking something up in ...
Relation	11/19/2004
Q: I´m new using Oracle and I don´t find a way to make a relation among tables. is it posible?. How is ... A: You can use a product to forward engineering the table relationship, such as CA's ERWIN. You can ...
Oracle Connection	11/11/2004
Q: I am begining working with Oracle Server and I am using Ado with Delphi to connect to the server. ... A: When trying to connect to Oracle via ODBC, you need to provide the userid, password and database ...
Installing Oracle 8i on a PC that has Windows ME.	11/5/2004
Q: I am not sure if this is your area of expertise. If it is not, then please ignore this question. I ... A: The Oracle install documentation is available from Oracle at technet.oracle.com. You might want to ...
oracle related	11/3/2004
Q: if we make some changes in init.ora file , does it effect the speed of the oracle database? Answer ... A: If you change parameters in the init.ora files that affects memory allocation, number of cursors ...
oracle related	11/1/2004
Q: How to know the users currently connected to a instance in oracle databse on unix and winnt env. ... A: As a DBA, I usually turn on system auditing (reference: ...
connect as sysdba	10/21/2004
Q: May I ask you a Oracle connectivity question? I log on my home computer as administor user, log on ... A: The connect \as sysdba works from a command line within SVRMGRL (which is no longer supported). You ...
designing a convertor	10/19/2004
Q: I need your help in a program i am writting: I want to create a converter that will take any Oracle ... A: Unless you are hoping to convert Oracle Triggers (written in PL/SQL) to MS-SQL, you don't need a ...
install oracle 9i	10/19/2004
Q: how can i install oracle 9i in windows home edition. A: There is a setup.exe file. All you have to do is run setup.exe and follow the java wizard to install ...
designing a convertor	10/14/2004
Q: I need your help in a program i am writting: I want to create a converter that will take any Oracle ... A: In terms of MS-SQL SQL or Oracle SQL, both follow ANSI standards. Thus you can generate code for ...
Improving database/webserver efficiency	10/13/2004
Q: I was wondering if you could help me with an efficiency problem I'm trying to fix on my university ... A: Typically there is an application server between the web server and the database server. There are a ...
Difference between Access and Oracle	10/8/2004
Q: Peter: I'm quite versed in MS Access and have created many different types of applications ... A: You'll probably find MS-SQL Server is somewhat similar to MS-Access. SQL Server and Oracle are ...
How to recreate DBA roles if accidently drop?	10/4/2004
Q: if the DBA role being drop accidently droped. how to recreate back? problem: 1) since droped DBA ... A: Here's some information on recreting your DBA role in your database. Not knowing what version of ...
1nf and 3nf	9/27/2004
Q: Can you tell me which normal form(s) this soft box violates? CD #number title producer *year ... A: I would say that the above violates the 1st normal form. Why? The storename and address is repeated ...
MIS&ORACLE	9/27/2004
Q: . what are the oracle 9i applications in mis field? A: There are a variety of Oracle 9i application available, such as + Oracle 9i RDBMS (Enterprise ...
creation of new database in already running server	9/24/2004
Q: 1.7 for a location. Now the requirement is I need to create a new database in same server which is ... A: When you create a database instance, you are creating the phsyical files required by Oracle. These ...
Oracle 9i installation on windows XP profesional	9/23/2004
Q: I click on the setup.exe (install) program but nothing (I mean nothing) happens. If I tell XP to run ... A: You may want to make sure that you've got FULL admin privilideges on your XP server/workstation. ...
ORA-01536 problem (Urgent)	9/23/2004
Q: I am facing problem of ora-01536 problem. The error says that ORA-01536: space quota exceed for ... A: Here's some tips from Oracle about how to solve this problem: Errors ORA 1536 space quota exceeded ...
oracle connetivity	9/16/2004
Q: How can I connect to a Remote Oracle machine which is behind firewall. A: To get past the firewall, you will need to speak with the system administrator of the fire to allow ...
How to install/use Export Utility (ver 9.0.1.0.0) in Oracle Enterprise Manager Version 9.2.0.1.0 to export data	9/12/2004
Q: I am using Windows 2003.I tried to export data from Oracle Enterprise Manager Version 9.2.0.1.0 and ... A: You should use the old tools to EXPORT (so use 9.0.1.0.0) and use the new tools to IMPORT (so use ...
Oracle Installation	9/9/2004
Q: I would like to ask two questions: 1) How can I install oracle 8i into a PC with Ms ... A: The installation of Oracle 9i on Windows 2000 is as simple as follow the instructions that show up ...
oracle database backup	8/31/2004
Q: how can build up low cost oracle 9i data base backup? A: Oracle includes tools such as EXPORT (to backup your database) and IMPORT (to reload your databas ...
PSQL Question	8/31/2004
Q: I have a question on the Rowid and Rownum pseudo columns. I have a table which I needed to start in ... A: This query performs a full table scan. What that means is every row in the database is selected. ...
imprt and export of database	8/29/2004
Q: how can we import and export databse from other database environment such as ms access to oracle A: There are two ways. 1. The easist method is to convert your MS Access data into .CSV (delimited ...
Rollback, help please	8/23/2004
Q: i have did a sql to update specific datas. But i forget to write the where statement. There for all ... A: Unless you issued the ROLLBACK command right away in SQLPLUS (before committing), you cannot ...
Oracle 7.3.4 installation on Sco Unix 5.0.6	8/20/2004
Q: At the time of Oracle Installation on Sco Unix 5.0.6,server is IBM x235 xeon 1 gb ram 35 gb hdd , I ... A: The software that you installed is compiled but requires to be linked with the OS libraries before ...
Move Oracle database	8/18/2004
Q: Iwant to move a database from a Oracle 7.3 server to a Oracle 9 or 10. How do I do that? A: Assuming that you've installed and configured your Oralce 9i or 10g software, create an empty ...
How do I Update my system to a new software Release	8/14/2004
Q: Can you pls explain/describe to me (generally) the process of updating a system to a new release of ... A: The software supplier should provide the upgrade insturctions (either electornically or a physical ...
oracle	8/11/2004
Q: what is the difference in between oracle 8i & 9i? A: Oracle 8i is version 8.1.7 of Oracle. Oracle 9i is version 9.2.x of Oracle. There's not a lot of ...
OFA DISADVANTAGES	8/5/2004
Q: Is there any disadvantages in implementing OFA in an ORACLE DATABASE? A: By installing Oracle following the OFA, you are following a standard. Any new DBA coming to work in ...
How to get into the database industry	7/24/2004
Q: I am adept at accounting and it has gotten to the point now where I find this monotonous and kind of ... A: The easies way would be to take a course on the database (vendor) that you would like to work in. ...
update (select)	7/24/2004
Q: The reason why i put sub query is because there is duplicate data in the table and why i run query ... A: 1. Use the IN instead of the Exist (run this through your explain plan and test it out first in a ...
update (select)	7/22/2004
Q: I am using oracle 9i and the updating table has 100 m rows and i am trying to update one field but ... A: You might want to run an explain plan on your code. I am suspecting (a) that you may have several ...
Oracle 9.2.0.5 64-bit patch	7/7/2004
Q: Is there a PDF Document for "Oracle 9.2.0.5 64-bit patch" Also how can i tell if i am running 64 ... A: There are no PDF documentation for the Oracle 9.2.0.5 (64-bit) patch set. If you have access to ...
Multiple listener for multiple db's	7/7/2004
Q: I have two db's in one server and I created one listener for each db, the default (listener) and a ... A: This case from Oracle shows you how to configure the listener using the non-default settings: Doc ...
oracle error	7/6/2004
Q: ORA-00604: error occurred at recursive SQL level 1 ORA-00018: maximum number of sessions exceeded ... A: The problem is with the first error, where your code entered a recursive SQL. YOu may need to pare ...
recover oracle data	6/30/2004
Q: I've made export on 14/6, made full hard disk backup on tape on 27/6 (using windows 2000 backup ... A: If you do not have ARCHIVELOGMODE set to TRUE, then you may have some issues with the recovery of ...
Oracle / DBA	6/28/2004
Q: 1. Greetings! peter. I am Antony working a a Oracle PL/SQL programmer in Unix environment. i like ... A: There are a number of great books for DBAs. Most of them are from the Oracle Press ...
PL/SQL Doubts	6/24/2004
Q: What is the diff between stored procedures and functions? What is the diff between procedures and ... A: A Stored Procedure is a set of PL/SQL code that can behave as a function or procedure. A Function ...
Databases and lack of research	6/21/2004
Q: I am trying to refine a research topic on databases. I find litle research already done in this ... A: While most database papers tend to fall on the side of optimized searches (no surprise there) or ...
oracle date query	6/18/2004
Q: how i will retrive the record from table, of a date in where clause A: SELECT (column1\|column2\|...\|*) FROM (table_name) WHERE (columnx) (expr) (value) (expr) = 'LIKE', ...
choosing a careear	6/11/2004
Q: I have some problem choosing a career path. That is between Databse Administrator and ... A: With your background, whichever you choose, you will make use of your gained knowledge. Working as ...
Report Server	6/11/2004
Q: Can you tell me the pros and cons of maintaining a reporting server. We are a physician office with ... A: The report server enables off loads the server resources (CPU, MEMORY, DISK etc) from your database ...
Upgrade oracle 8i to release 3	6/8/2004
Q: Am trying to upgrade my oracle 8i version 8.1.3 to oracle 8i release 8.1.7 . is it any way possible ... A: There are no upgrade through a patch. Oracle recommends that you install Oracle 8.1.7, then export ...
ORA-01034,ORA-27101	6/5/2004
Q: for the quick reply.By mistake I replyed the email, sorry for that. Now the questions are 1. how to ... A: $ORACLE_HOME is where you installed the Oracle software. For exmaple, if I had installed Oracle in ...
ORA-01034,ORA-27101	6/3/2004
Q: I am using W-XP, and I installed Oracle 9i, even I tried to solve the problem by restarting the ... A: YOu have to make sure that your variable $ORACLE_HOME is set to the correct directory where Oracle ...
spool data from a stored procedure	5/29/2004
Q: i have a table which has various customers name.for each and every customer i have to generate a ... A: You can spool out to a flat file per person using the customer name, for example. Using PL/SQL you ...
Problems with connecting to 8i Oracle database from PHP	5/28/2004
Q: I experience problems when trying to connect to Oracle 8i database from PHP. Maybe it looks like ... A: There may be a problem with your Oracle service (i.e. the TNS Listener). It should not be failing as ...
querying objects	5/25/2004
Q: I have created in oracle, a small database. This database contains a table with three fields one ... A: 1. How can i select the surname of the person for the longest track? Assuming that PERSON_DETAIL ...
about antigrity, normlization,...	5/24/2004
Q: about antigrity, normlization, give me full discription of this A: Data Integrity refers to the fact that your data is consistent. For example, if you have a PERSON ...
Object Type Query	5/23/2004
Q: If i have a database for personal details, with attributes of. Title First Name ... A: I'm not sure what you mean by "OBJECT TYPE" SQL query. You can create a wide variety of SQL queries ...
Oracle DBA	5/23/2004
Q: Q1: What very basic (i'm a starter) things are to be done to create a database? can I get a sample ... A: If you are using Oracle 9i release 2(9.2.x), it comes with a database creation wizard that asks you ...
Switching To Oracle	5/22/2004
Q: I have a small business with about 25 PC stations and run MS Access in a 300Mb database. This does ... A: While switching to Oracle may help you, I might suggest you may want to take a look at SQL Server, ...
Oracle 8i Archive Logging Problems	5/19/2004
Q: I have an Oracle 8i database bundled with a proprietary application. I'm having problems with the ... A: Have you taken a look at your Trace (.TRC) files or alert logs for any other detailed error ...
SQL question	5/19/2004
Q: If I would use subquery for filtering one condition, eg select * from a where a.col1 in (select ... A: While you can use multiple sub queries to filter out multiple conditions, after the WHERE clause, ...
Thread 1 cannot allocate new log	5/17/2004
Q: I get this message('Thread 1 cannot allocate new log...') very often in the database alert. Each ... A: It looks like you may not have enough REDO log files. Generally there should be about 3, with ...
genral questions	5/5/2004
Q: Please could you give me frequently asked interview questions and answers for oracle database ... A: Depending on the company and organization, they may have different needs. You might want to check ...
Public synonym	5/5/2004
Q: 1)Can 2 public synonyms can be created on same objects? 2)How can a package be altered without ... A: 1. You can have two public synonyms on the same object - the name will have to be different. For ...
ORA-00955	4/27/2004
Q: How can I remove ORA-00955 ie name is already used by an existing object Thanking u Ahad A: Check the name of the object in existance against the system table DBA_OBJECTS (or USER_OBJECTS if ...
Database setup	4/21/2004
Q: I want to know the procedure of oracle database setup.Please send the reply as soon as possible. ... A: Using the Oracle installation and configuration wizard (Windows), it will generate a database for ...
System Password.	4/20/2004
Q: I had a co-worker that started the installation of Oracle9i. I now need to increase size of ... A: Edward, You can connect directly using SYSDBA from the command line. Rather than using SQL*Plus, on ...
session time	4/9/2004
Q: we'r running oracle 8.1.7 on win 2000 server. I need to set up session time of 20 mins for client ... A: If the client workstations are connected via SQL*Plus, then you can create a Profile and set the ...
how to write user-defined functions similar to SUM and MAX	4/7/2004
Q: There are functions in oracle which work on single elements like INSTR, TO_DATE etc. But there are ... A: Yes you can. Using PL/SQL, you can create user-defined functions and procedures. Make sure you don't ...
query taking time	4/7/2004
Q: i'm new to dba. i have one problem here. my query is running well but to minimize the time more i ... A: Your second SQL contained in "employercode count(1)". That tells oracle that you want to perform a ...
PeopleSoft table maintenance	3/31/2004
Q: On what tables (HR, Payroll, system) can maintenace be performed through PSTOOLS or Process ... A: The PSPRCSRQST table may be purged on a regular basis. However, before you do, you must hek to see ...
Access DB move into Oracle	3/22/2004
Q: I have a database which is currently a MS Access db.It is needed to be converted across to Oracle. I ... A: It may be easier to re-create the table structures in Oracle, and then using the ODBC connection, ...
help	3/22/2004
Q: what is oracle? A: Oracle is a software company famous for its Releational Database Management Systems (RDBMS). Founded ...
Running Number Column	3/16/2004
Q: May I know is that possible to create a table with a column is running number in auto in oracle? In ... A: It is possible in Oracle.You have to create a SEQUENCE. The Sequence can then be used as a field in ...
Why Oracle???	3/16/2004
Q: My question is not so technical, but relevant to concept because i always focusing to clear ... A: It's a matter of preference. Oracle and IBM's DB2 are the two largest enterprise-based databases. ...
script	3/12/2004
Q: produce a script that when run will list in a report format the names of all the users on the system ... A: You may wish to verify the code before running it in any of your critical database environment. ...
create new user	3/12/2004
Q: create an new member of staff who will have access to all the HR tables, this person will be a HR ... A: You can create a new user in Oracle by using the CREATE USER <username> IDENTIFIED BY <password>; ...
Versioning with the help of database	3/3/2004
Q: Hai, Can u tell me whether versioning of records can be maintained within the database. That is if ... A: Oracle does not really support the notion of versioning. What you can do, is write code that enables ...
solution for ORA_01034,ORA-27101	3/2/2004
Q: I installed Oracle10g on Redhat Enterprise 3 successfully,but when I connect database using sqlplus, ... A: Make sure that you've started the database. Unless you've configured it so that Oracle starts up on ...
Fresh Graduate	3/1/2004
Q: i am ankitha.I am graduating this may 2004.I want to enter in to the world of databases.I want to ... A: While having passed the certification process will help, there is no substitute for experience. ...
Access Tables of other user	3/1/2004
Q: Sir, I want to access the tables of SCOTT, using System/manager. But i couldn't do that. Please send ... A: One easy way of accessing user SCOTT's schema is to prefix the table name with the schema name. Thus ...
Database versioning	2/27/2004
Q: Hai, Can you help me in knowing about database versioning? I need to implement it in a project, to ... A: You may be looking for a product such as STAT from a company called Quest Software ...
Difference between PS records and Oracle tables	2/26/2004
Q: I want to know the difference between Peoplesoft records and Oracle tables. A: PeopleSoft records are meta-data objects stored within Oracle Tables. The Meta-data objects ...
procedures	2/24/2004
Q: What are procedures in SQL? A: Procdures in SQL, with an Oracle RDBMS, is usually written using PL/SQL. This gives the developer ...
Triggers & Tuxedo	2/17/2004
Q: Can I call a tuxedo server from a DB trigger? It yes how? Thanks, Surya A: You can't "call" tuxedo from a database trigger. Tuxedo is the middle tier that connects the client ...
Oracle & Linuk	2/15/2004
Q: I wonder if you have an idea of installing Oracle specail Oracle 9i on Linuk operating system.If so ... A: http://otn.oracle.com/tech/linux/index.html is the link for all the installation on LINUX. YOu'll ...
sir, Presently I am...	2/13/2004
Q: sir, Presently I am doing MCA. I am intrested to complite OCP but Presently I am just want to ... A: OCA is helpful if you plan on working with an Oracle RDBMS, may not help you with MS-SQL Server. It ...
problem creating 10Gb datafile on Win2k	2/10/2004
Q: Do you thin that creating some smaller datafiles (5 x 2Gb) on the same tablespace a good workaround? ... A: If you still have hardware problems - your work around suggestion may work in the short term, but ...
problem creating 10Gb datafile on Win2k	2/10/2004
Q: I'm having problems creating an oracle database on an Windows2000 RAID server. I have a pretty new ... A: You may want to check to see if there's a problem with either the disk controllers or with the ...
Creating extract files and developing reports	2/7/2004
Q: Peter, Hi, how are you, havent written in a long time. How is PeoleSoft by the way ? any news about ... A: Extractions are very easy - You can write SQL/PLSQL code to produce comma delimited format, or any ...
design database	2/6/2004
Q: Followup To Question - Hi every body I want to prepare a proposal for my company,my company has a ... A: You may be better off at looking for one of the following vendors as they come with the complete ...
oracle	1/31/2004
Q: I have just started learning Oracle.Could u plz tell me the basic difference ... A: Oracle 8 (version 8.0.x) Oracle 8i (version 8.1.x) Oracle 9i (version 9.x) Oracle 10g (version 10.x) ...
Database setup	1/17/2004
Q: Hei! I downloaded a database program called "DB tools for Oracle". When I try to set up the ... A: You need to use the Oracle 8.0.3 client install or upgrade your client to match that of your back ...
Problems with HP UX 11i for oracle 9i database	12/8/2003
Q: Pls let me know if there are any issues with HP UX 11i ,as we are planning to install Oracle 9i. Are ... A: There are no disadvantage to using HP UX 11i as your DB server platform operating system. You may ...
OFA	12/6/2003
Q: We have 4 instances of Oracle 9i running on a Sun / Solaris V880. We will be moving to a new ... A: Pre Oracle 7.3x, there was not real "set in stone" procedure for installing Oracle. This led ...
When should we use cursor?	12/5/2003
Q: When should we use cursor? Thanks, lzzzz A: Here's a bit of info straight from Oracle: QUICK GUIDE TO USING EXPLICIT CURSORS WITHIN SQL*FORMS ...

All Questions in This Category

Email this page