Windows 2003 ENterprise edition with Oracle 9i . And there are 32GB RAM in the server
We use Windows 2003 ENterprise edition with Oracle 9i . And there are 32GB RAM in the server. The 32GB RAM is recognized by the server with Win2003 in ‘properties’. My question is a) whether the 32GB RAM is recognized with Oracle 9i ? If not ,how can I do ? b) How can I [...]

Answer Question   |  July 31, 2008  2:17 PM
Oracle 9i, RAM, Windows Server 2003

Windows 2003 Datacentre 32 bit with Oracle 9i 32 bit
We have procured an application for archiving of reports. Initially we were suggested to go for Windows 2003 ENterprise edition 32 bit (R2) with Oracle 9i 32 bit. After about 1 year of rolling out, we found that application became very slow. To enhance the room for memory, we went for memory upgrade from 4GB [...]

Answer Question   |  July 22, 2008  1:41 AM
Oracle 9i, Windows Server 2003

Installing oracle 9i
is it possible to install qracle 9i on a windows 2003 environment

Answer Question   |  July 21, 2008  10:02 AM
Oracle 9i, Oracle installation, Windows Server 2003

ORA-27101 error when migrating Oracle 9i to AD domain
We are running Oracle 9 on a Windows 2003 box. We moved the server from a Windows domain to an AD domain. We then get an error messages looking like this: ORACLE not available ORA-27101 When we back out of the changes, everything works fine again. Any ideas? Thank you.

Answer Question   |  August 5, 2008  5:22 PM
Active Directory, ORA-27101, Oracle 9i, Oracle migration, Windows Server 2003

How to switch to IMP/EXP Utility of multiple installs of Oracle on same client?
I have installed Oracle 9i and Oracle 10g on one Windows XP machine and two Oracle homes were successfully created – as i can switch between them using the Home Selector. I then tried the same install on another box with Windows XP, but when I use the Home Selector I get a message telling [...]

Answer Question   |  July 15, 2008  5:17 PM
Oracle 10g, Oracle 9i, Oracle import/export

how can i resolve oracle error 00103
I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE BUSINESS_UNIT= BUSINESS_UNIT1; C C1%ROWTYPE; BEGIN FOR C IN C1 LOOP BEGIN INSERT INTO SYSADM.voucher_tmp values (C.BUSINESS_UNIT,C.VOUCHER_ID,C.INVOICE_ID); COMMIT; END [...]

Answer Question   |  September 22, 2008  4:36 PM
ORA-00103, Oracle 9i, Oracle error messages, PL/SQL

ORA-01591
lock held by in-doubt distributed transaction iam running oracle9i relase 6.I get the following error

Answer Question   |  July 11, 2008  9:34 AM
Lock Held By In-doubt Distributed Transaction, ORA-01591, Oracle 9i, Oracle error messages

can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?
can u tell me the syantax by which i can select no of rows in a dummy table in oracle 9i?

Answer Question   |  July 8, 2008  1:52 PM
Oracle 9i

Migrating data from Oracle 9i Database to SQL Server 2005
I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

Answer Question   |  July 30, 2008  3:29 PM
Data migration, Oracle 9i, SQL Server 2005, SSIS, SSMA

how to access fields of table along with their datatypes in oracle
Dear Oracle gurus I am using oracle 9I. i want to access fields of table along with their datatypes at runtime.. to see structure of table ‘desc’ command i used.. but at runtime how i can know datatypes or fields of a table. Thanks in advance Shailesh

Answer Question   |  July 1, 2008  10:09 AM
Developer 2000, Oracle 9i, Oracle Developer 2000, Oracle development

Compile Forms 6i 32 Bit in Oracle 9i 64 bit
When I try to compile .fmb file using forms builder (Forms [32 Bit] Version 6.0.8.11.3 (Production) ) against Oracle9i Enterprise Edition Release 9.2.0.7.0 – 64bit Production, while compilation is going on, window is getting closed, no error is either getting displayed or error file is generated.

Answer Question   |  June 27, 2008  2:28 AM
Oracle 9i, Oracle 9i Enterprise Edition 9.2.0.7.0, Oracle Forms, Oracle Forms 6i

Export parameters TABLESPACES, TRANSPORT_TABLESPACE in Oracle 9i
Do we need to set the parameters TABLESPACES, TRANSPORT_TABLESPACE to export table spaces and transportable table spaces meta data even when the parameter FULL = y. Please suggest me what to do for this case.

Answer Question   |  August 23, 2008  5:53 AM
Oracle 9i, Oracle 9i export parameters, Oracle import/export, TABLESPACES, TRANSPORT_TABLESPACE

Conversion or Migration from Oracle 9i to Oracle 10g database on Windows 2003 64 bit
Hi, Currently, I am using Oracle 9i (version 9.0.1.1) database now as per my business requirement, I need to upgrade it to Oracle 10g database. It has several database procedures and triggers stored with it. Operating System : Windows 2003 Server, 64 Bit I am looking for some help on this, what are the problems [...]

Answer Question   |  June 4, 2008  11:58 AM
Oracle 10g, Oracle 9i, Oracle migration

Oracle -fetched column value truncated error
Hi I am using ASP.net using C# in my application which connects to Oracle 9i DB with a UTF8 character set. On of my columns in a table has datatype Nvarchar2(4000), when I try to fetch data through a Stored proecedure using execute Dataset command in C# it throws error “ORA 01406 -fetched column value [...]

Answer Question   |  May 23, 2008  7:31 AM
ASP.NET, C#, ORA-01406, Oracle, Oracle 9i, Oracle error messages

forms 9i help
hey , i want to know is there any way to change the java window applet size by any built in and change the oracle picture as well as toolbar.so plzzzz let me know its kind of urgent… thanks in advance nishant

Answer Question   |  May 5, 2008  5:12 PM
Java applets, Oracle 9i, Oracle Forms

Oracel 9i Undo
How can i determine if the undo is setup properly and how can i determine if it is online

Answer Question   |  May 4, 2008  4:20 AM
Oracle 9i

Calling a report from form
Hello all We recently have migrated from oracle 6i to 9i DS. We have some forms which are calling a report. I have used the run_report_object() instead of run_product() in 9i. Previously the forms were displaying the reports properly. But I have re-installed the windows and oracle due to some problem after which my reports [...]

Answer Question   |  April 24, 2008  4:22 AM
Oracle 9i, Oracle error messages, Oracle Reports

BLOB Data move from Oracle 9i to Oracle 10g
I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

Answer Question   |  April 24, 2008  3:58 PM
BLOB, Database, ORA-00942, Oracle 10g, Oracle 9i

Calling a report from a form
Hello experts I hope you all are fine & enjoying good health. I am facing a problem after migration from oracle 6i to oracle 9i, I wonder if someone can help me in calling a report from a form. I have used RUN_REPORT_OBJECT instead of RUN_PRODUCT but I am getting error FRM-41214 unable to run [...]

Answer Question   |  March 5, 2009  4:07 AM
FRM-41213, FRM-41214, Oracle 9i, Oracle error messages, Oracle migration

Report not running in web layout for Oracle 9i
hello we recently have migrated from oracle 6i to oracle 9i. my problem is that when i compile and run a report (that was built in reports 6i) the web layout in reports 9i is not displaying. the paper layout version is working fine but i need a web layout which is not working. its [...]

Answer Question   |  April 7, 2008  6:21 AM
Oracle 6i, Oracle 9i, Oracle Reports