Why do I not see Oracle database block gets and consistent gets
hi, i have two test scenarios where i’m trying to understand to actual concept of db block gets and consistent gets. SQL> set autotrace on SQL>select * from scott.emp; i get 14 rows then Execution Plan ———————————————————-    0      SELECT STATEMENT Optimizer=ALL_ROWS (Cost=3 Card=14 Bytes=51           8)    1    0   TABLE ACCESS (FULL) OF ‘EMP’ [...]

Answer Question   |  March 31, 2012  4:48 PM
Oracle 10g, Oracle 10g administration, Oracle 10g Database, Oracle 10g performance

Unable to establish connection to Oracle database 10g XE
Hi All, I have successfully Installed Oracle 10 g XE. When I Click ‘Go to Database Homepage’ to access the database the webpage shows an Error message “unable to establish a connection.”  What could be the possible reasons for this error? and How can I fix it? Appreciate your HELP ! Thanks in Advance, Chandan 

Answer Question   |  June 13, 2011  4:09 PM
Oracle 10g Database, Oracle Database, Oracle Database 10g, Oracle XE, Windows XP

Oracle 10g to SQL Server 2008
Our DB is Oracle 10g. Our Clients Test DB is SQL Server. Now sometimes, we do incremental loads, full loads or historic load. The present system what we have is we send the insert statements and the DDL to them and they create and load. I did not write it. It takes 40 hours. Under [...]

Answer Question   |  May 2, 2011  9:01 PM
Oracle 10g, Oracle 10g Database, SQL Server, SQL Server 2008, Unix

Recovering Oracle 10g Express data
Hello My oracle 10g express eddition is curroped in my system and i install new oracle 10g express edition then how to recover my old data from a folder oraclexe.Plz Hepl me i am in big poblem

Answer Question   |  February 23, 2011  2:08 PM
Data Recovery, Oracle 10g, Oracle 10g administration, Oracle 10g Database, Oracle 10g Express

Rename the Oracle 10g database user
Hi. I want to rename the database user(username)without deleting the user and again creating in ORACLE 10g database??? plz, help me

Answer Question   |  August 12, 2011  2:23 PM
Oracle 10g, Oracle 10g Database, Oracle Database

Replicating Oracle 10g database in Oracle 9i
I have an oracle 10g database and would like to create a replica of it in oracle 9i. Could you please explaim if this is possible. I’m sure there would be backward compatibility issues to contend with.   Regards,

Answer Question   |  January 6, 2011  6:00 AM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle Database, Oracle Database Versions

How can I connect my application server to my Oracle 10g database?
how can i connnect my application server to oracle database 10g. the applciation server have a form that can be accessable through browser(client).pls tell be the configeration that i have to do.

Answer Question   |  December 15, 2010  10:36 AM
Application Server, Oracle 10g, Oracle 10g administration, Oracle 10g Database

Rename username in Oracle 10g database
Rename username in oracle 10g database without droping it

Answer Question   |  November 24, 2010  12:31 PM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle administration, Oracle User Profiles

Oracle 10g database creation errors in windows 7
hello friends this is avishek behera.. recently i installed oracle 10g database software only in windows 7. after that i tried to create a database.. but i got an error like oermission denied.. i have installed in d drive which is not my system drive and also installed with administrator previlage “run as administrator”. still [...]

Answer Question   |  November 8, 2010  7:12 AM
Database issues, Oracle 10g, Oracle 10g Database, Oracle Database, Windows 7

Windows go blank while running reports in 10g
I have oracle 10g as the database and front-end. When I run my application in 2 different windows and run a report in one of the windows, the other goes blank until the report is finished running. Any ideas why? Appreciate your help.

Answer Question   |  September 24, 2010  2:07 PM
Database frontend, Oracle, Oracle 10g, Oracle 10g Database, Oracle Database, Oracle Reports 10g

Oracle 10g database issue
how to increase the space of mount point dev/sdc1 scsi

Answer Question   |  October 25, 2010  8:37 AM
iSCSI and Oracle, Mount points, Oracle 10g, Oracle 10g administration, Oracle 10g Database, SCSI

hiding the username/password@db from the url while running 10g report
iam running reports from developer 10 g release 1 using web.show_document command ,my application serves multi users that means each user has his own database user and password , so adding the key method in the cgicmd.dat will not help like : userlogin : destype = cache desformat=HTMLCSS userid=scott/tiger@orcl %  So, can I run report without showing the userid in [...]

Answer Question   |  December 24, 2010  6:12 AM
Oracle 10g, Oracle 10g Database, Oracle Reports, Oracle Reports 10g

Large number rounding in Oracle 10g
Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some reason the number rounds up. For example if the [...]

Answer Question   |  July 19, 2010  8:27 PM
Oracle 10g administration, Oracle 10g Database, Oracle database administration, SQL Plus, TOAD

Need to save dates in Oracle Forms 10g without modifying data values
I am trying to save date and time as entered by the users example: In the insert and update triggers of my block my statement is: :MAIN_BLOCK.USER_DATE := TO_DATE(TO_CHAR(:MAIN_BLOCK.USER_DATE,’DD-MON-YYYY’)||’ ‘||:MAIN_BLOCK.HOUR||’:'||:MAIN_BLOCK.MIN||’:00 ‘||:MAIN_BLOCK.MERIDIAN,’DD-MON-YYYY HH:MI:SS AM’).  I am trying to save :MAIN_BLOCK.USER_DATE as “25-MAY-2010 11:00:00 AM” as the user entered in the form textboxes and is saving “25-MAY-2010 [...]

Answer Question   |  July 15, 2010  3:12 PM
Database management, Oracle 10g Database, Oracle 11g Database, Oracle Forms 10g

Buffer error on Crystal Reports 11.5 Parameter
When I refresh the data on this report I’m building the report fails to get values. It list the cause of the error as “Buffer too small for string or missing null byte. UNKNOWN.RPT]” Isays that the errors source=prompt.dll and the error code is 0x8004380D. The field in the prompt is a date/time field. In [...]

Answer Question   |  June 29, 2010  4:23 PM
Crystal Report XI, Crystal Reports 11.5, Oracle 10g Database, Oracle 11g migration

Select/Insert Statements causing out of memory error run under VB Script
I’m using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error.  As far [...]

Answer Question   |  January 27, 2011  8:43 AM
INSERT statement, Oracle 10g, Oracle 10g Database, SELECT statement, Windows Server 2003, Windows Server 2003 32-bit

Oracle 10g Database transfer
How can I transfer Oracle 10g Database under Windows to Oracle 10g under Linux? What precautions need to be taken?

Answer Question   |  August 12, 2011  3:20 PM
Oracle 10g, Oracle 10g Database, Windows Server

Analyze Oracle 10g
I’ve been a little out of the loop on Oracle since Oracle 7. When we upgraded to 10g, we were led to believe that oracle would automatically handle regular analyzing of the database. This past week we discovered that not all tables are being analyzed regularly. What are we missing?  Is there a parameter that needs to [...]

Answer Question   |  September 11, 2009  8:18 PM
Oracle 10g, Oracle 10g Database

Oracle 10G Issues
The problem I’m having is that MDAC 2.5 is no supported by 10G…I installed MDAC 2.8…When I went into the ODBC DSN drivers (Admin ODBC console) MS for Oracle was still there…the new driver for 2.8 was not visable. We used Oracle 10G client to connect…but it could not return a “ADO Recordset” so we [...]

Answer Question   |  August 11, 2009  5:52 PM
MDAC 2.5, Oracle 10g, Oracle 10g Database, Oracle Database

Connect to Oracle 10g with VB 6
Hving a problem with an existing VB 6 app connecting to 10g pulling back a recordset…it is clustered so that is an extra level of complexity…it was written using MDAC 2.5

Answer Question   |  August 11, 2009  5:27 PM
Oracle 10g, Oracle 10g Database, Oracle Database, VB 6