How can i replace the outer join (+) operator with a not exists subquery in the following query:
SELECT *
FROM EMP,DEPT
WHERE EMP.DEPTNO = DEPT.DEPTNO (+)
Full table scan advantage or disvantage? explain....?
I am using Oracle 10g2 database Express Edition
I would like to shrink datafile belonging to oracle system tablespace. The datafile "system2.dbf" grew as a result of importing schemas using i...
I was aksed to create a script that audits all the usernames in our oracle databases and confirms that the username and password arent the same.
So my goal is to create a KSH korn shell scr...
I am using oracle thin by giving the following url as shown in the below statement DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","sridhar","sdk711");
I am getting error when I user DB_LINK
0/0 ORA-04052: error occurred when looking up remote object
SCOTT.PASS_REP@TOM.target.COM
ORA-00604: error occurred at recurs...
Hello,
I have been using traditional RMAN (backup database etc.) since Oracle version 8. In 10g if you choose to use the scheduler to create an "Oracle Recommended" backup it creates the...
I'm trying to send the output of an SQL statement to a .doc file. I really really don't want to see the commands, so I tried SET ECHO OFF before SPOOL, but I still see them. I only want to out...
Hello,
I am attempting to export data to a mapped Microsoft drive. When I perform the export I get the error shown in the code snippet.
I have done the following:
1. Mapped the drive t...
Hi
I am running following Query where main and relatives table have one to many relationship i.e for one main table there are many relatives.
SELECT SUBSTR (text,1,DECODE (INSTR (text...
I have a stored procedure (as below) which basically iterates through the passed in values array_mq_rid_in and updates the records. array_mq_rid_in value can be greater than 50K so I have its...
How one an find the size of the database, tablespace, available disk space? I do not want to use the OEM.
Hi,
I have a few questions
1) What is exact difference between UNDO and REDO?
2) When did UNDO came into picture in which Oracle version?
3) Is it necessary to maintain UNDO and REDO t...
I have a batch script file, im getting the input from user and i will store in a variable, then i need to check if the variable is having value or some value, but i dont know how to check or n...
Hi,
I am trying to update BLOB column into the database with another DOC File using following code:
create or replace PROCEDURE UPDATECONSULTANT
(
c_id IN NUMBER,
c_bfile_name IN VA...
I'm getting this error when I login to SSO.
The HTTP server and OID is running fine. but if I go to http://localhost:7777/oiddas and tried to login this error comes out.
It also says:
Eith...
I am an Oracle newbie working on a stored proc that I want to return a result set. I know there a quite a few examples in the knowledge base, but they do not seem to fit what I am doing.
M...
I installed Grid Control 10g on Win 2K3 SP2 and connected to the interface successfully. After restarting the system I can no longer connect. The error message is listed below. No changes were...
Hi there
I am trying to convert access tables to Oracle. I have already created control file in Notepade but when I go to DOS to execute the control program it give me message "SQL*Loader-500...
I'm planning to patch my Oracle RAC 10.2.0.3 to 10.2.0.4 its having streams , need to patch simultaniasily? give some steps or suggestions
I've created a orapwd file.
I've set the init.ora parameter 'remote_login_passwordfile'=exclusive and bounced the database.
I've created a user, i.e., create user qcuser....
I've granted...
I'm trying to update a remote database using database link between oracle enterprise 10g (10.1.0.3) for local site and oracle express 10.2.0.1 for remote site. The database link works well for...
Hi, i´m converting this Firebird view to Oracle and I´m getting this error: ORA-00904: string: invalid identifier. I cant see why this is happening, since the table name is correct, the field ...
When I attempt to startup the instance from sqlplus on command line... i get this
ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Is there a...
I am new in ORACLE 9i and need help resolving this problem. I am making a .NET application and use ORACLE 9i as a backend database. I am using "Microsoft .NET provider for Oracle" to connect t...
