Oracle Corporations version 10 of its flagship RDBMS product.

learn more… | top users | synonyms (1)

0
votes
3answers
353 views

Getting the employee history of Sales department from HR database in Oracle

I am currently using the 'hr' database with Oracle 10g. You can view the schema diagram over here: http://docs.oracle.com/cd/B13789_01/server.101/b10771/diagrams001.htm#sthref63 What I would like is ...
3
votes
2answers
433 views

SQL*Plus default output format

I have noticed that using the same SQL*Plus client to connect to different Oracle database result in different outputs for the same SQL query. Database 1: C:\Oracle\instantclient_10_2>sqlplus ...
0
votes
2answers
66 views

Difference between the given queries

I am required to retrieve the list of pno ( product_id ) for the products which were purchased by two customers. For this, I have been given two relations which are ( along with the attributes ) as ...
1
vote
1answer
84 views

Which version of Oracle supports Streams

I am using Oracle 10g Express Edition. I want to enable the streams feature in my current edition. However, when I searched on the net I couldn't find any information regarding streams setup on Oracle ...
1
vote
3answers
450 views

Restore Oracle tablespace to 2 days before

I have multiple test tablespaces in an Oracle SID. One of the tablespace is updated with wrong data. It works fine 2 days before. I want to restore the tablespace to 2 days before. Can anyone ...
0
votes
1answer
479 views

Oracle Database 10g JRE Error

I am trying to install Oracle Database 10.2 on OEL5U6(Linux System). I followed all the instructions from HERE. When I am executing installer this return: Preparing to launch Oracle Universal ...
0
votes
2answers
144 views

Oracle remove and place (re-install) database on 10g

I need to put together a plan to execute some change scripts to a Oracle 10g database, which will add some values, change some values a drop a table and create a new table. I have a step for creating ...
0
votes
0answers
180 views

TimesTen performance as compared to 10g

I am new here, so please be nice... I have a question regarding TimesTen & Oracle. I have attempted an experiment with both pieces of software, and realize that the query speed on a table is ...
0
votes
1answer
609 views

How would I store the result of a select statement so that I can reuse the results to join to different tables?

How would I store the result of a select statement so that I can reuse the results to join to different tables? This will also be inside a cursor. Below is some pseudo code, in this example I have ...
2
votes
1answer
654 views

Are multiple dbf files better than one?

Is it better to distribute a large database over several dbf files than over a single one?
2
votes
2answers
5k 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
1answer
199 views

Size of an empty database

Continuing with my school-project, now I have to estimate the size of the database from here to 5 years. They give me a formula, so, in that formula, one of the values is the size of the empty ...
-1
votes
0answers
94 views

Oracle 10g Login Error [closed]

I have installed Oracle 10g on my pc. Now, when I try to login in with Scott/Tiger, system/manager or the Database username/password given while installing Oracle 10g, it gives me "ORA-12560 TNS ...
1
vote
1answer
44 views

map user in oracle 10g

here is the scenario: There are two schema created in oracle 10g, say db 1 and db 2. db1 can be accessed by username : sys with password and db2 can be accessed by username : test with password. ...
0
votes
0answers
181 views

Merge two packages into one package in Oracle 10g

I want to combine two different packages into one single new package in Oracle 10g. Is there some way to accomplish this?
6
votes
1answer
503 views

sqlplus consuming 99% CPU

Oracle's installed on one server, I'm running sqlplus on a different (application) server. I've recently encountered a problem getting sqlplus to do anything; it simply spins, consuming 99% CPU even ...
0
votes
1answer
43 views

Mview replication

We are setting up a large scale replicated environment and would like to know if there is a way to skip certain dml for eg. deletes during data trasfer with simple mview replication. Also, is it ...
1
vote
1answer
159 views

Migrating Oracle packages to SqlServer

I'm moving database from Oracle to SQLServer (2012 if that matters). The process of migrating tables/views is more or less straightforward and automated. Triggers are also not an issue since I don't ...
2
votes
1answer
105 views

Locking records in Oracle during update

I had a deadlock issue which was easy to fix by changing application logic, but I was under impression Oracle would behave differently, and the deadlock would never happen. I have two tables, for ...
3
votes
2answers
86 views

Deleting an Oracle database without connecting to it?

I have two databases which were created using dbca. I made some changes in the second database, and I can't login to that database anymore, and, of course, I can't delete it by using dbca. I am using ...
4
votes
1answer
239 views

Oracle pivot on a column with delimited data

My data is like: keycol,col1,col2,col3 1,a;b;c,some data,some other data 2,x,some data,some other data 3,y;z,some data,some other data Where a column is delimited in the source system with ...
2
votes
0answers
82 views

Oracle 10g weird behaviour

We have a thick client application using an Oracle 10g database. We recently upgraded the application and in the process migrated the database tables from a latin to unicode character set. After the ...
2
votes
1answer
2k views

Is shrink a safe online operation?

We are planning to run the following space management command: alter table XXX shrink space cascade on a production database (Oracle 10g). The XXX table is a transactional table heavily used for ...
2
votes
1answer
551 views

Find fragmented space free below HWM Oracle

That High Watermark Value always eludes me when calculating free space in my tablespaces. Will the following query consider fragmented free spaces of object below the HWM value for each TS? select * ...
2
votes
3answers
176 views

Oracle error : Shutdown immediate error

echo $ORACLE_SID YBRD conn sys/hello as sysdba SQL>shutdown immediate Then I was waiting for it to shutdown for a couple of minutes. It didn't, so I closed my window. Then I again logged in and ...
3
votes
2answers
1k views

How does name resolution work in Oracle 10g?

In Oracle 10g (10.2.0), there are 4 types of names resolution: Easy Connect(10g added this new method) Local naming Directory External naming It is said that if Easy connect is used by the ...
-2
votes
1answer
35 views

Following procedure generates an error and I cannot find the reason [closed]

create or replace procedure buyunits is mnav number; mpno varchar2(100); mtransactioncharge number; mservicecharge number; maccno number; cursor ecursor is select accno from sipholder where ...
0
votes
1answer
312 views

trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error [closed]

I am trying to execute a simple CREATE TABLE query on an oracle10g database using java. This is what I am doing: Connection conn = //create connection //open connection. No errors/warnings are ...
1
vote
1answer
569 views

Oracle Forms 10g to 11g migration Error

I having problems from first steps, while migrating Oracle Forms from 10g to 11g. Some of libraries dose not want to compile. the compiler just hangs up when I try to compile them, and Forms builder ...
2
votes
1answer
84 views

Oracle Database: View schema without access to data

In Oracle Database 10g, I need to create a user with these permissions: user can access schema to be able to read table names and columns user can not select (get) any data from any table Is this ...
0
votes
1answer
301 views

Oracle trigger to update columns daily

I'm trying to create a trigger that would run twice daily and do updates based on a specific condition. To be run on Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi We have Table A ...
0
votes
2answers
2k 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 ...
1
vote
0answers
114 views

How can I count the total number of document indexed by my oracle.text index?

I know I can use ctx_query.count_hits to count the number of document matching a query, and similarly, I can use count(*) where CONTAINS(...) But these are only options if I actually have a query. ...
1
vote
1answer
513 views

Materialized view log not updating

Under what conditions would a materialized view log not update? I must be missing something. I've got a 10gR2 database. I can create the following MV logs: CREATE MATERIALIZED VIEW LOG ON linked_t1 ...
0
votes
1answer
1k views

Creating new database and insert values in Oracle 10g xe hr account?

I am new to Oracle 10g xe. When I log into hr account, how do I start creating new database and insert values? My case study is a five aside football league, where the organizer wants to know ...
0
votes
0answers
998 views

12154 error when using PL/SQL Developer

I have installed a few versions of Oracle on my machine. I have tried 64 bit and 32 bit versions. I have installed 11G. I need Oracle 10G 32 bit. Using the following guide I removed all versions of ...
5
votes
2answers
659 views

Oracle View Ignoring External WHERE Clause

Good day, This one has me stumped. I have a rather nasty developer query that I would like to store in a non-materialized Oracle view. The text for the view itself is a bit long to list here, but ...
1
vote
1answer
3k views

Difference between full and level 0 rman backups?

Suppose we take a full backup, and after that we take a level 0 backup, both using RMAN and Oracle 10g. I'm confused in the use of the level 0 backup and full backup. I found that the difference ...
1
vote
2answers
470 views

Would existing constraints and indexes applied to an old table, apply to a new table renamed like the old one after it's dropped?

everything is in the question. I have a table named tableA on which we have indexes and foreign keys and constraints. I have to modify content in a column called column1. This being a production ...
1
vote
1answer
593 views

Backing up an Oracle 10G Express on Windows 2000 Server

Oracle 10G Express installed on Windows 2000 Server Enterprise Edition. I am trying to automate backups and on Oracle's website I have found the following documentation. ...
0
votes
4answers
5k views

What's a good client tool to access Oracle RDBMS? [closed]

I'm looking for a good client tool to replace "Oracle SQL Developer" (the tool I currently use) which supports: Oracle DB 10g, 10gR2, 11g Running SQL code Debugging SQL code (with walk-through... ...
0
votes
0answers
376 views

Oracle 10gR2 Data Guard Switchover

I need some help! I have a scenario of oracle 10gR2 database replication using data guard. I have selected the data guard command line interface. After my initial setup I can ship and apply logs from ...
1
vote
1answer
346 views

Find who will change a record in oracle DB

Someone is updating a record in a custom Oracle table, is there a way to find who is updating the record and or at least the table?
0
votes
1answer
573 views

Massive update to Clob fields oracle 10g

I need to remove a string of characters from 2000+ clobs fields in oracle 10g. How would I do this in PL/SQL? For example, in table t1 there is a clob field called VBase that needs to have the ...
1
vote
1answer
1k views

listener does not currently know of SID given in connect descriptor in oracle 10g and solaris 10 env

I have a oracle 10g database in solaris 10 system. The SID=OTRS, I can connect to oracle database from local server itself. But I can not able connect from another client. It is returning an error ...
0
votes
1answer
6k 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
1answer
2k views

Split CLOB into multiple VARCHAR2

I currently am working with some data that is being stored as a CLOB between 4000 and 6000 characters. I would like to perform the TRANSLATE function on it but I learned that it's not possible with a ...
1
vote
1answer
280 views

What's the maximum number of listeners an Oracle database can have?

Can an Oracle database have more than one listener? If so, what's the maximum number of listeners a database can have?
2
votes
1answer
595 views

Oracle 10g using collection with sql

I have a stored procedure that takes collection of objects. (TABLE OF MyCustomType). Inside the procedure I'm trying to join this parameter with real tables. For example, something like create or ...
9
votes
3answers
8k views

Tracing, debugging and fixing Row Lock Contentions

Off late, I've been facing a lot of row lock contentions. The table in contention seems to be a particular table. This is generally what happens - Developer 1 starts a transaction from Oracle ...