You are here:
Oracle/Questions Answered by Expert Peter Choi
| Subject | Date Asked |
| POS and Accounting | 2/4/2012 |
| Q: I have an idea from creating a cloud based accounting software, Very similar to the intuit ... A: Good morning Mansoor, You're welcome. I can be reached here on Allexperts.com at anytime (we're all ... | |
| POS and Accounting | 1/27/2012 |
| Q: I have an idea from creating a cloud based accounting software, Very similar to the intuit ... A: Congratulations on your ideal. If you wish to protect your ideal, I would suggest that consult the ... | |
| EM | 1/23/2012 |
| Q: my problem is related to enterprise manager, i am getting Enterprise Manager is not able to connect ... A: When you are using the automatic services on Windows, they are started in a specific recommended ... | |
| EM | 1/10/2012 |
| Q: my problem is related to enterprise manager, i am getting Enterprise Manager is not able to connect ... A: [For the purposes of this disucssion, Oracle 11gR2 is the assumed database version. While many of ... | |
| which is best? | 12/15/2011 |
| Q: I AM PURSUING MA ENGG E.C.E 3RD YEAR. IN INDIA (TAMIL NADU ), I AM IN DILEMMA WHETHER TO GAIN ... A: Good day Manikandan, There are 2 questions that you will need to resolve: 1. What are your career ... | |
| oracle | 12/4/2011 |
| Q: i'm going to work for a company that capture data from the website to see how user look and ... A: You're looking to build a user experience insight based-application that will combine some customer ... | |
| views | 11/27/2011 |
| Q: i have a little problem with accessing views, please help I am user system, i create a user snow, ... A: The user SCOTT is the one who grants permission to access that it owns. So a first test, under the ... | |
| Oracle vsOpen source | 11/21/2011 |
| Q: I would like to know that there are many open source database available on net which are very good, ... A: Reference: http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems The ... | |
| Query regarding OCA certification | 9/11/2011 |
| Q: i would like to know complete details on OCA certification. could you please tell me which version ... A: Good morning Vinee, The official Oracle certification information can be found here: ... | |
| query oracle db from win cmd line and return ONLY results? | 7/16/2011 |
| Q: .. One of your answers finally showed me how to invoke a sql script directly from the Windows ... A: In your SQL script, add this: set term OFF [TERM]out (refernce: ... | |
| RDBMS DBA | 7/8/2011 |
| Q: What is a checkpoint?When does it occur?Why do we require checkpoint?Can we change this manually, ... A: (Source: http://www.orafaq.com/wiki/Checkpoint) A checkpoint occurs when the DBWR (database writer) ... | |
| automation tools | 6/27/2011 |
| Q: Not exactly about Oracle, but i can't find any viable info elsewhere... I'm in charge of a QC ... A: I did a quick search and here is a URL with a possible solution to what you're looking for. ... | |
| beginners step | 6/24/2011 |
| Q: given your profile, i decided to ask you. As a beginner, i am interested in the oracle Database. i ... A: If you are interested in developing applications that uses an (Oracle) database, (Introduction to ... | |
| Oracle | 5/30/2011 |
| Q: I have installed Oracle 11g 64 bit in Windows 2008 server for development. Developers are working ... A: Girija, TOAD communicates on an extra layer over Oracle's SQL*NET (SQL*PLus uses that). In your ... | |
| Rebuild a table | 4/26/2011 |
| Q: Script of REBUILD A TABLE, THROUGH TOAD I HAVE TO READ THIS --"This script will cause the catalog ... A: I am not sure about the context of the snippet of text that you posted. Generally when you use a ... | |
| regarding extending tablesapace | 4/14/2011 |
| Q: i dont know the path of *.dbf file and i wanna extend the size of tablespace.how can we find the ... A: Good morning, select tablespace_name, file_name from sys.dba_data_files order by ... | |
| ORA-01034 | 2/20/2011 |
| Q: I actually wanted a solution for a problem, that I was facing. When I was truing to login into the ... A: The problem that you're encountering can be one of two problems. If you are trying to log into the ... | |
| Recovery | 2/15/2011 |
| Q: I have a database which was created by taking cold back from production and going on applying ... A: In Oracle (9i to 11gR2) you can open the database to read-only queries. According to the ... | |
| Unix Certification | 2/1/2011 |
| Q: I would like to take a certification Unix.I will prefer a certification suitable for beginners. ... A: There's a lot of different certification courses that is specific to the OS (e.g. Oracle Solaris, ... | |
| project | 2/1/2011 |
| Q: I am a third year student in (CSE),recently i finished my OCA first module i.e. with 9i...and ... A: Congratulations on working on your Oracle Certified Associate (OCA) in 9i. You should consider ... | |
| Oracle database performance issue | 1/22/2011 |
| Q: For one of my databases users complaining, jobs are running very slow from last one week. it is ... A: Good morning Ravi, 1. Let's assume that the OS, RAM and hard disks (or SAN) is not at the heart of ... | |
| oracle dba- certification | 1/17/2011 |
| Q: I have 3 years IT experience on sql,pl/sql (9i). NOw I want to learn 11g directly as newbie ,want to ... A: It makes sense to move ahead with your Oracle 11g OCA certification. You need to be aware that there ... | |
| Oracle | 1/14/2011 |
| Q: career in Oracle....???? A: In the future, could you please provide some more details to your questions, in terms of what you ... | |
| dba | 1/13/2011 |
| Q: I am a year old graduate in engineering(IT), and i was wondering if you could tell me about how to ... A: Getting into the role of a DBA will take some time (education, experience) and patience. Look for a ... | |
| about insert with sequence | 12/18/2010 |
| Q: i m sanyog from delhi.sir, how can i connect to database in oracle 10g and can i attach a user ... A: If you define a table with a column type of NUMBER, for example CREATE TABLE STUDENT_TBL ( ... | |
| Linux Certification for oracle developers | 12/17/2010 |
| Q: I am working as a PL/SQL Developer from last 4 years. I want to do a linux/unix certification. ... A: Here's the link with the information for your certification: Linux: ... | |
| Oracle Vs Peoplesoft | 12/13/2010 |
| Q: What is diff between peoplesoft & Oracle? A: PeopleSoft was an independent software company until it was acquired by Oracle Corp. in 2004. ... | |
| oracle tuning | 12/8/2010 |
| Q: I use a large Oracle database. I am currently analyzing the tables and queries for performance ... A: Starting with Oracle 9i and higher, Oracle began the move toward using the Cost Base Optimizer (CBO) ... | |
| missing expression | 12/6/2010 |
| Q: INSERT INTO INTER_UPLOAD_DATE_DET(CATEGORY_C,PAY_PERIOD_CODE_C,FROM_DATE _DT,TO_DATE_DT) ... A: If I re-format your SQL, it would look like this: 1. INSERT INTO INTER_UPLOAD_DATE_DET( ... | |
| Connect in a stored procedure | 12/2/2010 |
| Q: Is it possible to connect to one user using a procedure.? I want to create a stored procedure which ... A: You can create a stored procedure to accept a username as input. You will, however, also need that ... | |
| Import Command! | 12/2/2010 |
| Q: I have tried importing a .dmp file called 5Nov10.dmp...The machine from where the file is exported ... A: There are several causes that you will need to verify. 1. On your Oracle 9i database server, when ... | |
| about attacment of a database | 11/15/2010 |
| Q: i m sanyog from delhi.sir, how can i connect to database in oracle 10g and can i attach a user ... A: The easiest way is to use Oracle's SQL*Plus to connect to Oracle. You will need to configure your ... | |
| Career | 11/13/2010 |
| Q: Sir, i am a new graduate in Computer science, and i just wanted to ask you that how should one ... A: This is an unfortunate "catch-22", you need experience to work as an Oracle DBA, but you need the ... | |
| Career | 11/9/2010 |
| Q: Sir, i am a new graduate in Computer science, and i just wanted to ask you that how should one ... A: It depends on the vendor that you want to become an "expert" in. For Oracle, you can take a look ... | |
| Why is Oracle's architecture is over complicated? | 11/8/2010 |
| Q: I don't want to initiate a religious war. I have been using MySQL since last two years in production ... A: It all depends on your requirements and financial constraint on which software product you would ... | |
| how to export | 11/3/2010 |
| Q: how to export user and tables, database, tablespace and also import user and table to other user ... A: If you could please provide the version of Oracle, along with the operating system that you are ... | |
| help on error... | 10/18/2010 |
| Q: i am trying to create database manually on oracle 9i on windows xp but wen i try to create spfile ... A: Unless you've manually modified your init.ora file (reference: ... | |
| Database Management Systems | 10/1/2010 |
| Q: What is an unsafe query? A: In relational database management systems (RDBMS), an unsafe query is a query in which the output is ... | |
| oracle sql queries | 9/9/2010 |
| Q: Sir, I am new to oracle pl/sql and I have more of a doubt about them than a problem.I want to ask ... A: PL/SQL has been available for a long time and is supported in Oracle 8i (and of course all newer ... | |
| Import DMP created by 8.1.7 into 11g | 8/22/2010 |
| Q: I have a question about exp/imp utilities. I have .DMP file created by exp 8.1.7 utility (in dmp ... A: When you are importing into Oracle 11g database, make sure you are using the 11g version of IMP ... | |
| oracle sql developer data modeler 2.0.0 and mysql | 8/19/2010 |
| Q: Sir, I have installed oracle oracle sql developer data modeler 2.0.0 on centos 5.0 . I want use this ... A: There's no support for Postgress SQL. As a follow up to using MySQL: For any MySQL release: JDBC ... | |
| oracle | 7/27/2010 |
| Q: Sir, I want to install both oracle 8 and developer 2000 in my computer (window xp). But if i install ... A: Your installation problem might be a simple one. In earlier versions of Oracle (7 and 8), the ... | |
| Taking Oracle Backup and Restore | 7/2/2010 |
| Q: I am new to Oracle.I need steps for taking Oracle DB backup and to restore on a new system. Both ... A: Reference: ... | |
| How to insert data from xml file to a table | 6/28/2010 |
| Q: Xml file that i want to insert into table is : Filename :trialxml <?xml version="1.0" ?> - ... A: Reference: http://www.dba-oracle.com/t_ora_29280_invalid_directory_path.htm This error is common ... | |
| Import limited rows from dmp file | 6/28/2010 |
| Q: I am using oracle 10g. Due to an error, I have to skip a particular row from import. I've already ... A: In 10gR2, there's a datapump import command that you can use (note datapump import != IMPORT). You ... | |
| Constrained (2 table join) Delete | 5/16/2010 |
| Q: Need to delete rows from tab_a where the tab_a.value is Not Equal to Tab_b.value. My way is not ... A: Instead of using the "<>" (not equal), use the "NOT IN". When you use the equality/inequality, the ... | |
| VBA - Oracle11gR2 client - Windows7 | 5/15/2010 |
| Q: Recently upgraded laptop and forced to run Window7. Installed Oracle11gR2 Client and, after adding a ... A: I suspect that your Oracle connectivity (TNSNAMES.ORA) isn't set up correctly. Oracle 11gR2 setup is ... | |
| New Database/Old datafiles | 5/13/2010 |
| Q: I have a project where someone send me "copies" of their Oracle Database. They just copied the ... A: The method that you are referring to is restoring from a "cold copy/backup". This method ONLY works ... | |
| Associating a Column Name with an index | 5/7/2010 |
| Q: I'm trying to determine, given an index name, how to determine the column name associated with the ... A: The view that you are looking for is called USER_IND_COLUMNS: INDEX_OWNER VARCHAR2(30) NOT NULL ... | |
| Oracle databases | 5/4/2010 |
| Q: I administer and maintain about 45 databases, all written in MS Access. Tow of them are getting ... A: To answer your technical question first: Q. Does Oracle lend itself to larger quantities of data ? ... | |
| About career | 4/11/2010 |
| Q: Sir, i am working in an electronics company and providing software support to their customers having ... A: You can always try with your existing company to see if they have any Oracle-related opportunities. ... | |
| Oracle Certification | 4/9/2010 |
| Q: I have learned Oracle. How do i get Oracle's DBA certificate? is there any possibilities of ... A: You have to obtain your Oracle Certified Associate (OCA) before you can take the final exam for the ... | |
| Need your help | 2/12/2010 |
| Q: I am MCA + OCP working with MNC company .I have around 3 years of experience as an oracle Dba ,I ... A: What version of Oracle Database is your OCP for? Most MNC help their staff by developing training ... | |
| Memory Parameters | 2/12/2010 |
| Q: Could u clearely explain the Memory parameters in 10g with simple examples, Currently iam using 10g ... A: The memory parameters within the Oracle RDBMS 10gR2 (the same logic applies to 9i, 11gR1 and R2 - ... | |
| Oracle Certification | 2/8/2010 |
| Q: I want to get Oracle Certification for me. I am from India, so how can I get Oracle Certificate, ... A: There are 4 steps that you should be aware of: 1. Identify Your Certification Path 2. Prepare For ... | |
| connection client to server | 2/8/2010 |
| Q: I am using Oracle10gexpress edition Which is free for download I have installed OracleXE and ... A: Reference: http://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25610/toc.htm The first ... | |
| spatial database by oracle | 2/5/2010 |
| Q: I am trying hard to learn spatial database in a quick time.I am searching some web tutorial for ... A: Tutorials --------- 1. ... | |
| Oracle 11g R2 training and Windows | 1/27/2010 |
| Q: I was wondering if you could tell me the difference between Oracle 11g R1 and 11g R2. I am looking ... A: When you do take the course, make sure you let the instructor know in advance that you'll be working ... | |
| Oracle 11g R1 vs. 11g R2 | 1/27/2010 |
| Q: I was wondering if you could tell me the difference between Oracle 11g R1 and 11g R2. I am looking ... A: Feature 11gR1 -------------- http://www.orafaq.com/wiki/Oracle_11gR1 ... | |
| Oracle 10G R2 Sys Login Problem | 1/27/2010 |
| Q: I am unable to login with SYS as sysdba in the EM. At the same time i could login SQL-plus without ... A: I just wanted to make sure, when you connect to your database using SQLPlus, you are using the ... | |
| spatial database by orcle | 1/25/2010 |
| Q: I am trying to make a desktop based software by which location based information can be stored by ... A: For the 11gR1 database, you can take a look at the Oracle Spatial Development Documentation : ... | |
| Discoverer Excel Export Format | 12/21/2009 |
| Q: Couldn't see an Expert section just on Discoverer, so I'm hoping an Oracle expert might know. When ... A: If I didn't include the link the first time, my apologies. Here it is: ... | |
| Insert data into oracle database | 12/18/2009 |
| Q: I'm very new to Oracle and Unix programming. Using shell script, i'm trying to insert data into my ... A: You should look up the manuals to become familiar with Oracle and Unix programming. Having said ... | |
| Valuable Advice | 12/13/2009 |
| Q: I have been working as developer dba since 2.7 years .In my present job I am getting very little ... A: How comfortable are you with your development skills? If you feel that you've reached the maximum ... | |
| hot and cold backup | 12/12/2009 |
| Q: what is the difference between archive log mode and non archive log mode And what is redo log files ... A: First you need to understand REDO logs. (reference: ... | |
| sql | 12/11/2009 |
| Q: how to select second bigger value in particular column? (like first bigger salary is rs.50000 and ... A: To select the second highest value in the salary table, the code would look like this: SELECT ... | |
| Consulting opportunities | 12/10/2009 |
| Q: Do you folks do any kind of on-site consulting? Thanks A: The company that I work for does provide on-site consulting; it should be noted that we are not ... | |
| RMAN restore backupset | 12/8/2009 |
| Q: I want to restore specific backupset. But after RESTORE and then RECOVER I see the same data which ... A: When you RESTORE and then attempt a RECOVER, you're doing the same thing. I think what you're ... | |
| Please Help | 12/5/2009 |
| Q: Good evening, i was wondering if you could help me with this please.. I am using Oracle 10g express ... A: If you create a table within the database, you can use the Oracle DataPump Export to produce a .DMP ... | |
| 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 ... | |
| SQL*plus 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: SQL*Plus is the command line version of the interactive SQL interface. iSQL*Plus 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 SQL*Plus? Is there a command to do this? ... A: 1. To reference objects owned or belonging to another schema is SQL*Plus, 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 SQL*PLUS? | 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 SQL*Plus? | 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 sql*plus 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 SQL*Plus, 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 SQL*Plus 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 ... | |
Oracle
Peter Choi
Top Expert on this page
Expertise
I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).
©2012 About.com, a part of The New York Times Company. All rights reserved.