Questions tagged [oracle-10g]
Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.
20
questions
7
votes
2
answers
29k
views
What is the difference between Schema and Database in Oracle?
In Oracle, datafile are system files where actual data is stored. The collection of datafiles make tablespace and, at last, database is collection of tablespaces.
Correct me if I am wrong on the ...
25
votes
7
answers
41k
views
Oracle - Any way to view uncommited changes to a particular table?
I'm debugging through a batch process currently that does a lot of DML statements, but doesn't do a commit right away. It would be nice to be able to view the "pending" changes from another session ...
3
votes
2
answers
1k
views
Encountering exception ORA-01555
I was given a problem to solve , in which there is table called Scenarios in the Master Db which contains the details of all the Tablespace for which I have to find the size. The O/P should contain ...
2
votes
1
answer
19k
views
ora-01410 invalid RowID sporadically in a select statement
I have a select that looks up some data by a join. The system runs Oracle 10.02g and the select looks like this
SELECT distinct t1.crit
FROM table_name1 t1
INNER JOIN table_name2 t2
ON t1.crit ...
0
votes
2
answers
2k
views
generate/analyze trace for error 1461
I am trying to generate a trace file when arise errors with code ORA-01461.
I have executed the following statements:
alter system set events '1461 trace name context forever, level 4';
from alert....
0
votes
1
answer
2k
views
How to query Last inserted row for each group in oracle 10
I have two tables about users where I want to join two tables and show the latest remarks of each user
bellow is table
I want to query the latest remarks for each user (1 remark per user)
bellow ...
26
votes
3
answers
278k
views
How do I declare and use variables in Oracle?
My main skills are with SQL Server, but I have been asked to do some tuning of an Oracle query. I have written the following SQL:
declare @startDate int
select @startDate = 20110501
And I get this ...
14
votes
2
answers
105k
views
Using Same CASE WHEN Conditions For Multiple Query Columns
Is there a "better" way to rewrite a SELECT clause where multiple columns use the same CASE WHEN conditions so that the conditions are only checked once?
See the example below.
SELECT
CASE ...
7
votes
2
answers
8k
views
Oracle 10g - How to prevent one user from hogging all resources?
I am wondering if there is any way to limit how much resources one user can take on my Oracle system. I want to limit some queries and systems from being able to hog all system resources when they run ...
7
votes
1
answer
6k
views
Slow join behaviour with 'or' in predicate
I'm faced with a situation which I can't understand and overcome.
In short we have left-join query like:
select from a
left join b on a.key1=b.key1 or a.key1=b.key2
This works VERY slowly, while ...
5
votes
2
answers
9k
views
Oracle 10g dump file push into Oracle 11g database
Currently when executing the imp command with the following parameters: file=my.dmp log=my.log fromuser=myuser touser=myuser
The following errors occur:
IMP-00058: ORACLE error 12560 ...
4
votes
1
answer
483
views
Can this be accomplished with Oracles Fine Grained Auditing?
We need to audit when a table is accessed (either select, update or delete) and I know Oracles Fine Grained Auditing can handle that. The issue we are having is that all of our users use the same ...
3
votes
2
answers
6k
views
Oracle "matches" multiple columns
I am developing a web service where a term of search is given, then I return all the matches from employees table. In MySQL I used to do the following:
SELECT * FROM employees WHERE MATCH(name, ...
2
votes
2
answers
29k
views
Return many rows on a plsql Oracle10g
I'm doing a little project and I need to do a plsql to return many rows.
I have someting like:
Table(id, data1, data2, from)
And the user gives me the value of from and I have to return all that.
...
1
vote
1
answer
2k
views
How to improve the performance of this select query?
I have two tables: TABLE1 and TABLE2.
And I am running this select query to fetch the data. It takes long time to run:
SELECT TABLE1.* , TABLE2.COL1 , TABLE2.COL4 FROM TABLE1, TABLE2
WHERE ...
1
vote
1
answer
10k
views
restore database from dmp file
I have a situation:
I have a dmp file and a database with old data
server crashed and the latest data we have ar in the dmp file!
we managed to pull the server back but it has old data!
so we need to ...
1
vote
2
answers
6k
views
Oracle 10g slow performance on first query [duplicate]
We have an application which we recently upgraded and is having bad performance issues. Any ideas would be much appreciated.
The main issue is windows taking ages (minutes) to open because the ...
0
votes
1
answer
14k
views
Moving a 10g database to 11g with rman backup
Following Doc ID 369644.1, I'm trying to restore a 10g database into a 11g database ( version 11.2.0.1.0), which is in other server.
What I did on 11g server:
- Generate full rman backup of 10g ...
0
votes
2
answers
96
views
More Efficient Use of Union
Looking for a more efficient way to achieve what my view is doing. This view joins tables to themselves to show where each part in the database is used. In other words if I am a part of a part list ...
0
votes
1
answer
6k
views
How to take oracle 10g backup? [duplicate]
Possible Duplicate:
How to take oracle 10g backup?
I followed this http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php link to create a db backup. I used this command to create db ...