Oracle Corporations version 10 of its flagship RDBMS product.

learn more… | top users | synonyms (1)

2
votes
1answer
131 views

How oracle Oracle Database 10g used index?

I have table “result”, DDL : CREATE TABLE result (id_graduate NUMBER NOT NULL, id_sml NUMBER NOT NULL, last_update DATE NOT ...
2
votes
1answer
234 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 * ...
1
vote
1answer
143 views

ORACLE error while dbstart command

I'm trying to start up Oracle DB with startup command. But error occurred while startup. dbstart[80]: test: argument expected Failed to auto-start Oracle Net Listene using /bin/tnslsnr touch: ...
1
vote
1answer
144 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
463 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 ...
0
votes
1answer
18 views

Delete all types created by a user

In Oracle 10g, how do I delete all the types owned by a specific user? This is the view that gives me the types I want to drop:SELECT type_name FROM user_types;
0
votes
1answer
11 views

Transfer Oracle 10g Database From Linux to Windows

Can anyone tell me how to restore Oracle 10g Database backup created in Linux to the Oracle 10g version for windows...
0
votes
1answer
35 views

Export synonyms content to tables

I have a distant database to replicate having huge data but I have access only to synonyms and I would like to use Oracle export/import tool to import these data into tables of local database. What ...
0
votes
1answer
57 views

Startup NOMOUNT and Startup MOUNT on dataguard oracle

I have a question here about Oracle data guard. After performing a switchover, we shutdown the new standby database and startup it. At this stage, sometimes I find DBA performance in 2 different ...
0
votes
1answer
60 views

Alter table add column query blocking a table or taking so much time

I'm trying to add a new column to an existing table but it takes so much time or the query is blocking the table, i'm really confused about what's happen exactly. ALTER TABLE MYTABLE1 ADD MYEXPORT9 ...
3
votes
0answers
384 views

Convert Oracle Query for Date to Mysql queries

Need to convert the following oracle queries to MYSQL queries. 1) select to_char(to_date(?,'DD-MM-YY')) from dual; 2) select to_char(next_day(to_date(?,'DD-MM-YY'),'FRIDAY')) from dual; 3) ...
3
votes
0answers
183 views

changing Virtual IP interface names on RAC nodes - how to reconfigure

We are adding an extra interface on our nodes and we are going to bond these so the VIP interface will change from eth5 to bond3. Can someone point on documentation on what to do to reconfigure the ...
2
votes
0answers
79 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
0answers
219 views

What do I need to do to avoid ORA-32696 errors?

I have a SELECT query using several WITH blocks. Sometimes it runs successfully. Very often it fails with the error "Lookup Error - Oracle Database Error: ORA-32696: HTI: No free slot". I Googled the ...
2
votes
0answers
344 views

Isssue with Database Links converting OEM Job to DBMS_Scheduler Job

We had an OEM job that would run a PL/SQL block using a particular database users credentials. The credentials are the same for two different databases, so there was no problem for the block to use a ...
1
vote
0answers
73 views

How to store object with property of generic type in DB

In my business domain there exists an entity parameter. Beside other properties which are identical for each parameter, they have values. These values can be of different data types. There might be ...
1
vote
0answers
87 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
0answers
204 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; ...
1
vote
0answers
278 views

Which oracle (10g) template files (DBCA) can be be copied to different server for cloning?

I am trying to clone a schema from one Oracle 10g server to a different Oracle 10g server. I have created a database template (DBCA) from an existing database (structure and data). I have copied ...
1
vote
0answers
405 views

v$logmnr_contents with username as unknown

I applied logminer to find who deleted a lot of rows in one table. View v$logmnr_contents give me details of that operation. Unfortunately, minimum supplemental logging was not active when archived ...
1
vote
0answers
412 views

Timeout on remote query over database link

We are trying to verify if a database link is up before inserting data into a remote database. We have no control over the remote database's behavior and status. We need to set a timeout on a query ...
1
vote
0answers
30 views

What might cause all objects in an Oracle database to suddenly have quoted identifiers?

I have an Oracle schema in which, at some point in the past ("the event"), all of the procedural code objects in the database have been re-created with quoted identifiers. All of the objects are ...
1
vote
0answers
142 views

Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x

I have migrated from Oracle sql developer tool 1.5x to 3.1x and imported my connection settings with database 10g. When I try to open a connectionstring in the developer tool I get this message: ...
1
vote
0answers
529 views

What can cause [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused.?

The Title speaks for itself. We have this error message on the client side of the application. The devs suspect a problem on the database. The alert log on the database shows no errors at all. The ...
1
vote
0answers
373 views

Error starting up OC4J_EM: java.sql.SQLException: Logical handle no longer valid

I'm trying to launch the OPMN-managed process OC4J_EM, which is needed for Oracle's Enterprise Manager. When I run use the startall or startproc command, I get an error: failed to start a managed ...
0
votes
0answers
15 views

Oracle Historical Session Information

I want to know the view or query which provides the total number of active and non-active session for a specific snapshot. Currently I am using the below query. SELECT INSTANCE_NUMBER, count(*)*10 ...
0
votes
0answers
25 views

Extracting node names by looping through xml in Oracle 10G Plsql

I have an XML that looks like below, <email_details> <VENDOR_ID>73</VENDOR_ID> <RGP_NUMBER>1234</RGP_NUMBER> ..... ..... (any number of ...
0
votes
0answers
17 views

Oracle AQ Message Replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far ...
0
votes
0answers
43 views

Execution time is different between normal query and query inside a stored procedure

I have following simplified query WITH Report1 AS ( SELECT SUM(t.X), SUM(t.Y) FROM Table1 t WHERE t.Date1 > :dateStart and t.Date1 < :dateFinish ) SELECT * FROM Report1 This query ...
0
votes
0answers
25 views

How to Upgrade from Oracle 10G to Oracle 11G without bringing down the database

I have an Oracle 10G database running on two machines in a resilient environment with shared storage. So when one of our system fails we simply switch the GSS to second database instance. Now I need ...
0
votes
0answers
42 views

Display rows with no NULLs

My query needs to return all 20 columns for each row that does not contain a NULL in any of those columns. The query I have is: Select Col1, Col2, ... Col20 from table where Col1 is not null and ...
0
votes
0answers
15 views

Background process RECO didn't start

I'm trying to create an oracle instance but when trying to create a database i obtained the following error message : ORA-00443: background process "RECO" did not start CREATE DATABASE DATA * ERROR ...
0
votes
0answers
166 views

Database Open but Oracle gives ORA-01033: ORACLE initialization or shutdown in progress

We are using 4 node Oracle 10GR2 RAC in Windows x64. 3 instances of our database crashed today and later started normally. I started them by connecting (Remote Desktop) to individual instances and ...
0
votes
0answers
32 views

expdp taking so much time

I'm doing a full export using the expdp tool. I'm using 4 dump files and parallel parameter with 4 value. The export size calculus shows 30Gb but it takes almost 4 hours for 4 Gb. I'm pretty confused ...
0
votes
0answers
62 views

Undo tablespace size in many data import in short number of tables

Yesterday i've had many problems trying to import a big dump file with only 9 tables but many rows in each table. In common use the undo tablespace has a size of 1.5 Gb. But when trying to import the ...
0
votes
0answers
35 views

Datalink error when executing remote query

This afternoon i was working with an old datalink defined to transfer data from one database to other. It's the first time i've worked with this 'trick'. We use an specific user to work with the ...
0
votes
0answers
152 views

Oracle 10g xe database error when connecting ORA-12528

I am trying to connect to my local database Oracle 10g XE however i am getting the following error ORA - 12528. This connection was working and this issue suddenly arose. I did LSNRCTL status the ...
0
votes
0answers
39 views

SQL Link Connection OLE DB provider Query Execution Failed

I have created linked connection in SQL and by which I am connecting Oracle server using OLE DB provider "OraOLEDB.Oracle". SQL Server = 2008 R2 Oracle = 10g Normally, When I am executing Insert or ...
0
votes
0answers
81 views

Oracle 10g XE SET NEWNAME doesn't work

I want to migrate database from Linux to Windows. I restored controlfile and mounted the database. Now I run the following: run{ allocate channel t1 device type disk; set newname for datafile ...
0
votes
0answers
93 views

Install 10g XE on 64bit linux

As I know there is only 32bit version of 10g XE, am I right? And the installation file is called "oracle-xe-univ-10.2.0.1-1.0.i386.rpm". I want to install it on Centos 6.4 64bit. But during the ...
0
votes
0answers
37 views

Jobs owner schema has been changed after restore database using oracle expdp and impdb

I have taken oracle database full backup using expdp utility from 32 bit linux server. Then I have restored this full backup in 64 bit linux server and it was successfully restored. The problem what ...
0
votes
0answers
150 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
0answers
607 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 ...
0
votes
0answers
320 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 ...
0
votes
0answers
477 views

How to detect when did ocurre ORA-00604?

Today, between 3:00pm-3:30pm, my Oracle 10g database on Windows hanged on twice. Error messages were related to ORA-00604. I'm pretty sure it was some query or queries that some user run as owner of ...
0
votes
0answers
133 views

How to load XML data into an oracle db table ?

Is there a way to load the XML format data into an Oracle 11g DB table directly ? I mean, Can we write a Stored Procedure to accomplish the same in a more efficient way with the best performance ? ...
0
votes
0answers
402 views

Problem in exporting users from oracle database. (Oracle 10g express edition)

I am trying to export the user from database, but its showing export done in we8mswin1252 character set and al16utf16 nchar character set But if i am trying to export entire database then its ...
0
votes
0answers
683 views

RMAN Error ( 00601, 03004)

Please help on this RMAN error: RMAN> backup database plus archivelog; Starting backup at 08-MAY-12 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=297 devtype=DISK ...
0
votes
0answers
164 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?
0
votes
0answers
295 views

Reconfigure the registry for new Oracle installation

I have the following oracle homes installed on my Windows machine Oracle Developer Suite Oracle Discoverer Oracle 10G Client. I installed Oracle 10G database manually by following the following ...