Oracle

send message to the java application
Oracle 10g with Windows platform. I have a java application that periodically pings the database table to see if it contains the specific row so th

How to give the privillege for triggers?
Hi, How to give the privillage for triggers to particular user? Please let me know, if it is possible. Thanks

ORA-00932: inconsistent datatypes: expected - got CLOB
SO : windows xp database : XE there is a table (transito) with two fields of clob datatype. in a plsql code, there is an update statement in th

utl_file open error
i have file in the unix path Path /popdev01/pop/popdevb/tfi/ File name: qua01 this path is hard coded in the table PQ10. i will be

comparing tables across databases sql refinement ideas required
Hi all Via pl/sql I need to ensure that data between tables in different databases match (i.e. standby db and development db) I have made the follo

Oracle11g Patch issue
Hi all,I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AIX/oracle/Disk1/stage/Components/oracle.owb.rsf/11.1.0.7.0/

Multithreading in Oracle (Java, SQLJ, Pro*C,??) on 10g
I am investigating how to run a Java stored procedure in multithread mode.I know that if I change the program to be multithreaded, the Database runs i

C++ API to Oracle dB
I need to perform a select command to the Oracle dB to obtain information from a table.What libraries can I link into my project to make this work?I r

ORA-01655: unable to extend cluster SYS.C_FILE#_BLOCK# by 128
Hi all,Oracle 10g. Linux.I'm facing the below error while trying to import a dumpfileIMP-00003: ORACLE error 604 encounteredORA-00604: error occurred

Not connecting to DB using ruby, error:env.c:257:in oci8lib.so: ORA-12154:
Hi All,I am trying to connect to the database server from the client server using ruby and facing the following issue-$ruby -r oci8 -e "OCI8.new('temp

Export hangs
Hi all, please helpI have a Oracle 10.2.0.3.0 database. When I want to query the dba_segments or dba_directories views Oracle just hangs, and when I

media recovery
Hi, i startup the database i got the errorSQL> startupORACLE instance started.Total System Global Area 146800640 bytesFixed Size

DBCA Templates
Hi all,I'm working on creating a template for DBCA, but can't find any documentation on the parameters that one can use within the template. Obviousl

Supress some serveroutput but not all
Hi, I have a script I'm working on that uses plsql to create and RMAN script, this uses dbms_output and also accepts user input as variables. Th

How to form a xml form table with a single sql statement..?
Hi everyone, I don't know if this is going to be a duplicate thread but i couldn't find one exactly like this. Let me explain the problem

AUTONUMBER PROBLEM
Hello Everyone, My name is Jones and i am new to this forum and to oracle. I am using oracle 9i. the below mentioned is my problem. SQL> CREA

Pass sql into pl/sql and create RMAN duplicate script.
Hi, I'm new to pl/sql and I'm trying to write a script that will generate some RMAN commands to do a database clone. I want to able to run the s

insert Multiple rows into the table from that table data
Hi All, I have a requirement like to insert mulitple rows into the table from that table data only(I need to replicate the data). In this ta

Getting number of affected rows in SQLPLUS..
Hi everyone, I have a shell script where i am invoking sqlplus, running a query and saving the result in a spool file in a .csv format. Now this f

How can I Compare two xml documents?
Hi all, I am doing a POC for my project and I am using XE database 10g version. I want to make a comparison between two xml document stored in a

 

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash