• How do I import 10.2 dmp file into 9.2 database

    I have an Oracle 10.2.0.2 dmp file from another site. I need to import the data into a 9.2.0.6 database on hp-ux 11.11. I cannot modify the xport file nor do I have a 10.2 database to import into, but I do have the 10.2 software. Is there any way to import the 10.2 dmp file into a 9.2 database?...

    Jcmdba555 pointsBadges:
  • table storing in oracle 10g

    where does create table get stored in oracle 10g

    Chandan 0025 pointsBadges:
  • data from oracle 10g to oracle 8i

    Im using oracle 10g and thru trigger i want to move data to oracle 8i for one particular table. when i try the trigger between two oracle 10g using database link its working fine. but from 10g to 8i giving error like ORA-04052: error occurred when looking up remote object

    Skarthik35 pointsBadges:
  • Should we use system tables or information schema views to retrieve metadata if both give the same results? Please explain why.

    Should we use System tables or Information schema views to retrieve Metadata, since both give the same results, and why?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 10g App Srvr vs. SOA

    If I have Oracle 10g App Srvr why would I really need SOA? Doesn't the App Srvr provide some of the same features SOA does?

    Whittly5 pointsBadges:
  • connecting to oracle database and push the data into the mail client Inbox

    we have java application,that inbox data will be stored in oracle database,i want get handle of oracle database and push the newly created document in to the mail client inbox of domino

    ITON10 pointsBadges:
  • how to come up with a backup and restore startegy for application developed on portal

    we have an application that has been developed on oracle APP server 8i portal(forms and reports),Win2003 server(OS) is the a way I can create a backup plan and restore plan for the system which steps should i follow o ensure the successfull backed-up system thank in advance

    Tokina5 pointsBadges:
  • Oracle 10g Clone Database

    Can anybody please give detail steps how to clone a database(created in Oracle 10g)by hot backup?

    Ora dba20 pointsBadges:
  • Creating Oracle databases on Windows Server 2003 machines

    I am trying to create a standby Oracle database. It is housed on a Windows Server 2003 machine. When I try to log into the server through Oracle Enterprise Manger, I get an invalid username and/or password error. I can log into the other Windows server which houses my primary database. Is there a...

    Windows Security ATE160 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:
  • 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?

    ITKE352,395 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:

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