• Clustering

    I am using Oracle 10g on Windows I would like create clustes for faster reterival. How can I create it(syntax) can you help me with an example. How does it effect the performance

    Vishwanathavn5 pointsBadges:
  • Oracle 10g

    What's the best of breadth backup/recovery policy using RMAN 10g?

    Want2KnowOracle10 pointsBadges:
  • Oracle Streams

    What's the best checklist approach to implement schema data replication using Oracle Streams?

    Want2KnowOracle10 pointsBadges:
  • Calling an Oracle stored procedure in SQL Server

    I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

    SQL Server Ask the Experts2,585 pointsBadges:
  • stored procedure in delphi with oracle

    how to match the datatype of the field that is in database and the datatype of the variable that holds the value of the returned value from database using stored procedure.

    VPL95 pointsBadges:
  • ORA-12154 from Visual Studio

    I am getting ORA-12154 from Visual Studio 2005, when trying to connect to a database which I can connect to with SQL Plus.

    ChrisJay20 pointsBadges:
  • pl/sql procedure ,urgent!!!

    How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE...

    Ecsbc35 pointsBadges:
  • How to configure the database instance to respond slowly for any request?

    With default configuration settings at DB instance, the db server is responding quick. For my tests, i want the db server response to be slow. What configuration changes or anything else can be done so that the db instance will respond slowly (atleast take 1 minute time to execute). The request can...

    Saimadhu455 pointsBadges:
  • ORACLE REAL APPLICATION CLUSTER

    Hi to all In Oracle RAC what is menat by split brain syndrome ? What happens when it happens? I mean to say RAC database hangs or crashes ? thanks in advance

    SAPORACLE10 pointsBadges:
  • VC++: int keyword gives different results in Oracle 9i and 10g

    In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, any...

    SANS35 pointsBadges:
  • Use of multiple SET/WHERE clauses in the MERGE of 2 Oracle tables

    Currently am able to update 1 Oracle table from another using MERGE along with WHEN MATCHED THEN UPDATE logic. Under the UPDATE command I am using a SET/WHERE to update a specific column based on certain criteria. I want to add another SET/WHERE condition to this same update which will result in an...

    Ejpeth15 pointsBadges:
  • Oracle Forms 6i

    Hi... I am trying to connect to Oracle database using Forms6i.... But it is asking database name.. I am giving Global database name.. and LOGIN is not accepted... How can I solve this Problem....... Please give necessary suggestions to LOGIN and how can i find Database names in Oracle.....?

    34395 pointsBadges:
  • SAP ECC and DB Oracle version compatibility

    Is SAP ECC 6 compatible with SGDB Oracle 9?

    LucianoBrazil5 pointsBadges:
  • number to text

    Hi. There is a problem. As in Calculation Script the data stored in Oracle Essbase (Planning) as number (property data type = currency or nonCurrency or unspecified) to transfer to an element at which property data type = "text".

    Zhivchik10 pointsBadges:
  • Analyze Statistics on Oracle 10g

    How do i run analyse statistics on oracle 10g and schedule it for sunday at 04:00 am

    Bem405 pointsBadges:
  • PL/SQL: How to check that parameter is case-sensitive?

    Hi Experts how can i check the email id shud take only lower case in PL/SQL block i tried using vpos := REGEXP_LIKE(p_email_address,'[:lower:]','C'); as well vpos ;= REGEXP_LIKE(p_email_address,'[^[:lower:]]','C') But both says wrong type as error and p_email_address is a parameter of procedure and...

    Inprise610 pointsBadges:
  • How to implement Sleep logic not using sleep() need customized

    Hi Experts, I need to implement a sleep logic in a loop i need to check for SELECT/INSERT stm if it s locked by other user i will go to sleep mode then back to earlier savepoint position eg savepoint x; INSERT/SELECT i need to check for 10 times each time sleep is for 1 sec i applied counter i...

    Inprise610 pointsBadges:
  • How do I connect Developer 2000 on one computer to Oracle 9i personal addition on another XP machine

    how to connect d2k with 9i from other machine

    D2kconnect5 pointsBadges:
  • ALTER INDEX statement

    'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i...

    Shaksing5 pointsBadges:
  • PL/SQL: How to handle OUT Parameter during INSERT

    HI Experts, I have a OUT parameter in my procedure(whihc performs INSERT data into a table),how to handle this OUT parameter (primary key of table) -- Will Insert statement inside the PL/SQL block should include this parameter or we should use SELECT stm after Insert to add this attribute ,i am...

    Inprise610 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