Experts Exchange Search Results

I have an administrator in grid control setup, i.e. DBAUser. This particular user never gets email from one target. If I setup another account, DBAUser1 with the same email addresses, it receives e...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23136694.html

Zones: Oracle 10.x, OracleDate Answered: 05/16/2008 Grade: A Views: 12

oracle, 10.2.0.3, 10.2.0.3, how to create a variable

Tags: oracle, 10.2.0.3, 10.2.0.3, how to create a variable

folks I hsave the following INSERT INTO B(TYPE,ID,DESCRIPTION) (SELECT 'STR',(SELECT (SEED+1) FROM AUTOKEY WHERE AUTOKEYNAME ='SRID') SEED,ASSETNUM FROM WORKORDER how can I make a var...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_22751411.html

Zones: Oracle 10.xDate Answered: 08/09/2007 Grade: A Views: 0

setting index stats using dbms_stats.set_index_stats

Tags: oracle, oracle, 10.2.0.3

I have a query that has 2 equality predicates. There are 2 indexes , index1 is on the first equality predicate and index2 is on the second equality predicate. index1 is very slective returns 5 r...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23088071.html

Zones: Oracle 10.x, OracleDate Answered: 02/14/2008 Grade: A Views: 26

Determine root of SQL trace file

Tags: Oracle, database, 10.2.0.3

I have a trace file in my UDUMP directory (Windows) that is continually being written to. The file is too large to open. I'm trying to find out what created this trace file. The file is gspec_ora_1...

http://www.experts-exchange.com/Database/Oracle/Q_23220264.html

Zones: Oracle, Oracle 10.xDate Answered: 03/22/2008 Grade: A Views: 0

mgmt$job_execution_history status code 17

Tags: Oracle, Oracle, 10.2.0.3

When I query sysman.mgmt$job_execution_history I see the status field populated with 17. Does anyone know what this code 17 represents?

http://www.experts-exchange.com/Database/Oracle/Q_23315767.html

Zones: Oracle, Oracle 10.xDate Answered: 04/11/2008 Grade: B Views: 0

SP2-0310: unable to open file

Tags: Oracle, 10g, 10.2.0.3

We have recently migrated from 9i to 10g. The new operating system is HP-UX 11. We have couple of shell scripts which execute sql files as below example. Some of them are executed without any e...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23368874.html

Zones: Oracle 10.x, Oracle, HP-UX UnixDate Answered: 05/17/2008 Grade: A Views: 59

What is the best method to clone database on a remote...

Tags: oracle, 10g, 10.2.0.3

What is the best method to clone database on a remote server where the database size is more than 100TB? Is RMAN better than manual copying the files across the network?

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23682907.html

Zones: Oracle 10.xDate Answered: 10/12/2008 Grade: A Views: 0

Implementing controlfile autobackups

Tags: Oracle, RDBMS, 10.2.0.3

Hi, I'm configuring my 10g RMAN backups to tape to use the auto controlfile backup option and I have a few queries that I hope some experts can answer. 1. I know that Netbackup settings overide ...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23549583.html

Zones: Oracle 10.x, OracleDate Answered: 11/08/2008 Grade: A Views: 9

How do I set the listener to oracle 9i from 10.2.0?

Tags: oracle, oracle db, 10.2.0.3

Hi experts, I have oracle listner 10g running and I have my environment set to 10g when I do lsnrctl status I see the services whci are oracle 8 databases showing up and when I do ps -ef|grep /opt/...

http://www.experts-exchange.com/Database/Oracle/10.x/Q_23115940.html

Zones: Oracle 10.x, Databases, OracleDate Answered: 02/08/2008 Grade: A Views: 4

RMAN: How to clone a database before reset time.

Tags: Oracle, Oracle, Oracle 10.2.0.3

I use a recovery catalog and have full backups of my database that are stored on tape. Last weekend, I upgraded the database from 9i to 10g and then registered the new database with the recovery...

http://www.experts-exchange.com/Database/Oracle/Q_23347607.html

Zones: OracleDate Answered: 05/29/2008 Grade: A Views: 52