I want to write some data from an oracle cursor in a text file using the oracle stored procedure.
So i tried creating a directory on oracle server (with code described in step A)
and then tr...
Hi Folks,
I have a table cnam_load which is Oracle table and the columns of the table are :-
mdn
action_type
I have to use the over partition by command to get the first value and th...
I ave a relatively large database that had some minor performance issues. I had been going through and Analyzing tables and computing statistics. This improved overall efficiency and the num...
Can't remembeer SYSDBA password nor SYS nor SAYSTEM password
Have tried, Manager for SYSTEM and change_on_install for SYS but to no avail. IS there a way to recover SYSDBA or SYS or SYSTEM...
hi
i have a table with 5 partitions.
now i want something like this.
select * from table_name (from partition 3).
how to do this ?
1 CREATE OR REPLACE PROCEDURE TEST_EXCEPTION() IS
2 type array is table of stg_exception%rowtype;
3 l_data array;
4 bulk_errors EXCEPTION;
5 t_errmsg varchar2(4000);
6 t_error...
I have two tables, parent/child (1-m). I need to track all changes made to either table and maintain the relationships at the same time so I can capture an audit trail and also a snapshot at a...
SP2-0332: Cannot create spool file
I get this error when I run my unix script. I spool to /opt/logs/exception_file and it gives me error SP2-0332:. when I spool just to the file name excepti...
How to rename a column name in ORACLE 9i
Just a quick question..
I was wondering if there is any impact on database if I delete oracle trace files from udump and bdump directories....
Is there anything which i will lose? Note...
very urgent
i am using an oracle procedure that have an out parameter of sys_refCursor, BUT i need to order the data with in the cursor by one of the attributes in the cursor. How can this ...
I am trying to change a MS SQL query so I can use it in Oracle, i am new to Oracle and dont know where to start - can someone help convert the query to Oracle
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
System: Microsoft Windows Serv...
Oracle v 9.2 on Linux
I created the following MV (300 million rows, 33 partitions)
It is partitioned on wk_idnt a partition consists of 4 weeks. I took the indexes from the detailed tables a...
I have an Oracle (9i) cursor that is populated via a dynamic SQL statement. This cursor is part of a function that accepts user-input parameters. What I need to do is return the result set of ...
Hi,
Please help me with this Oracle query. What is wrong with it?
"INSERT INTO ModuleSchedule (FKJobModule, ScheduleDate, StartTime, EndTime) VALUES (2, '29 Sep 2007', '00:00:00', '00:29:0...
Getting invalid file name when trying:
create tablespace CMS_DATA datafile extent management local segment space management auto;
What is invalid about that filename?
Hi,
We are going to upgrade from oralce 9i to oracle 10g for a peoplesoft database.
I would like to have any documentation or link for any Experience feedback on that subject, to study all...
I need to put my oracle server on the internet. But I can't put it directly in it, thus I put it behind a firewall that
forwards all requests to port 1521 into my server in my local area n...
I "inherited" forms 6i application from other developer who no longer with the company. He developed application using "form reference" method, meaning that instead of pll library he was using...
In my web application i am getting a java.net.SocketException: Broken pipe exception on and off.
Cany anyone tell me what can be probable reasons for this, and how can i troubleshoot the is...
How often do you have to rebuild indexes and statistics? How do I know whether I have to rebuild indexes or not? any scripts that i can use to analyze the tables to decide whether I need to r...
I need to write a sql script that will return a row if a date is null, otherwise return the highest date.
Example.
Table1
--------
Reference VARCHAR2(10)
Sequence NUMBER
begins DATE
...
i just need to add a date condition in where clause of my select statement can some one help here i am new to oracle.
here is what i need...
WHERE log_date between (sysdate-2) and (sysdate) ...
I am developing oracle forms, in that i have given a data block item as required. when the user doesn't enter the value it just shows an error message. I want an alert statement for that, for ...
