Oracle Corporations version 10 of its flagship RDBMS product.

learn more… | top users | synonyms (1)

0
votes
0answers
41 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
71 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 ...
5
votes
3answers
6k views

Oracle 10g: Properly using ora_rowscn to detect table row changes (ie, inserts, updates, deletes)

Some research into checking when a table's records were last updated, modified, or deleted has lead me to the pseudo column known as ora_rowscn. First, I do this: select max(ora_rowscn) from ...
-1
votes
2answers
44 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 ...
3
votes
2answers
159 views

How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?

I'm using a Oracle 10g database. I have a big tablespace MYTBS made of a dozen data files (MYTBS_01, MYTBS_02, ...) of different sizes which have been added through the years. Now i have removed very ...
1
vote
1answer
102 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
103 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 ...
0
votes
0answers
124 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 ...
1
vote
1answer
47 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 ...
0
votes
1answer
258 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
0answers
63 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
1answer
112 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 ...
1
vote
2answers
50 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
335 views

Is it possible to automate the configuration of dataguard broker?

We deploy a number of oracle databases every year and a good percentage of them require a dataguard configuration. I've developed a script which is able to perform the database synchronization very ...
0
votes
1answer
331 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 ...
0
votes
1answer
174 views

Communication between two database servers

I have 2 databases running on different virtual servers. I have some database processes running on one node. These processes connect to Database Gateway (PG4MQ) and process the messages. I need to ...
1
vote
1answer
99 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 ...
3
votes
2answers
956 views

Oracle imp crashes without error

I have Oracle 10g XE database locally. I export schema with something like exp %USER%/%PASSWD%@XE statistics=NONE owner=%USER% file=dump.dmp Exp is 10.2.0.1.0 version - so is the DB. Than I take ...
0
votes
1answer
109 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 ...
0
votes
0answers
267 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 ...
1
vote
1answer
194 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 ...
0
votes
1answer
316 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/ ...
0
votes
2answers
1k 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
341 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 ...
16
votes
7answers
7k views

Oracle - Any way to view uncommited changes to a particular table?

I'm debugging through a batch process 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 from another session ...
1
vote
1answer
77 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 ...
4
votes
1answer
12k views

Why Oracle sessions are still alive after two weeks being Inactive

DB: Oracle 10g O/S: Windows Server 2003 64 bits I query list of Oracle sessions generated by web applications (filter by program=w3wp.exe) select * from V$session where UPPER(program) LIKE '%W3%' ...
1
vote
1answer
217 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 ...
0
votes
0answers
143 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
1answer
116 views

Complex Oracle SQL to sum data

I am building a SQL query in Oracle 10g that needs to sum overtime hours for the base table, but needs fields from the parent tables as well. I am looking for the fastest way to build the query. The ...
0
votes
2answers
980 views

Grant permission to execute stored procedure without granting access to underlying table - Oracle

I am new to Oracle (10g), my background is SQL Server. I have a service account that needs permission to execute a stored procedure, but nothing else. I see from here how to add execute permissions ...
0
votes
0answers
120 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
123 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 ...
1
vote
1answer
296 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
vote
1answer
46 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 ...
0
votes
2answers
2k views

Entering command 'sqlplus' results in 'sqlplus: command not found'

I've recently installed Fedora 19 on an older PC, to serve as a test server of sorts. After a lot of hiccups, I was able to install Oracle 10g XE. Because I'm using Linux - which I, admittedly, have ...
1
vote
2answers
131 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
145 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
2answers
180 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 ...
0
votes
0answers
43 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 ...
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
0answers
132 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
1answer
170 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 ...
0
votes
0answers
26 views

Create a schema like an existing schema [duplicate]

I have a existing schema in my database called SCOTT, how can I create a new schema with exactly the same privileges which SCOTT schema is having? Is there any create like or some command to create ...
0
votes
2answers
1k views

Delete rows in parent table based on criteria in child table - Oracle

I have a table B with a foreign key to table A. I want to DELETE some rows in table B, and I also want to DELETE their parent rows in table A. However, the delete criteria is based on table B. The ...
-1
votes
1answer
161 views

Restoring Oracle XE database

I had Oracle 10G XE installed on my Windows machine. The machine got corrupted and I will have to install Oracle again. I did not take a backup in the form of SQL queries. How can I use the old ...
0
votes
3answers
350 views

Getting the employee history of Sales department from HR database in Oracle

I am currently using the 'hr' database with Oracle 10g. You can view the schema diagram over here: http://docs.oracle.com/cd/B13789_01/server.101/b10771/diagrams001.htm#sthref63 What I would like is ...
3
votes
2answers
430 views

SQL*Plus default output format

I have noticed that using the same SQL*Plus client to connect to different Oracle database result in different outputs for the same SQL query. Database 1: C:\Oracle\instantclient_10_2>sqlplus ...
0
votes
2answers
66 views

Difference between the given queries

I am required to retrieve the list of pno ( product_id ) for the products which were purchased by two customers. For this, I have been given two relations which are ( along with the attributes ) as ...
1
vote
1answer
84 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 ...