• Spooling Oracle Output via SQL DTS

    I am able to execute a stored procedure that resides in a database on an Oracle server via a DTS Package on a SQL Server. I would like to be able to spool the output to a .log file on a different server. Is this possible using DTS?

    Broskek5 pointsBadges:
  • Migrating from Sybase to Oracle 10g

    I know the a little more than the basics of DBing but not as much as an OCA or OCP. I need to know how to migrate data over from Sybase to Oracle 10g on a very large scale! Please help! I do not want to use a conversion software because there are many updates to the Oracle architechture already....

    BasicDBA5 pointsBadges:
  • NUMBER IN A LIST

    I am trying to do an update statement with a where clause that has a number table column in a string list. The string when displayed is ####, ####, ####; with no quote marks. This is in a when-button-pressed trigger in a form. It appears to work when the list only has 1 number in it, but returns...

    Papalpha5 pointsBadges:
  • Link Between MTL_MATERIAL_TRANSACTIONS and GL_INTERFACE in Release12

    I'm in an upgrade project from 11.5.7 to 12.0.4, the client has some major customizations using the existing link between MTL_MATERIAL_TRANSACTIONS and GL_INTERFACE like the reference21 in GL_INTERFACE = batch_id in MTL_MATERIAL_TRANSACTIONS and the reference23 in GL_INERFACE = TRANSACTION_ID in...

    Tanque5 pointsBadges:
  • Oracle EBS pritner

    Why printers connect to EBS often disabled? It looks like in a couple of day an Oracle user will report she can't print a check or a report. EBS=11.5.10, Linux, 9i.

    QAQA65 pointsBadges:
  • Oracle initialization error while running Java files

    I am facing no issues while compiling the java file. However while running the same, I am facing the following error. java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress. Any pointers for the same?

    JagdishK5 pointsBadges:
  • How can we startup our DB if any one redologs is corrupted totally 2 redologs

    how can we startup our DB if any one redologs is corrupted totally 2 redologs.the corrupted redo is in archivemode.1st redo is corrupt tat is in current use of archive mode

    Kkvsaathish5 pointsBadges:
  • I would like to know the procedure name

    How to know the procedure name of itself? for example, ------------------------------ create or replace procedure my_proc1 is begin dbms_output.put_line (' procedure name =>' || xxxxxx ) ; end; ----------------------------- i want to print 'my proc1' as procedure name through...

    Gregori15 pointsBadges:
  • ORA-12560: TNS:protocol adapter error

    I recently downloaded Oracle Designer from oracle website. When I use the default username and password, it give me the following error ORA-12560: TNS:protocol adapter error RME-00220: Failed to connect to Repository What should I do to solve this problem

    Develolper5 pointsBadges:
  • Urgent Help

    I have some doubts related to oracle database..... I am in ECC 5 implementation project (OS: Windows, DB: Oracle) My Question....... After Installing ECC 5 the default database size is around 50 GB, some 300 GB HDD is allotted to database , the client is saying to utilize the remaining 250 GB (300...

    Abtest0 pointsBadges:
  • do_while how can i use do while statement to delete certain rows based on the rowcount?

    how can i use do while statement to delete certain rows based on the rowcount??

    Mahe10 pointsBadges:
  • How can I get my Oracle load script to recognize decimal data with a trailing minus sign?

    I am writing an Oracle control file (load script) that will read a data file that contains multiple decimal fields that have trailing minus signs for negative numbers (there is a space for positive numbers - there is no plus sign). The records are fixed length, but the decimal numbers aren't a...

    BillWillis5 pointsBadges:
  • ERP Finance Consultant

    What is the job skills required for an ERP finance consultant

    PN1510 pointsBadges:
  • oracle – automated testing tools

    what automated tools can be used to test oracle forms application and oracle database backend

    Rm120 pointsBadges:
  • Resetting the database

    I received the following error:RMAN-20042: invalid tablespace creation change# when i dried reseting the database after doing a restore from an Rman backup. I tried to unregister the database than register it back in rman but the problem still exist and getting the following even when i try to...

    Oradbsm5 pointsBadges:
  • Why do IT projects fail?-3

    Hi, I'm a Computer Engineering at CSU Chico. I'm conducting a research paper on "Why IT Projects Fail". If someone could give me an example of a failed projects, "failed" meaning that it didn't get finished on time, or the final project did not meet the requierments. Also if you could give a quick...

    Dbrazeau10240 pointsBadges:
  • Nested Case statement in Oracle BI

    I am trying to create a nested case statement in Oracle BI (9.0.4) the statement works when I do it in Oracle SQL*Plus but will not let me keep the whole script in the Calculation.What do I need to doo to have this work in Oracle BI? The statement is as follows: select emp_name, (CASE WHEN...

    Nanapap5 pointsBadges:
  • Oracle driver

    Do you know if a 32 bit oracle driver works on 64 bit computer?

    Alediamo10 pointsBadges:
  • How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?

    The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...

    Alexanderph5 pointsBadges:
  • CRM on demand versus on premises solutions?

    Can somebody give a quick comparison of CRM on-demand solutions vs on-premise solutions regarding their integration capabilities with ERP and other legacy systems such as SAP, Oracle Apps?

    CRM Ask the Expert250 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