Oracle Corporations version 10 of its flagship RDBMS product.
0
votes
3answers
57 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
85 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
51 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
37 views
Help with Oracle Pipelined function
I have a pivot where I have a contract with tank numbers separated by ; and I've been given this example to pivot them down into rows (which works):
SELECT oks_c.contract_number,
...
1
vote
1answer
25 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 ...
0
votes
1answer
65 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 ...
1
vote
1answer
70 views
Fixing wildcard expansion resulting in too many terms error (DRG-51030)
How can I resolve the wildcard_maxterm problem in Oracle 10g?
My index creation syntax is:
begin
ctx_ddl.drop_preference('SUBSTRING_PREF');
end;
/
begin
...
1
vote
1answer
19 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.
...
6
votes
1answer
149 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 ...
1
vote
1answer
45 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 ...
0
votes
1answer
37 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 ...
0
votes
2answers
46 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 ...
2
votes
1answer
58 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 ...
2
votes
2answers
46 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 ...
0
votes
1answer
86 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 ...
4
votes
1answer
63 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 ...
1
vote
3answers
126 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
2answers
63 views
Communication between two database servers
I have 2 databases running on different virtual servers. I have some database processes running on one node. These processes connect to Database Gateway (PG4MQ) and process the messages.
I need to ...
1
vote
1answer
76 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
3answers
69 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 ...
0
votes
1answer
304 views
Database creation on Linux with dbca: “command not found”
I have installed an Oracle on my machine. When I open a session with VNCServer and type dbca, either as root or as oracle, I get these errors:
-bash : -dbca : Command Not found
Xlib: connection to ...
-2
votes
1answer
29 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
64 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 ...
2
votes
1answer
57 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
144 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 ...
1
vote
1answer
212 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 ...
1
vote
0answers
48 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
133 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
...
2
votes
1answer
97 views
Finding why an Oracle listener got automatically restarted
I got the following message in the <listnername>.log file. I want to find out the reason why it got automatically shutdown and restarted again with different PID.
03-MAR-2013 03:00:57 * ...
0
votes
0answers
96 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
245 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
233 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 ...
4
votes
2answers
264 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 ...
0
votes
1answer
589 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
votes
0answers
63 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 ...
0
votes
2answers
453 views
Oracle 10g slow performance on first query
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 ...
2
votes
0answers
69 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 ...
0
votes
0answers
196 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
463 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 ...
1
vote
1answer
116 views
Deleting folders after Oracle upgrade
I upgraded from Oracle 10g to Oracle 11g in Windows Server 2003.
New Oracle home : C:\app\oracle\product\11.2.0\db_1
Old Oracle 10g was installed on: C:\oracle\product\10.2.0\
Questions
Is the ...
1
vote
1answer
142 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
256 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 ...
1
vote
0answers
136 views
Oracle locked sessions with ASP.Net
I am connecting to an Oracle database in ASP.Net using SQLDataSource. My connection string is:
<add name="ConnectionString3"
connectionString="Data Source=sml; User ID=sml; Password=sml; ...
2
votes
1answer
346 views
Recompiling dependent objects in Oracle
I wonder what is the best practice to recompile Oracle 10g programmable objects that become invalid due to changes in one of them.
To be more specific, I have a few packages, that use schema level ...
0
votes
1answer
54 views
Is it any potential problem with having 2 constraints suppored by one index in Oracle?
I have the following table :
CREATE TABLE action (action_id INT NOT NULL,
action_type_id INT NOT NULL,
action_date DATE NOT NULL);
CREATE INDEX IDX_ACTION_ACT_TYPE_ACT ON action(action_id, ...
0
votes
1answer
92 views
What are the criteria for a sql staying in the V$SQLAREA?
I needed to pick up details from a SQL result but 5 minutes after running the SQL it was no longer under v$sql and V$sqlarea. What are the criteria for Oracle to keep the query in those views?
0
votes
1answer
238 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
95 views
How to measure improvement after splitting tablespaces into multiple disk volumes? (Oracle 10g AWR)
I have a recently released 10 000 user analytical application that is suffering from performance issues because of excessive amount of transactions. Apart from re writing many of the SQLs in the ...
0
votes
1answer
853 views
Need to count records and group count by date on Oracle
I have a table like the following
ID created sent type
-----------------------------------------------------
0001463583000051783 31-JUL-12 1 270
0081289563000051788 ...
2
votes
1answer
159 views
Upgrading from 10.2g to 11g by incrementals
I know it's possible to generate a full rman backup in a 10.2g database, move it to another server containing 11g, restore it there and finally do an upgrade.
Since I have to do this to a large ...
