Oracle Corporations version 10 of its flagship RDBMS product.

learn more… | top users | synonyms (1)

0
votes
1answer
370 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
90 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
1answer
430 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 ...
0
votes
1answer
62 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
4k 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
73 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 ...
0
votes
1answer
937 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 ...
1
vote
1answer
1k views

Object changed during datapump

If some object is being changed when data pump is run how will that object go into datapump file?
0
votes
3answers
71 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
76 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
0answers
68 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
44 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
1answer
41 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 ...
1
vote
1answer
343 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
1answer
36 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
0answers
794 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
2k 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
71 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 ...
-8
votes
1answer
64 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
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
533 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 ...
0
votes
1answer
213 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
1answer
71 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
0answers
354 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
405 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
52 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
1answer
205 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
4k 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 ...
1
vote
1answer
219 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 ...
-1
votes
2answers
145 views

Fetching Recently added rows from table [closed]

I have the following table structure , name || description || timestamp varchar varchar date time stamp column consists of time the row is added Now i need to fetch the ...
1
vote
1answer
2k 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
617 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 ...
1
vote
1answer
428 views

Oracle views not using indexes [closed]

I am experiencing the unexplainable - at least to me. I have some tables in my production database which have some indexes on. We then have a number of views which merge the data across tables to ...
1
vote
1answer
75 views

Import (imp) not showing final report stats/results

I'm trying to execute an import of a dmp file an not obtaining the final results of the import. It's really weird because i obtained really big files (nohup.out and imp_xxx.log) with the following ...
1
vote
1answer
767 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
768 views

ORA-44001: invalid schema

I have a db dump which containts db dump for three schemas for e.g. alpha bravo charlie in one file, exported through EXPDP. now when i am trying to import these through following command: IMPDP ...
0
votes
1answer
196 views

Connection problem after a big impdp

This morning i had a weird problem just opening the SQL developer i cannot connect to my database. I checked the log file of the impdp operation launched before (14G), all the data is imported without ...
0
votes
0answers
243 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 ...
1
vote
1answer
746 views

Tablespace resize in Oracle 10g

I'm trying to resize a couple of tablespaces but the following query is only valid in Oracle 11g. alter tablespace 2 DATAFILE '/appli2/oracle/xxx/oradata02/xxx_undo_01.dbf' resize 3g; In oracle ...
0
votes
1answer
1k views

Undo tablespace full, how to free it

My undo tablespace is full after some modifications. Las column is % of space used. xxx_undo_01.dbf UNDO 2147483648 16777216 2048 2032 16 0,78 99,22 Now i cannot execute any query ...
1
vote
2answers
76 views

Change all datatypes in a table

I'm migrating a database and i need to change the "container", i don't exactly how to name it. I give an example to keep it clear : old base: VARCHAR2(20 BYTE) new base: VARCHAR2(20 CHAR) I can ...
2
votes
1answer
341 views

How does Oracle 10g use indexes?

I have table called result: CREATE TABLE result (id_graduate NUMBER NOT NULL, id_sml NUMBER NOT NULL, last_update DATE NOT ...
0
votes
2answers
511 views

Changes in Oracle Database implicit conversion rules for select statement

Due to hardware failure after a power outage we had to recreate the database for one of our 3rd party applications from an dumpfile (created via exp). The old hardware had Oracle 10G R2 running while ...
1
vote
1answer
460 views

Oracle OS Authentication only works on certain databases/clients

We currently face a problem where Oracle OS authentication only works on certain client/server combinations. The environment consists of a development client with its own database server (excluded ...
0
votes
0answers
415 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
1answer
2k views

Importing Oracle database from dump where source db filesystem has changed

I'm migrating a database from one server to other. In the migration process we changed the filesystem structure from : /appli2/oradata05/HISTO/ /appli2/oradata06/HISTO/ /appli2/oraredolog01/HISTO/ ...
1
vote
2answers
13k views

Delete an oracle instance, the right way

I want to delete an oracle instance (oracle 10.2.0.4.0) created in the AIX 6.0 OS. I know i can delete all the dbf and ctl files in the Terminal but i thinks that's no the best way to do it. I think ...
0
votes
1answer
1k views

User creation and rights to import a dump

I'm having problems creating an instance of Oracle 10.2.0.4 and importing a dump from other environment. I'm using Oracle under AIX. I used a ksh script and everything goes right except when creating ...
1
vote
1answer
485 views

Drop table without its dependencies and solve block corruption

I have found alert about corrupted block in alert log. Corrupted block belonged to the table named DOCS. Because of I don't have any backup of this database, decided to recreate DOCS table to solve ...
1
vote
1answer
130 views

Does Oracle 10g Express Edition have enough storage? [closed]

I am going to develop a simple library database with less than 10 tables. Each table would only keep text records. The library has about 10,000 volumes of books and about 2,000 members. Would the ...