(Database: Oracle 10G R2) It takes 1 minute to insert 100,000 records into a table. But if the table already contains some records (400K), then it takes 4 minutes and 12 seconds; also CPU-wait jumps up and “Free Buffer Waits” become really high (from dbconsole). Do you know what’s happing here? Is this because of frequent table extents...
I am developing a small web application,Its data size is constant. i.e data dosent grow with date/user. I would like to know if I can use Oracle Express for this application. ...
I just tried to do a correlated subquery in the FROM clause of a SELECT statement in Oracle, but I was given an error indicating that I couldn't do the correlation (something to the effect that Obs.pID was not recognized). Should this work? FROM ml.Person Person JOIN ml.Obs ON Person.pID = Obs.pId JOIN (SELECT ObsMax2.pId, ObsMax2.h...
I'm trying to calculate the size of a few tables as stated here, but I can't find the block header size variable How do I get it? Is it some kind of formula? I'm using Oracle 10g ...
Hi How I can make my Table in Oracle 10G ? in graphically - like in Sql server thank's in advance ...
I am using spring-2.5.6 to connect from a standalone application to an Oracle 10g database (ojdbc14.jar) using the org.apache.commons.dbcp.BasicDataSource. When I try to retrieve a SqlRowSet using the public SqlRowSet queryForRowSet(String sql, Object[] args) throws DataAccessException method I am getting an 'java.sql.SQLException: Inval...
I'm trying to make an import of a database but I get this error: Imp-00009 Abnormal end of export file Imp-00020 Long column too large for column buffer size(7) The import creates four tables and creates the rows for three of them, I guest that when the import tries to create the rows for the last table is when I get the error. I try ...
I have three machines set up as follows: CompA: Running Oracle server 10.2.0.3 CompB: Running Oracle server 10.2.0.4 and my client code CompC: Running client code only On the client code on both CompB and CompC, connecting to either Oracle DB works flawlessly using the Thin driver. I am trying to connect to each Oracle DB from the c...
HI all Can you tell how to import data from oracle 10g to Oracle 9i. Is it ok i can export the data from Oracle 10g and import it to 9i directly, it should work??? or i need to follow some other procedure??? Kindly help me Thanks in advance Joseph ...
How can I insert Picture to Oracle DataBase Oracle ? can I get C# sample code ? thank's in advance ...
i am using jwsc to build my webservices application. This produces a war file with a weblogic.xml like the following: <?xml version='1.0' encoding='UTF-8'?> <weblogic-web-app xmlns="http://www.bea.com/ns/weblogic/weblogic-web-app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.bea.com/ns/weblogic/...
We have OEM Grid Control installed. This is on solaris. I can't use the mass deploy script since directories are different on each server. I have a few questions. Do I use the agent_download script? is there a gui for this? Installing the agent in windows has a gui. Or do i have to set the response file? how do i find what port my O...
Hello all, I am using oracle database 10g. I have to write a java stroed procedure through which i can call a file at the server and store it locally at the users machine. Im using oracle Apex 3.1.1. ...
Hi, I have a problem executing oracle procedures from Visual Studio 2008's Server Explorer, when i try to execute a procedure all the input parameters are doubled! it only happend to me in one workstation, i've tried to reinstall oracle products, but it doesn't helped me... i get the following error message when i try execute the pro...
I have a table with four columns with different dates. I want to retrieve a column name with maximum date; can any one help on how to go about that? ...
We have Oracle 10 g databse and we are getting message as ORA-00018: maximum number of sessions exceeded . we configure the parameter as below; Session 600 process : 600 and its a shared Server Mode. We update this to Session :900 and Process : 750. and right now Oracle is running,but i need to know is this help us to go on or i need...
I have the following table (simplified) in an oracle db: productId | modelDescription 1 | thing 2 | another thing 3 | not a thing 4 | thing I want to select the modeldescription which has the highest appearence in this table. The problem is that there can be near...
Hi, Hope someone can help with a problem I'm having with building a query in oracle. I'm a newbie to oracle, allthough i do have some little knowledge of sql - It's a cinema booking system scenario - and Im trying to get the sql below to output one line, which is a total of the tickets sold for a particular performance in a particular...
I need to dynamically populate an Oracle cursor (Oracle 10g). The SQL statement changes, based off of the input value to pull from different tables, and columns. What I don't want to do is have to maintain a temporary table that I truncate and load everytime the sproc is executed. Here is what I am currently doing, but if there is ano...
Hi I Made Setup from my C# program (that work's with Oracle 10g) when I try to run this program - in different Computer, i got this error message: unable to load dll 'OraOps10.dll' what it can be ? thank's in advance ...