Am in situation where i need to load the data from a text file to a table which i can do with sql loader
but how can we load the data if they are not in a fixed positions is it possible or n...
Hi Expert,
The user is getting an error when he try to connect through sqlplus,
he is getting an error.
ORA-12705: cannot access invaild datafiles or invalid environment specified.
i check...
I need to create a report in Crystal XI that displays multiple rows horizontally.
I have attached an spreadsheet showing a sample of the table and also how I need to report the data. Any h...
Experts,
i got this problem with rman. it is saying that dev4 is faild. how to resolve this problem
name=/opt/mis1/oracle/data/BBQISPRD/db15/data/BBQISPRD/BBQISPRD_bbtxn_fq200704_1e.dbf
...
hi,
I'm having a problem importing data from MS access 2000 to oracle 10G. One of the fields in a table is a memo field on the access side. I'm connecting to access using heterogenous service...
Folks
i have a column called TAG,here the data is like so
Root/Test Terminal/Cranes/Automatic Rail Mounted Gantry Cranes/A_125L/A_125L:AVAILABILITY
how do i extract the part within...
dear experts,
I would like to build the query which can extract the rows based on the below condition
Col
2#45#892
56#90#22
- - ------
67#2#999
My table having lot values of such ...
sir
The job scheduler in oem is used to schedule job..
we can create job using pl/sql in that..
But I don't know how to create a job..In which occastion we create job using pl/sql
Can any...
How can I grant 'select' privilege to a role on all the tables belonging a schema?
Hi,
I have a field Lock that certain users can fill out to indicate whether the data in a few other fields in the table can be edited or not by other users, but I don't know how to implemen...
Hello,
In reading various information on the web there seems to be a great debate over rebuilding standard Oracle indexes( how often and how affective it is etc.). I have a table that expe...
Solaris 10
64-bit Oracle 10g (10.2.0.3)
I'm trying to change the filesize of a particular tablespace file to 32GB, and I am having problems doing it. Are there filesize limitations on th...
Hi, I'm configuring my 10g RMAN backups to tape to use the auto controlfile backup option and I have a few queries that I hope some experts can answer.
1. I know that Netbackup settings ove...
While Executing a Query it consumes a Lot of Temp Table space, and Eventually ends up
throwing the Following Error "Unable to Extend Temp Table Space by 128",
We have tuned the Query, and...
let say i configure autobackup of controlfile on in RMAN settings and i also add this statment while i took backup
backup database include current controlfile;
when my backup finishes the...
Hello,
I have installed Oracle10.2.0.1 in F:\oracle\product\10.2.0\db_1 directory using OUI. I then patched it to 10.2.0.3. I then tried created a database using dbca. The file environment ...
I using Oracle 10g2 on Suse 9 x86_64. The storage is based on RAID5 composed of 3 disks
In my system I have a lot of small transactions. This cause a huge amount of writes into redo logs, whi...
What could be the reason of this?
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With th...
How I can saved command as SELECT statement in SQL Plus ? and How I retreive the commands again when I run SQL Plus next time ?
I hope I understand this enough to pose an intelligent question.
- I'm working on a web-based application written in J2EE which interfaces to an Oracle database.
- Users log into the syste...
A SQL select statement is verry slow in an custom database.
The execution plan shows very hight cost for the operation. All tables are indexed and the statistics are corect. In all other case...
We have 4 node RAC setup. with ASM datafiles/ OCFS2 filesystem.
O.s - RHLinux - 4
I have mounted OCFS filesystem in 2 new nodes.
During Clusterware installtion, its not taking up OCR loc...
Hi experts
I have an Oracle question related to a select. The main part of it is bellow:
contains (ad.Title, '?sch%' WITHIN ADR_Name);
The '?sch%' can be retrieved in uppercase. How...
I have to do a select where I am summarizing the the lost items by last name for a particular month. When I do a straight SUM on LOST I get twice the number that I need because I have 2 recs ...
In the Control Panel the Services are as follows
Service Status Status Type
OracleDBConsoleorcl Started Automatic
OracleJobSchedulerORCL Disabled
OracleJobSchedulerORCL1 Di...
