Recent IT Questions

1 - 20 of 74
<<PREVIOUS 1|2|3|4 NEXT>>

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?

View Answer   |  Jul 8 2008   1:52 PM GMT   |  asked by Software engg
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?

View Answer   |  Jul 1 2008   3:29 PM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2005, Oracle 9i, Data migration


how to access fields of table along with their datatypes in oracle

Dear Oracle gurusI 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 advanceShailesh

View Answer   |  Jul 1 2008   10:09 AM GMT   |  asked by Shaileshb
Oracle Developer 2000, Oracle 9i, 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   |  Jun 27 2008   2:28 AM GMT   |  asked by Kumar DLN
Oracle Forms 6i, Oracle Forms, Oracle 9i Enterprise Edition 9.2.0.7.0


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.

View Answer   |  Jun 24 2008   5:53 AM GMT   |  asked by Vini Chandamama
Oracle 9i export parameters, Oracle Import/Export, Oracle 9i


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 BitI am looking for some help on this, what are the...

Answer Question   |  Jun 4 2008   11:58 AM GMT   |  asked by Oracle Tech.
Oracle migration, Oracle 9i, Oracle 10g


Oracle -fetched column value truncated error

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

View Answer   |  May 22 2008   7:31 AM GMT   |  asked by Shwetavyas
Oracle, ORA-01406, C#


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.soplzzzz let me know its kind of urgent...thanks in advancenishant

Answer Question   |  May 4 2008   5:12 PM GMT   |  asked by Nishant83
Oracle Forms, Oracle 9i, Java applets


Oracel 9i Undo

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

View Answer   |  May 2 2008   4:20 AM GMT   |  asked by Fartman
Oracle 9i


Calling a report from form

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

Answer Question   |  Apr 24 2008   4:22 AM GMT   |  asked by Rakh
Oracle 9i, Oracle Reports, Oracle error messages


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   |  Apr 23 2008   3:58 PM GMT   |  asked by AUpadhyay
Database, 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   |  Apr 15 2008   4:07 AM GMT   |  asked by Rakh
Oracle 9i, Oracle migration, Oracle error messages


Report not running in web layout for Oracle 9i

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

Answer Question   |  Apr 7 2008   6:21 AM GMT   |  asked by Rakh
Oracle Reports, Oracle 9i, Oracle 6i


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

Answer Question   |  Mar 25 2008   9:47 AM GMT   |  asked by Girishdadlani
Oracle development, Database, Oracle 9i


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.

Answer Question   |  Mar 6 2008   10:06 PM GMT   |  asked by MLC
Solaris, Oracle 10g, Oracle 9i


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?

Answer Question   |  Feb 27 2008   8:16 AM GMT   |  asked by Sepere
Oracle developers, Oracle 9i, Oracle 10g


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

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

View Answer   |  Feb 21 2008   11:24 AM GMT   |  asked by Venkatakrishna
Oracle, Oracle 8i, 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.

Answer Question   |  Jan 28 2008   11:07 AM GMT   |  asked by Gs
Servers, TRU-64 Unix, Oracle 9i


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!

View Answer   |  Jan 24 2008   11:06 PM GMT   |  asked by Idooracle
Oracle administration, Oracle 9i


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.

View Answer   |  Jan 22 2008   2:06 PM GMT   |  asked by Pinki
Database, DBCA, Oracle 9i


1 - 20 of 74
<<PREVIOUS 1|2|3|4 NEXT>>