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

    SQL Server Ask the Experts2,585 pointsBadges:
  • convert Oracle query into xml file

    Is there any software to convertautomatically oracle table(query)into xml file like JSP in java.

    dnlkc5 pointsBadges:
  • How to access and use subform data/calculations

    Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...

    OBI Girl85 pointsBadges:
  • what is the best STORAGE solution for ORACLE db – SAN or NAS ?

    one of my project is very critical for the client . the application will run in 10 different sites . the infrastructure of each site will be : 4 linux servers (2 for ORACLE DB , 2 for websphere) + 1 linux/win server for backup software + DB oracle (~100GB) + storage. i have a very good experience...

    Mhonmhon0 pointsBadges:
  • Report Query

    Can I run a query in peoplesoft if I don't have access to query manager?

    Aolpoint5 pointsBadges:
  • Confused!!!!!!!!!!!!!!!!!!!

    Respected Sir/Madam, I am H Singh from Punjab India. I have done BCA in 1997-2000 and then MIT (Hons.) from Guru Nanak Dev University , Amritsar in 2000-2003.Then I have started my own business of computers. Now I want to switch to IT sector again as I too want to work with big gaints in this...

    Honey0 pointsBadges:
  • Oracle 10g Enterprise Manager Console – Sort Schema list

    I have recently upgraded to Oracle 10g Enterprise Manager Console (without Web connection), and have found that my schema list in the enterprise manager console is no longer in alphabetical order. I cannot find any information on how to fix this. In the previous Oracle version, the list was...

    Sloan5 pointsBadges:
  • Windows 2003 Datacentre 32 bit with Oracle 9i 32 bit

    We have procured an application for archiving of reports. Initially we were suggested to go for Windows 2003 ENterprise edition 32 bit (R2) with Oracle 9i 32 bit. After about 1 year of rolling out, we found that application became very slow. To enhance the room for memory, we went for memory...

    KGA5 pointsBadges:
  • Installing oracle 9i

    is it possible to install qracle 9i on a windows 2003 environment

    Rr2424185 pointsBadges:
  • Syntex for storing combobox & redio button in oracle using VB.NET

    How can i save combo box value & redio button in database using VB.NET form. For example as text value we write TEXTBOX1.TEXT????

    Deep 06075 pointsBadges:
  • Oracle coding error ORA-06550

    Hi, I get the following error on compiling my code - *********************************************************** ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol "ELSE" when expecting one of the following: begin case declare end exit for goto if loop mod null pragma raise return...

    ITKE351,875 pointsBadges:
  • Oracle Data Guard Replication between SAN and NAS

    Is it possible to replicate data (using Oracle Data Guard) between Oracle Database which is on SAN at primary site and on NAS at the DR site?

    KetanVora0 pointsBadges:
  • Oracle App Server webcache and mod_gzip

    Hi all, I am struggling since last few days to work these both together.Problem is: The web cache is compressing the content but i don't want it to compress, i want the compression from server through mod_gzip. Even if i m disabling compression in webcache settings, its not working. In mod_gzip log...

    Mthakur5 pointsBadges:
  • OpenLDAP and Oracle Database

    Hi, This is a question related to Oracle and OpenLdap. Can anybody please tell me how to setup the Oracle [10g] to use the installed OpenLdap server. I know we need to use netca and use the internet directory services; But how to set Open Ldap is the question here. Your help is greatly appreciated!...

    Parthahs5 pointsBadges:
  • How to create a trigger for updating a table for a quantity decrease?

    How do you create a trigger to take care of the process of updating a table, to reflect a change downward in the quantity column? 1. The trigger needs to be an AFTER INSERT trigger on the above table so the trigger will not fire in case of exceptions. 2. The trigger must fire for each row that is...

    OracleATE190 pointsBadges:
  • How to deploy database application built on VB 6 and Oracle?

    I am developing an application with VB 6 as front end and Oracle 8i as back end. I need to run my application in other systems also, so I need to export the table structures of my application to other systems. How can I do this? Thank you.

    OracleATE190 pointsBadges:
  • ORA-12801 and ORA-01008 when running Oracle Reports

    When I run the report from report builder I get following error ORA-12801: error signaled in parallel query server P001, instance db12:testdb(2) ORA-01008: Not all variables bound Any idea what could be the problem? Database is Oracle 10g.

    OracleATE190 pointsBadges:
  • Getting the number of a row from a flat file source in SQL

    How might I get the number of a row from a flat file source with a script component in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to switch to IMP/EXP Utility of multiple installs of Oracle on same client?

    I have installed Oracle 9i and Oracle 10g on one Windows XP machine and two Oracle homes were successfully created - as i can switch between them using the Home Selector. I then tried the same install on another box with Windows XP, but when I use the Home Selector I get a message telling me only...

    OracleATE190 pointsBadges:
  • Best backup procedure for Oracle E-Business Suite?

    We are using Oracle E-Business Suite R.12. Database and applications are running in two different nodes under hp-ux in NoArchivelog mode. In this scenario, a backup procedure is to be created. Can you suggest to me the steps involved in taking backup of both database and applications node, please?

    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