Oracle 9i

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.

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

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

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

Oracel 9i Undo

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

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

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

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

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 not giving any...

Oracle Installation on Portable Media

Hello Friends, I am working on Oracle 9i (Rel - 2). I am thinking of developing an application in which I can install Oracle on a portable media (Eg. Portable Hard Disk) and create a databse on the same. First of all, I want to know whether it is possible to install the Oracle on a portable...

Migration Plan for 9i Linux to 10g Solaris

Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g.

Oracle 9i to 10g conversion

have anybody done this type of conversion and what are the problem is can expect, we are using a lot of stored proc and triggers, is there any problem regarding the meta data?

what is the difference between Oracle 8i and Oracle 9i

what is the difference between Oracle 8i and Oracle 9i

Support of TRU-64 UNIX and Oracle9i on any newly introduced Servers.

I have RISC Based HP Alpha ES-45 Server with TRu-64 Unix and Oracle9i, I like to upgrade the server with latest high end server but I like to use the same OS and DB i.e. TRu-64 Unix and Oracle9. Is this possible in any newly introduced high end server.

Tablespace transporting back to older version of Oracle?

Would anyone know if its possible to successfully transport a tablespace from Oracle 10gR2 back to a version in 9i? Thanks!

Oracle 9i how to create dictionary managed tablespace

Hi, How can i create database with SYSTEM as dictionary-managed in Oracle 9i?. DBCA creates by default a database with locally managed system tablespace. How can i change it? Thanks in advance.

HOW TO INCLUDE LOG IN INFORMATION IN AN SQL SCRIPT

Please I have an SQL update statement which I want to put in an SQL script which users can run to update an oracle9i database running on a windows 2003 server.The statement is as follows: update jobs set JOBSTATE = 3 where APPID = 5 ; COMMIT; Exit I do not want users to be opening the script and...

Trouble logging on to Oracle 10g database remotely

This question was emailed to us I installed the oracle 10g (10.1.0) on a windows 2003 server where we already have Oracle 9i (9.2). I am able to login on the 10g DB from server but when I try to login remotely it gives the error ORA-12500: TNS:listener failed to start a dedicated server process. ...

What is the best way to transfer data from an Oracle 9i database to a Lotus 6.5 database?

What is the best way to transfer data from an Oracle 9i database to a Lotus 6.5 database?

media recovery

Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....