I have a number of Materialized views in an Oracle 10g database that have stopped auto refreshing.
They have successfully refreshed since installation.
I can manually refresh them and successfu...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23037965.html
Zones:
Oracle 10.xDate Answered: 09/29/2008 Rating: 8.2 Views: 0
i can connect as system, but i dont believe i ever set up a sysdba account (or forgot the password). i dont see the sysdba user profile in the oem users panel. can system be given shutdown privileg...
http://www.experts-exchange.com/Database/Oracle/Q_23261839.html
Guys
I am using the enterprise manager in oracle 10g we had an oracle error which becuase I am not on site I was not aware of and I was not notified until much late on which I could have quickly...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23433313.html
Guys
This may be a simple question but by applying the code
ALTER SYSTEM FLUSH SHARED_POOL would this have a negative affect on performance afterwards.
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23435844.html
SQL> l
1 SELECT SUBSTR(corrid, 1, 4) corrid
2 , priority
3 , q_name
4 , COUNT(*)
5 FROM queueowner.pa_sync_qt
6 GROUP BY corrid,priority,q_name
7* ORDER...
http://www.experts-exchange.com/Database/Oracle/Q_23457017.html
I need to setup something like SQL server log shipping for my Oracle 10g database. I have the PRODUCTION oracle server hosted at a co-location. We have a secondary server at HQ with an oracle insta...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23473763.html
Zones:
Oracle 10.xDate Answered: 08/26/2008 Rating: 9.3 Views: 0
Guys
I use oracle oem 10g I would like to use the metallink link to get the patches from oracle but everytime I run this I get the following error but I am nit sure how to move on
Updating OEM ...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23489804.html
I originally set up a user HSS with the following table spaces (HSSDATA for data and HSSINDEX for the index tablespace). Later I wanted to change tablespaces. So I ran the following sql code for ea...
http://www.experts-exchange.com/Database/Oracle/Q_23548216.html
I'm trying to create an Oracle trigger to rollback a transaction if a new value being inserted already exists in the database. I realize I can create a unique constraint but I have an automatic imp...
http://www.experts-exchange.com/Database/Oracle/Q_23563794.html
Zones:
OracleDate Answered: 07/14/2008 Rating: 9.7 Views: 0
Hi,
What does the OracleDBConsole<sid> process do? Is it critical for a .NET client to access the database?
Thanks!
http://www.experts-exchange.com/Database/Oracle/10.x/Q_23656620.html