Oracle Corporations version 10 of its flagship RDBMS product.
1
vote
1answer
21 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
245 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
35 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 ...
1
vote
1answer
77 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
votes
0answers
27 views
How to correct my Oracle SYSTIMESTAMP?
My database's timestamp has 8 second difference with my OS system time (as well as time from the internet). This caused some bug in my code. How to correct this?
-1
votes
1answer
49 views
populate table header and data in another table column [closed]
I have 2 tables: Departments and Employees, where Department_Id is primary key in the departments table and a foreign key in Employees table.
Departments Table:
Department_Id Department_Name
10 ...
1
vote
1answer
59 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 * ...
2
votes
2answers
620 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 ...
0
votes
1answer
64 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
27 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
45 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
125 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
50 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
90 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
232 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 ...
1
vote
0answers
30 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
72 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
0answers
55 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
1k views
Why does dbms_scheduler max_run_duration not raise event JOB_OVER_MAX_DUR?
Starting from this question and this example I've tried to create an event based dbms_scheduler job, which waits for event JOB_OVER_MAX_DUR raised from jobs, which exceeded their max_run_duration.
...
0
votes
1answer
137 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
178 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
183 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
288 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
204 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
321 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
0answers
51 views
Oracle 10g Login Error
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 ...
2
votes
0answers
39 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
4answers
2k 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
136 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
133 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
231 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
299 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
2k 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
605 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
112 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
188 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 ...
7
votes
3answers
5k 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 ...
1
vote
0answers
112 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; ...
5
votes
2answers
568 views
How to install Oracle 10g Express and 11g Enterprise on same machine
I have to continue maintaining an Oracle 8i database that receives information (about 20 Inserts and Updates a day) from a 9i database. I am upgrading the 9i database to 11g which does not support ...
2
votes
1answer
220 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 ...
1
vote
2answers
875 views
oracle 10G forms connection with Oracle database 10G Enterprise Edition in windows 7
I am trying to connect Oracle Forms 10g version (9.0.4) to the Oracle 10G Enterprise Edition.
At first I tried to connect to the db without setting the "Local Net Service Name Configuration" in ...
1
vote
1answer
73 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 ...
14
votes
7answers
4k views
Oracle - Any way to view uncommited changes to a particular table?
I'm debugging through a batch proess 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 while the transaction ...
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
66 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
498 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
121 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 ...
1
vote
1answer
37 views
What type of files are C-9999-yyyymmdd-00 in Oracle
At my {ORACLE_HOME}\database I found like 3GB of this type of files:
I think they are not backup of controlfile because size of files changes over time.
0
votes
1answer
52 views
Problems with generating Audit SQL
Im currently working on a project that uses Oracle 10g where every action from the user is recorded in a auditlog table. The current table holds the following values:
AuditID
AuditDate
Username
Page ...
1
vote
1answer
117 views
Dropping indexes and disk space
If I drop a large index and re-create it, does that increase the size of the datafile where the index is stored?
When I drop an index, it's quite fast. However, when I build one, it takes time, and ...
