• 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:
  • how to install oracle 8i on windows 2003 os

    how to install oracle 8i on windows 2003 os

    Lokeshug5 pointsBadges:
  • three sun servers having Three Oracle Application Server (9.0.3) running on each of them, Can we run three REPORT SERVER on all the three at a time?

    In a network we have three sun servers having Three Oracle Application Server (9.0.3) running on each of them, Can we run three REPORT SERVER on all the three at a time?

    ITKE353,235 pointsBadges:
  • Data Modeling Tools for relational database & dimensional data mart

    I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction...

    Mkaukonen5 pointsBadges:
  • Moving Oracle from one windows domain to another

    We are using Oracle 9 running on Windows 2003 R2. We moved the server into a different domain which is also within an AD environment. We then received the following error codes. RdConnection: Error # -2147467259 OpenConnection Description ORA-01034 ORACLE not available ORA-27101 When we...

    Xxxxxxxxxxxxxx5 pointsBadges:
  • Oracle Enterprise edition licensing

    PLease let me know .How Oracle licensing for enterprise edition works.Suppose we need Oracle EE license for following server.Do we need to buy two licenses or one? DL380G5 Windows 2003k server Having a single Dual Core processor Thank you

    DAC15 pointsBadges:
  • FND_USER_RESP_GROUPS & SIGNONAUDIT:LEVEL

    hi, i just started auditing oracle application and i don't get one thing in the table "FND_PROFILE_OPTION_VALUES": the value of "SIGNONAUDIT:LEVEL" is set on "D" in the table, when i read that there are only 4 options (none, user, responsibility, Form) and none of them is "D". do you know what the...

    Orit15 pointsBadges:
  • string functions in oracle

    i’m having a column called name, for example the data in the column name are name ------- john britto George bush But I need to display the first half(i.e upto the space)like, Name -------- John george

    Maha15 pointsBadges:
  • Need help reducing application downtime during updates

    I have an application which does monthly update of data in Database and also does select queries or minor updates. Monthly updates last for 24 hrs and application is down during the time. I am planning to use 2 schemas. The first one will be used for minor updates/selects. The other one will be...

    OracleATE190 pointsBadges:
  • Oracle performance under NT versus Linux environments

    When we run an update against a table of 40k rows on a NT environment, it completes in 10 sec. When the same update is executed on a Linux environment with the same # of records, it completes in 19 sec - nearly 100% drop in performance. The explain plans are the same for both environments (NT and...

    OracleATE190 pointsBadges:
  • Remote Operation Error

    I am trying to create a standby database using oracle's enterprise manager gird control. I have to specify the login credentials of the host machine that houses the production and the standby. For some reason it only accepts my login credentials once when it gets to the next step it gives a Remote...

    Niimajor25 pointsBadges:
  • Need help with CORBA object error in Oracle Management Server

    When I am in OMS, and try to shut the DB down, I receive a CORBA Object_not_found error. Does this mean that I have not installed the CORBA objects correctly?

    OracleATE190 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:
  • Pl/sql code for queries

    Hi , I have written 4 sql queries.2 select commands and 2 delete commands.now I want to write a pl/sql block for this.i.e after 2 select statements if the given condition satisfies then 1st delete command applicable. same way for 2nd delete command.I want to write cusor for those 2 select...

    User714085 pointsBadges:
  • Two Applications sharing the same database

    Hi , We have ORACLE RDBMS 9.2.0.6 ,and E-business suit 11.5.10.2 . Platform is Solaris 10. The applicatioin and the database are on the same server. We have users accessing this application from another Geographical location .Those users are facing performance problems due to the link . Question:...

    Said5 pointsBadges:
  • Oracle 10g Standby Database not opening readonly

    Hiii, I have created Oracle 10g Primary database where control file locations are as follows: *control_files='P:\oracle\product\10.1.0\oradata\tceng\control01.ctl','C:\oradata\tceng\control02.ct l','E:\oradata\tceng\control03.ctl' Then I have created standby database in standby server where the...

    Ora dba20 pointsBadges:
  • Not able to set preferred credentials on OEM console

    using Oracle 10gR2 on Windows 2003 server. I can't setup the preferred credentials on the Job scheduler screen on the console. I also have the email issue. I tried to use DBCA and clicked on database options and everything is greyed out and I cant seem to proceed. How can I configure to receive...

    Jh199310 pointsBadges:
  • Oracle Enterprise Edition versus Standard Edition

    We are looking at converting our "enterprise database" licenses to "standard edition". I need to know what to look out for. I have read the Oracle notes on the differences but you know how that goes. We are doing this as a cost cutting measure. Has anyone done this ? What should I be aware of...

    Rob E30 pointsBadges:
  • copy files

    Using SQLPLUS how do you copy files from one location to another

    Ga800715 pointsBadges:
  • Database Move

    What is the quickest way to move a database from one server to another...same platform and O/S version, same Oracle version (8i)?

    Mjevans0 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