oracle10g

Oracle 10g Setup: in Visual Studio 2008 ?

Hi i am using Oracle 10g database with ASP.NET website. I would like to know how can i make setup of Oracle 10g for deployment? Is there any way to make Oracle Database setup in Visual Studio 2008? ...

Oracle 10g Database Restore

Whats the best and fastest method of Oracle 10g online backup without shutting down the restore so that restore will be faster ...

How should I range partition an index with a varchar2 column in Oracle? Is it a bad idea?

I am using Oracle 10g Enterprise edition. A table in our Oracle database stores the soundex value representation of another text column. We are using a custom soundex implementation in which the soundex values are longer than are generated by traditional soundex algorithms (such as the one Oracle uses). That's really beside the point. ...

iSQLPlus not starting on Port 80

I am trying to change the port for iSQLPlus on my Oracle DB server, by making changes in the file http-web-site.xml. When I change the port to 80, in this file, the iSqlPlus doesn't start. I can nether connect over a browser or telnet to it, even from the host machine itself. On the command line, however, it does not give any errors. ...

Should an Oracle database have more than one tablespace for data storage?

My team maintains an Oracle database that is approx. 200GB in size. All of the data (tables, indexes, etc) lives inside a single 'USERS' tablespace. Is this a bad idea? What benefits are there to having multiple tablespaces, and under what circumstances would I want to add more to my database? Thanks! ...

Oracle Server dropping sessions Frequently

I have an oracle server which is dropping Sessions (Connections) frequently, with just about 5 minutes idle time it is dropping the connection. Resource limit is not set on this server, and the IDLE_TIME for the User profile is set to unlimited, the strange thing is this happens even when we create a new instance, and that too behaves in...

Why would I use SQL*Loader conventional load paths?

My understanding of SQL*Loader's conventional path is that it simply generates INSERT statements and sends them to the database. Are there any performance benefits to using this rather than just generating the SQL statements programmatically and executing them against the database? ...

Finding missing sequence in a table

Hello all. I'm using the Oracle 10g Database. i'm trying to figure out how to write a simple sql query to: find the missing numbers in a table between say 86002895 and 86005197 (inclusive), There are 1955 rows between 86002895 and 86005197. Ex: Current Scenario : table_1 : tracking_no | id_value 86002895 | 10 86002896 | 10 86002899 |...

How can I keep Oracle SQL Developer from closing the DB connection?

Is there any way to keep Oracle SQL Developer from closing my DB connections, or to increase the timeout? Sometimes during a long-running query SQL Dev will just close the connection, leaving my query running on the server but me with no results. If I RDP into the server and run SQL Dev locally it never seems to have this problem. ...

How to write a good regex to distinguish between Arabic and English characters in Oracle using the AR8MSWIN1256 encoding?

I've been scouring Google and can't seem to find an answer. I'm running Oracle 10g Enterprise with the following character-set: AR8MSWIN1256 The database holds English and Arabic values, and I need to differentiate between the two from time to time. I wrote this script, which matches on English words but not on Arabic words: create or ...

Performance Tuning

How can i check the Query running from long time & steps of tuning the query? (Oracle) ...

Windows server 2003 : requirements for website deployment

Hi every body, I have one ASP.NET website having following associated components ASP.NET framework 3.5 MS Chart AJAX Components Connection with external webservice for data Oracle 10g Enterprise edition I am going to deploy all web site component, database, email server and FTP service under same hardware. Here I would like to kno...

Oracle Driver for Qt

Any oracle10g driver is available for QT3 ...

Oracle : Use two different versions of EXP on the same machine ?

Hi, i have a server (HP-UX) installed with Oracle 10g and several databases on it. I've been asked to make dumps from these tables for a Oracle 8i database. In order to do this, i need to use the 8i version of the EXP (export) tool of Oracle. It is still installed on my server but when i want to use it, i get the following error : EX...

plsql block to get the dynmaic sql query result

we have created following anonymous block........... DECLARE sql_str long(32000); where_str long(32000); counter NUMBER(3):=0; BEGIN sql_str:='SELECT '||' A.bio_id ,'; where_str:=' where '||'A.bio_id=B.bio_id AND'||' A.bio_id<>0 and rownum<25 AND (' ; LOOP counter:=counter+1; sql_str:=sql_str||'decode(A.wk_unit...

Is a globally partitioned index better (faster) than a non-partitioned index?

I'm interested to find out if there is a performance benefit to partitioning a numeric column that is often the target of a query. Currently I have a materialized view that contains ~50 million records. When using a regular b-tree index and searching by this numeric column I get a cost of 7 and query results in about 0.8 seconds (with no...

can oci driver for 11g (odbc5.jar) work with 10g client ?

Hi, I need to connect to Oracle9,10 and 11 in my java application.The client will always be present where the app will be run and I want the app to just work with username,password and instance (specified in tnsnames.ora).Hence I would like oci drivers with a connection string of type : jdbc:oracle:oci:@testora .Im using the driver: ora...

ADF exception JBO-27014 in an editable table with LOV column

I'm working with ADF BC 10.1.3.4, I've 2 pages, a search page that forwards to a detail page with showOneTab component. In the first tab I've an af:table (Editable) with all controls available, Add, Delete & Commit The first column contains a LOV (SelectOneChoice) for each row. The issue scenario is as follows, Search for a school, sele...

In SQL in a "group by" expression: how to get the string that occurs most often in a group?

Assume we have the following table: Id A B 1 10 ABC 2 10 ABC 3 10 FFF 4 20 HHH As result of a "group by A" expression I want to have the value of the B-Column that occurs most often: select A, mostoften(B) from table group by A; A mostoften(B) 10 ABC 20 HHH How do I achieve this in Oracle 10g? Rema...

Retrieving key attribute names of a given table

Hi all, I am working on a database middleware application again. I want to retrieve the names of all key values of a given table. For instance: CREATE TABLE foo(A INTEGER PRIMARY KEY, B VARCHAR(255)) I want to ask Oracle for the primary keys of 'foo' and I want to get 'A'. Is this possible in Oracle at all? I tried to search their d...