Oracle Corporations version 10 of its flagship RDBMS product.

learn more… | top users | synonyms (1)

1
vote
2answers
58 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 ...
1
vote
2answers
538 views

Oracle Databases - need to export nightly for backup/DR purposes

I know nothing about Oracle databases, so if my question's path seems odd, feel free to tell me the right way to do things. I have 2 ways I see currently that I can backup a server running 3 Oracle ...
1
vote
2answers
249 views

Join on clustered tables shows greater cost than non-clustered tables?

I have created a cluster and have two tables emp and sep on the cluster. When I do the simple query... explain plan select * from emp_cluster join dep_cluster using (dno) the cost is 26. I ...
1
vote
1answer
2k views

How do I determine if FORCE LOGGING is on for the entire database?

How can I determine if force logging is on, at the database level. (Not asking about finding out if force logging is on for particular tablespaces.) What rights are needed to perform the check of the ...
1
vote
2answers
564 views

Analyzing an Oracle dump

I have a full Oracle dump, I know I have to imp the dump with the fromuser touser clause. However, I don't know the names of the schemas included in the dump. How can I open the dump created with ...
1
vote
1answer
5k views

Cleaning Oracle In-Active Sessions

There a are huge number of in-active sessions persisting in our database.How can we clean these in-active sessions? Database - Oracle 10g R2 with ASM DB Size - 5TB SGA - 78GB PGA - 10GB Maximum ...
1
vote
1answer
110 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 ...
1
vote
1answer
270 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
295 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
2answers
146 views

Strange Oracle ORDER BY

I have a problem sorting strings in french : This is my query : SELECT LIBELLE as LibelleCourant, CODE as code FROM S_MARQST ORDER BY LibelleCourant; And this is the result LIBELLECOURANT ...
1
vote
1answer
176 views

Slow join behaviour with 'or' in predicate

I'm faced with a situation which I can't understand and overcome. In short we have left-join query like: select from a left join b on a.key1=b.key1 or a.key1=b.key2 This works VERY slowly, while ...
1
vote
1answer
56 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.
1
vote
2answers
541 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
2k views

ORA-12541: TNS:no listener using EXPDP

I need to export an Oracle 11g database to an Oracle 10g instance. I have the command, which I believe is correct: expdp user/pass@192.168.10.8 full=Y VERSION=10.2 directory=m_dump ...
1
vote
2answers
3k 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
447 views

This refactoring from cursor on a dblink'ed Oracle table OK?

The data is being compared from the local version of the table to one in the contracts linked server. I'm not certain what the goal of this code is in the first place, but I'm trying to get a handle ...
1
vote
1answer
563 views

Enterprise Manager Database Control on host with an underscore in it's name

I know it sounds awkward, but Enterprise Manager is refusing to be set up because of an underscore in the server name: C:\>emca -deconfig dbcontrol db -repos drop STARTED EMCA um 30.05.2012 ...
1
vote
1answer
634 views

ORA-07445: An unexpected error: core dump

We use oracle 10g. We found the following error in a trace file: *** 2012-05-07 11:50:56.421 ksedmp: internal or fatal error ORA-07445: An unexpected error: core dump [ACCESS_VIOLATION] ...
1
vote
1answer
4k views

restore database from dmp file

I have a situation: I have a dmp file and a database with old data server crashed and the latest data we have ar in the dmp file! we managed to pull the server back but it has old data! so we need to ...
1
vote
1answer
4k views

Materialized view taking too much time

i create a materialized view fast refresh. it takes almost 45 min to create but it did not refresh in 24 hours. i tried it on with index and without index. i check the log of all table max record in ...
1
vote
1answer
498 views

Oracle Backup and Recovery

My backed up archivelog file format is 'al_%U'. During recovery it shows the following error: RMAN-06054: media recovery requesting unknown log: thread 1 seq 17 lowscn 671075 How to determine which ...
1
vote
1answer
90 views

Finding parameter names for binding stored procedure parameters

For unit testing purposes I am attempting to call the DBMS_OUTPUT.PUT_LINE procedure from c# using parameters that are bound by name. Since this DBMS_OUTPUT package seems to be a standard on Oracle ...
1
vote
1answer
214 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
269 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 ...
1
vote
1answer
63 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
92 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 ...
1
vote
1answer
57 views

Oracle 10 column name resolution

For example (just to illustrate the problem), CREATE TABLE test_join(ID INT NOT NULL); --1 SELECT ID FROM test_join A INNER JOIN test_join b ON 1=1; --2 SELECT ID FROM test_join A INNER JOIN ...
1
vote
2answers
248 views

Get a number nth bit value in oracle

How can I get nth bit value in oracle database? I am currently using this query: WITH a AS (SELECT 7 val FROM DUAL) SELECT CASE BITAND (a.val, POWER (2, n-1)) WHEN 0 ...
1
vote
1answer
47 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. ...
1
vote
1answer
646 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 ...
1
vote
1answer
55 views

Supporting Multiple Oracle Clients

I have an application where the data repository is moving to Oracle 11g. This means we need the new Oracle 11g client on the application server to support the retrieval of their data. Is it ...
1
vote
1answer
434 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?
1
vote
1answer
418 views

Using a sequence created in the same script in Oracle

SQL Server developer working on Oracle so apologies in advance if I'm fundamentally coming at this incorrectly from an Oracle perspective. I've got a script I've written which: Checks ALL_SEQUENCES ...
1
vote
1answer
554 views

How to create an UTC index from a 'DATE' typed column with Oracle?

I have a Oracle database with columns of type 'DATE' which store timestamps in local time zone. I need to query this column with timestamps in UTC timezone. How do I create an index on the column ...
1
vote
1answer
330 views

How to implement a low resource privileged user on Oracle 10g using Resource Manager?

In my database I have users and their respective grants using the least amount of privileges principle. How do I start taking advantage of resource manager to prevent users from hogging all the ...
1
vote
1answer
6k views

Read Oracle BLOB type via SQL

I have an oracle table with field type BLOB, length 4000, data type "2004". I know that this field simply contains some XML. How can I read the value of the BLOB, using an SQL select statement? Is ...
1
vote
1answer
7k views

What to do with those invalid JAVA CLASS object type objects in SYS prior to the upgrade the oracle db from 10g to 11g?

I am ready to upgrade the oracle 10g prod db to 11g, but we have 130 invalid objects in SYS (all are belong to JAVA CLASS object_type). And from the best practice of oracle upgrade from 10g to 11g, it ...
1
vote
1answer
69 views

Am I using the correct data types on SQL Server side to call an Oracle 10g function?

When calling an Oracle function with the following in parameter types NUMBER(7,0) VARCHAR2(8 BYTE) VARCHAR2(4 BYTE) DATE and return type NUMBER(14,5) from SQL Server 2008R2 via a linked Oracle ...
1
vote
1answer
126 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
vote
1answer
716 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
214 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 ...
1
vote
1answer
175 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 ...
1
vote
1answer
357 views

ORACLE file I/O withouth explicit flushing on 10g and 11g

what happens, if I open a file (foo := utl_file.fopen(... ), write multiple times to a file ( utl_file.put_line (foo,bar) ) and close it ( utl_file.fclose(foo) ) without any flushing? Is there a ...
1
vote
1answer
190 views

Customizing nls_sort and nls_comp in Oracle

There is different letters for 'KAF' (ک , ك) and 'YA' (ی , ي) in Persian with different unicode codes and same spell. I am using these commands to set Persian sort and comparing in my project ALTER ...
1
vote
1answer
106 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 ...
1
vote
1answer
241 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 ...
1
vote
3answers
582 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 ...
1
vote
1answer
4k 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
1answer
1k 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
401 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 ...