This question is really about a much more complicated query, but the core of the issue can be reduced to the simple queries below.
The following query, results, and plan are good. Performan...
Hi Experts,
I want to check the maximum number of user and session that can connect to the database?
please help me on this?
Switchover using Data Guard Broker Gives the following error:-
DGMGRL> show database PROXY_93
Database
Name: PROXY_93
Role: PHYSICAL STANDBY
Enabled: ...
I have a query that I get this error: PL/SQL: ORA-00909: invalid number of arguments
The purpose of this query is:
-- If execution (current) date is MON then get previous THU into v_begin_da...
Hi Experts,
I have a task to upgrade the oracle database from 10.2.0.2 to 10.2.0.4 on SunOS sparc 64bit.
Following are the components installed on to the database.
OWB Repository, JVM, XM...
Hi,
I am getting 2 different format for the below queries why so,my init.ora file has 'DD-MM-RRRR'
select value
from v$nls_parameters
where parameter = 'NLS_DATE_FORMAT';
Result:DD-...
name you pro-contra items for using following queries for join or (+):
Query A:
SELECT *
FROM EMPLOYEES E
LEFT JOIN DEPARTMENTS D ON E.DEPARTMENTID = D.DEPARTMENTID
Query B:
SELEC...
Hello,
How can I perform a search through all source types (triggers, procedures, packages etc.) to see if they contain a unique string (say "ABCDEF")?
Thanks,
Michael
In a Trigger i want to restrict the delete operation based on some condition , Th following is my code
CREATE OR REPLACE TRIGGER Reconciliation_BEFDEL_Trg
BEFORE DELETE
ON WFPROD.reconci...
I created a schema named myconfigs which has 3 tables, a role which has select, update, delete on the three tables named myconfig_user. I have another schema named workuser that has been grant...
I am new and hope my quesitons are not to stupid.
I am new to oracle 10g coming from 8i several years ago. I was recently re-assigned to the main dba rolel, being more of a developer for sev...
Oracle 9.2.0.4
AIX 5.2
I found a filesystem that was 100% full this morning. I moved a 7GB datafile with the following commands:
alter tablespace HISTORICAL offline;
!mv /txpd_dat1/or...
HI
i am currently using oracle 11i ( it uses jiniatator) i am also using another web application that uses jre if run the two applications simulatoneausly (each in a seperate IE instance)i d...
I'm trying to see the result from a spool file but I only got "PL/SQL procedure successfully completed." How do I get to see the resutl from a spool file?
set serveroutput on
spool c:\te...
We did a packet capture analysis, and it shows that the application server with the JDBC connection is receiving 10B TNS keepalive messages from the DB servers. However these msgs are not maki...
I currently have a RMAN recovery catalog on a 9i database.
I would like to upgrade the database to 10g but don't want to lose any of the old recovery catalog data.
I created a new 10g da...
how do i go from this
Color
------
red
orange
blue
green
And return a resultset like this:
Colors
-------------------------
red,orange,blue,green
I have Oracle 10g db installed. I check the listener was working okay. I went ahead and tried to install the Oracle Enterprise Manager 10g for an existing database. I give it the infomation f...
HI,
I have a table with column contains unicode value. I am inserting this charcter to my client machine by use of one tool. After inserting the unicode charcter data it is stored wrongly i...
When I try to select a BLOB defined column in ORACLE (10G) with ADODB I receive error "Unspecified Error"
My Code
str = "select file_id, file_blob from ***** where file_in_blob = 1"
rs ...
How to create a 2D Array in PL/SQL in Oracle?
I want to create a 2D array to store the following data, but 1 array for storing sales lines, and one array for storing replace line, and each ...
Hi Expert,
Is Anyone know how to query a Blob Compress fields in oracle? I need the result in readable format because the blob field is compress. (need to decompress it)
Thanks
I see
log_archive_dest_1= / / /..... MANDATORY REOPEN
can you explain me the what is the MANDATORY REOPEN means here
Please explain to me how do I list out the privileges currently assigned to the user.
Hi, i am converting this Firebird view to Oracle and I'm getting this error: ORA-01799: a column may not be outer-joined to a subquery. Seems like I should remove the outer-join but I failing ...
