Oracle Corporations version 10 of its flagship RDBMS product.

learn more… | top users | synonyms (1)

0
votes
1answer
7 views

Can't connect using SqlManager for Oracle, but Sql+

I'm using EMS Sql Manager for Oracle to connect to some Oracle databases but I receive the error ORA-12154: TNS:could not resolve the connect identifier specified I just re-setup my PC, due to SSD ...
2
votes
1answer
286 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
11 views

What does a green icon mean and why do the package bodies not expand when they have it?

In SQLDeveloper 4 some 10g PL/SQL packages have a regular crate while others have a green dot. Those with the green dot do not expand their bodies (might be just a coincidence). What is the ...
0
votes
0answers
13 views

Special characters in Oracle utl_http request

When calling a web service using utl_http, the calls fail when the SOAP envelope contains characters like ¿, ± or º. IS http_req utl_http.req; http_resp utl_http.resp; request_env ...
0
votes
1answer
37 views

Oracle Recovery

Oracle server died. Built a new VM and mapped out the volumes to the SAN. Installed the same version of Oracle on the new server and applied the same patches. How can I "register" or "attached" the ...
0
votes
0answers
35 views

question on oracle query performance/tuning

we have a query with large union all with a lot of tables. If that query gets hung up, it will hold up alter statements on those tables we should break the query up into individual ones to minimize ...
0
votes
1answer
139 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 ...
0
votes
1answer
48 views

Table statistics on database

Is there any way that I could find how many tables has statistics on them,and how many tables which doesn't have statistics on them.
0
votes
2answers
395 views

How can I find who has allocated a user lock via dbms_lock?

We have a print queue process that acquires a user lock via dbms_lock.allocate_unique. It performs the work and then releases the lock. The process works very well. Today, we have a process that ...
1
vote
1answer
175 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, ...
0
votes
2answers
37 views

How to remove duplicates and merge tables properly? [on hold]

I'm creating a data warehouse for a healthcare company. They have separate databases for different hospitals which contain tables on patients,their insurance,etc and PK is unique only within one ...
0
votes
1answer
22 views

Unable to create Central Inventory

I am Traying to install Oracle 11g on my Linux a have alrady config the varible and X-host but can,t able to Create Central Inventory my Central Inventory location is : /u01/app/u0 ** and ...
1
vote
1answer
676 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 ...
3
votes
1answer
463 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) ...
0
votes
1answer
34 views

How to get desired type of records for desired number of times in oracle

I want to get get 6 "double_scoring" records and 4 "singe_scoring" records from my Profiles table based on SCORING_RULE column values. Can you please let me know how can I do this with SELECT query ...
0
votes
1answer
222 views

Exporting from Oracle enterprise edition to standard edition reaches schemas limit

So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink. It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers ...
0
votes
1answer
28 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
43 views

General question on dbms_stats

General question on dbms_stats and auto sample size? what is the impact of having IOTs with overflows and you switch to auto_sample_size and enable approximate NDV . How does it impact?
0
votes
2answers
161 views

What is the difference between Schema and Database in Oracle?

In oracle, Datafile are system files where actual data is stored.The collection to datafile make Tablespace and atlast database is collection of tablespaces Correct me if I am wrong on the concepts ...
1
vote
0answers
38 views

Testing equivalence in strings with different character sets

I have to synchronize a number of tables with string columns between two databases: the source Oracle 10.2.0.3 NLS_CHARACTERSET WE8MSWIN1252, NLS_LENGTH_SEMANTICS BYTE the destination Oracle ...
2
votes
1answer
172 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 ...
1
vote
1answer
59 views

Object changed during datapump

If some object is being changed when data pump is run how will that object go into datapump file?
1
vote
1answer
72 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 ...
2
votes
3answers
20k views

oracle: No more data to read from socket

We are using Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 and we have an error on a query that gives us the error Error: No more data to read from socket SQLState: null ErrorCode: ...
0
votes
1answer
93 views

How to know which process is causing high memory usage on DB?

I've got one Onesight alert mail stating below: Short Description: Onesight Alert: ZEUS DB Monitor (zeus04) Description: Solaris 5.8: vmstat memory(free) - Free Memory for zeus04 2065112 8:06:02 ...
0
votes
3answers
47 views

Invalid create index syntax

I cannot create index with the where clause. Refer the below query: CREATE INDEX c_bplocation_isdefault ON c_bpartner_location (ad_client_id,c_bpartner_id,isdefault) WHERE isdefault = 'Y';
0
votes
0answers
33 views

My stored procedures often get invalidated

The reason for invalidation should be because of some DDL activity, but I don't have any DDL in the SPs. I need to find what is that DDL statement. If the object is in an invalid state, when you call ...
0
votes
1answer
925 views

Oracle 11gR2 IMP Won't Import Table in Dump File From 10g

I've got a screwy problem using imp on an Oracle 11gR2 instance to try and import export files created with exp on an Oracle 10g instance (different hardware, if that matters). I've read through the ...
0
votes
0answers
38 views

ORACLE 10.2.0.5 DB: How can I start replication of an existing schema into a new database with zero downtime

Please, note that I'm limited to Materialized view replication and datapump, so my question is whether the above can be done within my specified scope: Ensure no transactions in the database for ...
0
votes
1answer
28 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...
2
votes
3answers
9k views

Clone / Copy Oracle 10g & 11g

Hi I am absolute begginer in Oracle domain. I would like to learn way how to clone copy oracle database to som backup, use this backup on another server. Oracle is installed on Windows server 2003. ...
0
votes
2answers
1k views

Dividing comma separated strings into columns

I have a problem with dividing comma separated values. I have 2 columns with comma separated values, for ex: ID Name 1,2,3 Ab,cd,ef I want the columns divided as: Id Name 1 ab 2 ...
0
votes
0answers
9 views

Improving the performance of this select query [duplicate]

i have two tables TABLE 1 and TABLE 2 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 ...
1
vote
1answer
242 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 ...
1
vote
1answer
35 views

oracle database upgrade issue

Currently i'm using Oracle 10g XE database and want to upgrade to Oracle 11g XE. When i try to run the installer, it fails because of running instance. I searched the internet and got to know i have ...
0
votes
0answers
45 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
256 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
47 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 ...
-8
votes
1answer
57 views

Grouping Row Values Query [closed]

How can I write a query to get the result below from the sample data given? Data in table EMP is as below: Empid Empname Sal Comm 100 ABC Null 20 100 ABC 20000 null Output should be: Empid ...
0
votes
0answers
31 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 ...
1
vote
1answer
122 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 ...
1
vote
1answer
168 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: ...
0
votes
1answer
70 views

Oracle 10g: same query, different plans on copies of the same DB

I have a query joining a number of long tables (primary key in one table, indexed column in another) which results in different plans on different copies of the same database. The structure of copies ...
0
votes
0answers
120 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 ...
1
vote
1answer
125 views

Oracle temporary table usage with XA

I'm confused about the compatibility of Oracle XA with global temporary tables. I've read several places on the internet and in the oracle documentation that say "Distributed transactions are not ...
0
votes
0answers
67 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
871 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
1answer
52 views

Find when Oracle 10g table was last populated

I am working on an Oracle 10g database which is being populated periodically with data from network nodes. What Oracle table can I query to to get the time at which myTableOfInterest was last ...
0
votes
0answers
29 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
60 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 ...