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
