hi, currently i am working on a project where we are going to do bulk batch processings. for this we are using bulk collect and bulk insert features of oracle...
Dear Sir, When ever I use BULK COLLECT feature to collect thousands of rows from a table PGA memory is running Out of scope. Here I have a table named...
Hi Everybody, After checking lots of mail between the war of Committed Vs. Non-committed and Rollback Segment and Datafile. Could anybody give me a clear and...
Hi all I have a schema in Access and want to convert all its tables into oracle. Please let me know the way I can convert Access tables into oracle tables. I...
Hi, my name is dayananda shenoy, i am working as an vb/oracle developer. currently we are developing a large scale centralised banking software in vb and...
Hi It's my first connection to your Site. I'm a new user of Oracle and I must realize my End-Study project as soon as possible. I have install (on Windows 2000...
The Fall Conference of the Northern California Oracle Users Group will be held on Thursday, November 4, 2004 at Computer History Museum in Mounta View. This...
I'm implementing an application but I have to make a decision on use stored procedures or prepared statemnts. Do you have any experience and what will be your...
I create one trigger when i am trying to compile it is giving PLS-00417: unable to resolve "RTN_ORD_RTN_RSV_QTY" as a column while this column exist in table...
I am using Oracle 9i DS on XP with Oracle 9i DB on Unix. I have a form and am trying to run a report from the form. This is what I have coded: repid =...
Hi All, I would like to know any of you implemented java stored procedure sending out TIBCO message. Please email me if you have implemented it Thanks, ...
Hi , If some has good doc which explain in detail about this AURORA$SERVER$SHUTDOWN trigger please share with me If have searh in the metalink but not getting...
Hai Iam getting an error FRM-40815 when am running the form to generate a report on my local server which is on Win 200 OS where as my web server is on Unix ...
Hi, I want to downlaod the trial copy of 10G software can any one please tell me from where to downlaod . I have try otn.oracle.com,technet.oracle and so may...
Hai I am using Oracle Forms 6i on win2000 on local machine where as Unix on my web server Iam getting an error FRM-40815 when am running the form to generate a...
Dear Group Members, I'v just joined in the group, and seek your help. while starting Logminer with starttime and endtime parameter it gives an error :Fatal...
I just installed ora 10g on two Win2K machines. On one machine I couldn't bring the Enterprise Manager up. I checked Administrative Tools\Services to see if if...
hi everyone, I have one problem ie, What is Database(Oracle) testing? How to write test cases for DB Stored procedures (DB Code checking) and data integrity...
I have a column containing large data with carriage return. When I query this column, it will give me several rows for one record because of carriage return....
Can anybody help me to find a way to retrieve large amount of data per batch(100 records at the time). I want maximize the cpu usage. Thank you Ernie ... Do...
Dear all We are developing Oracle 9i based ERP system,this is actually intranet based application.We have around 600 users will be connecting this application...
Friends, I need to improve the speed of this query, and don't know how. I apologize if this isn't the proper group; please point me in the right direction if...
Hi, I am handling the responsibility of designing a strategy of Migrating Data from Oracle 8.0 to Oracle 9i Release 2.0.The conditions that apply for this are...
Hello, I am using sql*load to load my table. I want to only load a record if it's length is less than 100. I have a tried a no: of options. One that almost...
Hello, I am using sql*load to load my table. I want to only load a record if it's length is less than 100. I have a tried a no: of options. One that almost...
Hi Guys, I have cleared the fundamental 1 Paper today with 98.33%( 59/60.) I've send mail to all groups peoples who have cleared the papers...for thier...
Having problems with message search?
