I AM TRYING TO AUTOMATE\SCHEDULE A JOB THAT RUNS MY SPROC EMBEDDED WITHIN A PL\SQL PACKAGE. NOT SURE WHY THE DBMS_JOB.RUN DOES NOT EXECUTE MY JOB, PROPERLY?
ERROR at line 1:
ORA-12011: ex...
What should be the ideal PGA size comparatively with SGA size. What are the factors that count while deciding this parameter
Is there a way to fast delete without redo, undo? Truncate table is not an option right now. I wonder if there is a hint in the delete to make the delete faster. I just want to delete and d...
Getting error ora-01031 - Insufficient privileges when creating a new user as SYS or SYSTEM.
Checked dba_user_roles and SYS and SYSTEM user have DBA privileges granted.
Is there a new ...
I have two update statements that update a column with record count. Id need to add the count results from these two updates. In Oracle, the records not get updated stay as null which omit ma...
Hello all,
I have a select statement (as follows). When I run it in TOAD I get an error message: an INTO clause is expected in this SELECT statement. Any ideas! Thanks in advance for yo...
What is the Connection, Session and what is the relation with no of process paramter of database server. When the connection pooling done how the Idle time of a conenctin is managed ?
Hi,
I have a 10.2.0.1 Oracle database on a windows xp professional machine,service pack 2,Intel dual core processor,2.33ghz cpu and 4 gb ram.
Total size of my development database is 10gb ...
Hi all,
I am wanting to find a way to programtically retrieve the table names, column names, column specifications (length, type etc.) from an Oracle database. So maybe using an OracelDataRea...
Hi,
I ran a ProC program which reads from a flat file and then writes to an Oracle 9i database. I'm having a problem when one of the column has special character in it (e.g a varchar2 colum...
I have the following emp_names, 'Scott', 'Mike', 'Jane'. I like to change (translate) to some kind of numbers so I can sort. The sort can only take number, not char. How? Thanks.
How can I remove existing OEM setup (Webbased) and reconfigure OEM for that database.
I tried do some as I shown below but it is not working. Can you please help me setup OEM
CREATE OR REPLACE FUNCTION fn_cat_dwell_daytime (
in_startime IN INTEGER,
in_endtime IN INTEGER,
in_geositeid IN INTEGER,
in_realestateid IN INTEGER...
Hello,
I am a Java newbie. I have just installed Java jdk1.6.0_07 and can compile and run standard java applications. I need to connect to an Oracle 10g R2 database from a Windows client ...
I have a pl/sql run but get an error on the last line of the code (AND NVL(b.default_sub_market,'???') <> 'TX '). Please help.
DECLARE
v_cnt NUMBER;
v_ban_list VARCHAR2(30000) := ' '...
I'm getting this error when tnsping-ing the SID defined below. The ODBC connection MySQLTDSN works. How do I resolve the error?
TNSNAMES.ORA entry:
MySQLTDSN =
(DESCRIPTION =
...
Hello,
I'm running the following query below. I have set the linsize to 8000 the long to 200 and the longc to 200 yet the column which has 200 chracters is getting word wrapped at 100 chrac...
One of our Developer received following error while deleting records from table via TOAD. (DELETE FROM isd_publication_data.)
ORA-01591: lock held by in-doubt distributed transaction 10.88....
I want to copy rows from one TableA, with over a million records, to anther TableB with identical column names, both in the same Schema. TableB is completely emply, but has several more colu...
Dear Experts -
How can I rewrite the query for full outer join(10g).
I'm getting ora-01416 for the following syntax.
select sec.*, bmk.*
from (select ibf.sec_id,
i...
Hello,
We have old application built using Oracle forms 6 and Oracle 8i Database, and we are building new web service application to retrieve data from other databases.
However, we w...
folks
how do i cast a string value to integer or float in oracle ie the value
100.23 is a string field type in table A and i need to get it into tbale b as a float value using a trigge...
Experts,
Do OS users need access to ORacle UDUMP, CDUMP and BDUMP files? If users only have READ persmissions then is this a security issue?
THanks MIssyMadi
I need to install 10.2.0.4 on unix box and migrate data from 9i to new 10.2.0.4.
Can some guru help me.
Thanks
I am running Oracle 9.2.0.8 on Solaris 9 and last night I found in my primary database alert.log the following entries:
Thread 1 cannot allocate new log, sequence 50339
All online logs ne...
