Questions tagged [oracle-10g]

Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.

Filter by
Sorted by
Tagged with
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 ...
nitesh.kodle123's user avatar
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 ...
contactmatt's user avatar
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 ...
Egalitarian's user avatar
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 ...
mruether's user avatar
  • 180
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....
Shaunyl's user avatar
  • 528
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 ...
Santhoshkumar Sivaji's user avatar
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 ...
Mark Allison's user avatar
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 ...
Steven's user avatar
  • 319
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 ...
Chris Dale's user avatar
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 ...
smwoody's user avatar
  • 73
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 ...
Woot4Moo's user avatar
  • 201
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 ...
jworrin's user avatar
  • 141
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, ...
manix's user avatar
  • 385
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. ...
nax's user avatar
  • 165
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 ...
Santhosh's user avatar
  • 117
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 ...
Data-Base's user avatar
  • 357
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 ...
Julian's user avatar
  • 131
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 ...
Delmonte's user avatar
  • 719
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 ...
Matt D's user avatar
  • 55
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 ...
babu's user avatar
  • 43