Oracle 9i

update date value in oracle 9i

What is the code to update a date value in oracle 9i from vb.net

Oracle 9i Support

Hi, Can anybody please let me know that how long Oracle Corporation will support Oracle 9i database? Regards, Satyajit

Oracle Data types

I am just learning an ORACLE 9i Book and i was seen that in number Data type the Range is Lies between 1 to 38 in Decimal And -84 to 127 of Scale Range How it is possible because these Fraction degits are subtratect from whole degits ex:- var1 number (5,25);--------------(1)--it is possible? var2...

ORA-12535

I am using ORACLE 9i and making a standby server but when i am configuring NET CA ORA-12535 connect_timeout is coming

How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?

The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...

performance and tuning examination guides

What would you recommend as good study guides for performance and tuning 9i exam

Report taking long time before opening

Hi All We are running Oracla based ERP solution. 9i , D2K and JVM. Everyday after 6 PM all the reports are taking long time before opening I am using HP Proliant DL 380 G5 server with 2 GB RAM having 2 partitions . C mirrored 2 x 72 GB SAS HDD. D drive with 4 SAS 72 GB HDD RAID 5. Wetried...

upgrade from Oracle 9i to 10g

I am trying to upgrade a copy 9i Production database to 10g. Using DBUA tool. After selecting the DB for the past 20 hrs the process is still running with no progress. Alert log has the message on MMNL. What are the possible ways to upgrade a 9i DB to 10g. Have followed the oracle docwith no...

error in reunnig sql plus

when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

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 notarize how many...

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...

Installing oracle 9i

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

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.

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 me only...

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...

ORA-01591

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

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?

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?

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

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.