• 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?

    Software engg10 pointsBadges:
  • 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

    Shaileshb10 pointsBadges:
  • 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.

    Kumar DLN5 pointsBadges:
  • 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?

    Sepere5 pointsBadges:
  • 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...

    Oracle Tech.20 pointsBadges:
  • 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...

    Shwetavyas15 pointsBadges:
  • 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

    Nishant835 pointsBadges:
  • Oracel 9i Undo

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

    fartman50 pointsBadges:
  • 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

    AUpadhyay5 pointsBadges:
  • 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...

    Rakh80 pointsBadges:
  • 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...

    Rakh80 pointsBadges:
  • 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 media....

    Girishdadlani5 pointsBadges:
  • 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.

    MLC5 pointsBadges:
  • 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.

    Gs5 pointsBadges:
  • 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!

    Idooracle5 pointsBadges:
  • 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.

    Pinki5 pointsBadges:
  • 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 be...

    IdongesitDaniel5 pointsBadges:
  • 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?

    123456300 pointsBadges:
  • 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....

    ITKE54,910 pointsBadges:
  • 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....

    Sukaina10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following