Hai !
I am trying to do this way:
CREATE OR REPLACE PROCEDURE index_maintainance(table_name_h VARCHAR2)
IS
table_count_p NUMBER := 0;
BEGIN
execute immediate 'alter...
Hi. I've been trying to find more information on the gather_stats_job in Oracle 10g, but haven't been able to find much documenation to answer these questions:
What creates the gather_stats...
Hi,
We have encountered the following error with Oracle Scheduler
STATUS = STOPPED
ADDITIONAL INFO = REASON="Job slave process was terminated"
The above information was retrieved from ...
Hello,
I wanted to execute couple of queries as transaction in oracle 10g.
I'm executing these queries from .net application. So I will be sending these queries not at once. Typically, be...
what are the task does production support dba does?
I'm trying to come up with a way to check if a field that I'm selecting from a database is a date or a string that I can do within a case statement. here's part of the select:
select /*+ ...
I'm unable to find the following patch set clearly identified as being supported on the Windows XP SP2 platform:
Oracle Database 10g Release 2 (10.2.0.3/10.2.0.4)
Enterprise/Standard Editi...
Hello. Let me give you some background before I drill into what I need. At the moment I am producing, or at least trying to produce some Intricate reports using Crystal Reports (Dont worry ...
Hi Experts,
I'm looking for assistance with technology ideas that will allow text-based (XML) messages to be taken (consumed) from a high-volume TIBCO EMS queue in realtime and for the XML ...
Hello
I'm trying to change the current_listener on our linux oracle10g server. This is what i do
LSNRCTL>l show current_listener
Current listener is LISTENER
LSNRCTL>set current_listener...
I need to insert foreign language ( e. g. CHINESE, JAPANESE, GREEK, LATIN etc. ) characters into an Oracle Table. Can you describe the complete step-by-step process on how I can achieve this ...
Try to do a Oracle 10g export on Unix box this is the message that I get from the logs:
. . exporting table PS_OMBCK_ESF_TMP1 0 rows exported
. . exporting table ...
Sir,
a user has "connect" and "resource" privileges by the DBA. The allocated quota on three tablespaces by the DBA
Default Tablespace Quota 500 M
Tablespace first Quota 100 M
Tablespa...
Hi,
I have a question because I want to transfer data from an SQL Server system to Oracle. The transfer includes about 15 tables. I want just to skip or replace double primary key values i...
Hi all,
Though i am working in Oracle for sometime but i am new to this administration part.
We have Oracle 10g installed in one system, we are planning to move it to a new system(same p...
I've got all files from Oracle Express, default instalation in c:\oraclexe. Unfortunatelly access to the running instalation is not possible (computer is down). Only files from c:\oraclexe are...
Hi All,
I have to upgrade a oracle 9i to 10g database.
I also have tables that have rowids and also a few tables that have stored rowids of other tables.
What is the impact to these t...
Running Oracle 10.2.0.3 on Windows 2003. Receiving the following error: Connection to x as user y failed: ERROR: Wrong password for user.
I know the password is correct and the LOGON AS A B...
I'm getting this error message ORA-01476: divisor is equal to zero while running GATHER_STATS_JOB: GATHER_TABLE_STATS('"HDWPD004"','"DWH_HIER"','""', ...) in 10.2.0.3 oracle database.
I just freshly installed Centos 4 and Oracle 10g. Everything passed and met the required criteria. The problem I am having is after the install everything is working after I pull up the "EM"...
Hi!
I have a table 'table1' containing about 3.8 billion records. The table has range partions(weeky dates) and hash partitions( id). The thing is, i have realised that i would need to add ab...
Hello,
I have Oracle 10g dedicated server installed on my laptop which running Vista Ultimate using dynamic IP addresses settings.
I installed Microsoft Loopback Adapter and updated acco...
Can any expert make clear what is host in oracle..
hi i installed oracle 10.2.0.1.0 on my ocal machine and do not plan to connect any remote machine. I need to run some queries on a database eon my local machine. The services with oracle name ...
Hi,
I have the following query;
select qid,
sum(decode(mcanswer, 0, 1,0)) mczero,
sum(decode(mcanswer, 1, 1,0)) mcone,
sum(decode(mcanswer, 2, 1,0)) mctwo,
...
