Forum: Oracle Server

I am trying to rewrite a generic data load procedure for large tables to use the INDEX REBUILD statements instead of dropping and recreating the...

HELP! Anyone SQL gurus out there please help me with a query update to a table: I need to update a column in a table sequentially base on the...

I want to search for a string in the values of all the columns of all the accessible Tables. How do you do that in SQL(sqlplus)?

We use a Windows2000-System with 3 processor. Most busy is one of this three processors. What can I do, to share the resources more symmetrical. Is...

Hello, my application use jdbc thin driver to connect to my database. After some time I got ORO-17401 Error with following description: protocol...

Hello All, (Oracle 8.1.7.0.0, running on NT4 SP6) I have a snapshot set up to refresh daily. The setup of the snapshot is: CREATE...

On 10 Jul 2003 01:49:51 -0700, sameer_taiwade@yahoo.com (BadApple@serpent.garden.edu) wrote: As was to be expected of course Sybrand...

Hi all I have a database which is about 500GB in size, a tablespace for the ROLLBACK which is 40GG with 20 rollback @ 780MB each, then we...

Billy Verreynne <vslabs@onwe.co.za> schreef in berichtnieuws 1a75df45.0307100151.9305c69@posting.google.com... | HP-UX 11 B2. Oracle 8.1.7.4 | |...

Hi gurus, I'm facing this problem where I'm trying to backup using BAckup tool in Oracle EM and it says file already exists. Can you please look...

"apple" <applechu@elifemall.com.tw> wrote in message news:bbeg5n$c5h@netnews.hinet.net I've the same issue on Mandrake 9.1. I thought that...

8.1.7, linux Situation: ran a relatively complex query using 6 bitmapped columns, on a partitioned table, and with autotrace on. That's fine....

> sqlplus> connect as sysdba This should be "connect / as sysdba" or "connect sys as sysdba". This either means that Oracle is...

Oracle 8.1.7.3 on HPUX 11.0 In our third party developed app, I have noticed the response time with packaged variables, or anything _not_...

Hi, I know Fine-Grained Access Control permits adding a predicate to manage access to objects. The predicate is in the form of WHERE clause so you...

Hi, We have a very dynamic database here that grows 400Gb per year. At present we have a Compaq DL 380 with 2 Smart Array 5300 controllers (each...

TableSpace USR_DATA had grown to 10 GB. It has 8 datafiles, each more than 2GB. I have dropped some of the User schemas not in use anymore. Now...

I have developed a VB application that uses Oracle 8i database for backend. The database server is on the local network. From my development...

Hi, I hope my question is not *too* silly, but I would like to know if there is any view inside the data dictionary to see in real time which...

Oracle8(TM) Server Concepts " When a transaction runs out of space in the current extent and needs to continue writing, Oracle finds an available...