Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle-10g]

Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.

1
vote
0answers
50 views

Different operations in different databases

So I have just executed EXPLAIN PLAN FOR on the same query in two databases that I've been told are identical in every regard except for slight variations in data amount. And the result of it seems ...
3
votes
2answers
97 views

How are these null values stored in a NOT NULL column?

We are replicating tables from SAP ECC 6.0 on HANA into an Oracle 10g warehouse, using SAP SLT. Since starting this, we have noticed the NOT NULL column definitions from HANA are retained in the ...
0
votes
1answer
38 views

Is it feasible to escape ' (single quote) with ESCAPE clause, if yes, then how to do it?

I understand that we can use '' to escape a single quote in Oracle queries. However, I want to know if it is feasible to escape a single quote in the ESCAPE clause. set up: create table test_t ( x ...
1
vote
1answer
43 views

What is the proper procedure for fixing materialized view replication?

Oracle 10 Standard: I have a number of materialized views built on pre-built tables. These are fast refreshed from a remote database over a link from one master db. They've generally been working ...
0
votes
1answer
47 views

Unable to connect to oracle database. Getting ORA12505 error

I am newbie to ORCALE I am trying to connect to oracle server and i am getting this error. This is was working fine before but now i am facing this issue. Need help An error was encountered ...
0
votes
0answers
17 views

Unable to connect to oracle database. Getting ORA12505 error [duplicate]

I am newbie to ORCALE I am trying to connect to oracle server and i am getting this error. This is was working fine before but now i am facing this issue. Need help An error was encountered ...
-2
votes
2answers
84 views

Adding sequence number to existing rows based on ID and Date in PLSQL Oracle [closed]

I want to add a sequence number (SEQNO) based on their REFNO and STARTD.
0
votes
1answer
52 views

Migrating Oracle 10g on Solaris Sparc to Linux RHEL 5 VM

if i will rate my oracle expertise i would give it 3/10. i just started learning oracle, solaris and linux 2months ago and was given this task to migrate. yes our oracle version is quite old and might ...
1
vote
1answer
49 views

Finding which DATE columns have no time data using TRUNC

I'm in the process of converting an Oracle db to a PostgreSQL one. The script I used converted all Oracle's DATE columns into TIMESTAMPS, but I suspect that most of those do not hold any time data ...
0
votes
0answers
9 views

Problems with Oracle analytic function LAST_VALUE

I have a table like this: ID | Val | Ord --------------------- 1 | 1000 | 1 1 | 1000 | 2 1 | 2000 | 3 1 | 2000 | 4 1 | 2000 | 5 1 | 1000 | 6 1 | 1000 | ...
0
votes
0answers
53 views

ORA-23412: master table's primary key columns have changed

In my oracle database i am trying to create materialized view from master table which is present at remote database using database link.But i am getting above error.I don't have any changes in master ...
0
votes
1answer
42 views

How to determine the biggest float value (in terms of used bytes) with SQL in Oracle?

I would like to know how to check out what is the biggest float value in terms of used bytes in a specific column. Oracle DB Version is 10.2.
0
votes
1answer
48 views

Oracle optimizer wrongly estimates cardinality as 1 for public synonyms

I have this query: SELECT d.devicename, d.template, d.deleteflag, SUM(isUnexpected(gv.value,sv.param1,sv.param2,sv.comparator,sv.operator) ) totalDeviation FROM vm_wells_situ s ...
0
votes
0answers
26 views

Add multiple rows in a single row with different columns with a date field

This question comes from another one which was solved Question link In this case I would like to add a new field to the table: date_reading Read_Id Register_Id Date 011 331 ...
2
votes
2answers
55 views

Add multiple rows in a single row with different columns

I want to join two tables (they are called Registers and Reads). As a result I would like to obtain 4 columns, corresponding to Registers ID. According to the next example, by joining the tables, I ...
0
votes
1answer
236 views

Unable to query remote schema object using partial database link name

I came across a very interesting situation today and I'm putting this question to the community in hopes that someone can explain why this happened. I haven't been able to find an explanation in ...
0
votes
1answer
32 views

List all used data types of a table or whole database in Oracle DB

I am preparing a migration from Oracle DB to a SQLite DB. I would like to know all used datatypes in the Oracle DB so I can check out the equal datatypes in SQLite. I am sure using Information_Schema ...
1
vote
1answer
229 views

Oracle 10g Listener issues after IT changed computer domain name

I need some help here. We have Oracle 10.2.0.5.0 installed on a windows 2008R2 machine. The issue is that our IT department changed the domain for that machine. I tried editing our tnsnames.ora and ...
0
votes
1answer
268 views

Where can I download oracle 10g software for solaris?

I need 10g RAC software (Solaris 11 SPARC) for an audit. It's no longer on OTN. I've opened an SR, but it is taking forever then they gave me the wrong O/S. Do you know of any other place to get it?
0
votes
1answer
2k views

ps-ef|grep pmon (Instance Name Only)

When i issue a "ps -ef|grep pmon", I get the below output. oracle 230330 1 0 Jan08 ? 00:01:14 asm_pmon_+ASM1 oracle 244018 1 0 Jan08 ? 00:00:59 ora_pmon_vbsenopd ...
0
votes
1answer
43 views

Command Line Creation of a new 12g Oracle Database

I am new to creating an Oracle database using the command line. I am logged in as superuser; now I would like to create a new blank database, "mynewdatabase". $ . oraenv ORACLE_SID = [oracle] ? ...
1
vote
2answers
2k views

System account locked, insufficient privileges to log in as sysdba

I've researched the web but I could not found exactly the same situation than mine so I'm posting this message. I'm connecting via Remote Desktop Connection to a remote server (Win2k3 Server). This ...
0
votes
1answer
921 views

ORA-01031: insufficient privileges while connecting with sys as sysdba

I installed Oracle database 10g as an administrator on a windows 10 machine, it worked fine, but when i try to connect sys as sysdba it gives me the error: ORA-01031: insufficient privileges I ...
0
votes
1answer
36 views

Why the length of JOBHISTORY field is 172 here?

It should be 150. Is Varray allocating some extra space?
0
votes
0answers
337 views

replication_dependency_tracking turned off (no async multimaster replication found)

Startup failed,What is the solution? Instance terminated by PMON, pid = 956 Wed Nov 01 10:21:55 2017 Adjusting the default value of parameter parallel_max_servers from 320 to 135 due to the value of ...
0
votes
1answer
275 views

Running forms in Oracle Cloud Service

Since few years ago I have worked and extending a application build by Forms Builder 10g and running via Oracle Application Service 10g. The application can be launched as: http://portal.dev:7778/...
0
votes
1answer
212 views

Migrate database through database link

There's a database called FOO in an Oracle XE 10g server that's due to be decommissioned (old.example.com). I've been asked to migrate it to some other Oracle XE 11g server (new.example.com). Both ...
0
votes
1answer
87 views

How to use SQL*plus from standard user in Windows Vista to run sql query to Oracle10g on my server?

i have a bach file it contain: @echo off sqlplus x/y@z @run.sql for execute this code correctly i have to execute this file from administrator user from my client, for some reason i need to run ...
0
votes
1answer
1k views

How to rebuild SYSAUX corrupted tablespace?

I have database 10g 32-bit windows without backup. I want to migrate full database to 11g, but the SYSAUX tablespace is corrupted. Can I rebuild the SYSAUX tablespace?
1
vote
0answers
319 views

Oracle Reports 10g (rwserver.sh) - connecting from a remote server

I have an Oracle Reports server 10g (10.1.0.4.2) that for the last few years has been running okay with the rwclient.sh client application residing on the same host. Due to some performance issues ...
0
votes
1answer
1k views

restore database using impdp full back

I have new server and i installed oracle 10g same like production. and I have databump full backup using sys user. I need to restore on the new server. I used the following command while database is ...
1
vote
0answers
187 views

How to run Oracle Client 10g from non Administrator account?

Hi I have 2 users configured on my Windows 10 Home machine. One is Administrator and another is my own user. Although my user is configured as an Administrator, I can use Oracle Client 10g from my ...
1
vote
2answers
1k views

upgrading Oracle forms and reports 6i to 12c

We are planning a migration of an Oracle Forms and report 6i application to 12c, and at the same time we will upgrade to the latest version of Oracle (from 10g to 12c). I would like to know the ...
1
vote
0answers
359 views

Why TRUNC() date field range constraint is faster?

I have a fairly large (10s of millions rows) Oracle 10g table with a date field in it, which in a number of queries is constrained to a range like this: ... AND date_field >= TO_DATE(:lowerDate, '...
-1
votes
1answer
148 views

Use RMAN to perform an incremental backup strategy

the question is Use RMAN to perform an incremental backup strategy (level = 0.1 and 1 cumulative) of the data files belonging to the SYSTEM and USERS tablespaces. Be sure to also make a copy of the ...
0
votes
1answer
131 views

As an application what are differences between sqlplus.exe and sqlplusw.exe?

Currently i am using Oracle 10g and i can use both sqlplus and sqlplusw. But is there any difference in using them. And, is any of the is deprecated in newer versions?
0
votes
1answer
25 views

ORA--07445 error during online Re-org process in 10.2.0.4 database

I was doing re-org of fragmented tables in an Oracle 10.2.0.4 production database: sys@CLARITY> ALTER TABLE SOP_QUEUE ENABLE ROW MOVEMENT; Table altered sys@CLARITY> ALTER TABLE SOP_QUEUE ...
4
votes
2answers
8k views

impdp stuck on index import

impdp import is stuck on: Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX How can you debug this?
0
votes
1answer
288 views

how to obtain the functionality of LISTAGG function in Oracle 10g?

I need to put output of a query in single line so that I can create a single tar file of all the files. But my database is running on 10g version. LISTAGG would have been very useful in this case. How ...
1
vote
2answers
824 views

Which datatype is used to store video files

I am working on a web application using JSP. I want to ask which datatype(with syntax) is used to store video files in Oracle database.
0
votes
1answer
3k views

How to solve ORA-39710 problem

I've got an Oracle 10.2 database that I need to get up and running. I've googled but now I've run into a problem I don't know how to solve. I've been told the database is a bit FUBAR, so expect many ...
2
votes
2answers
605 views

Time stamp of Active and Inactive session by JDBC

The following explains how exactly the Middle tier handles the connection pool and connections to the DB (Oracle 10g): Inactive session in Oracle by JDBC What I would like to know from DB point of ...
1
vote
0answers
202 views

“Read by other session” wait event occurring in a particular Data Block of a Table

I'm using Oracle 10.2.0.4 with Oracle EBS R12 Application on it. Recently we found sudden slowness in running certain Standard Concurrent Programs. When we check from the Snap_id, we found "User I/O"...
0
votes
1answer
837 views

Why do we need listener for Oracle EBS application server?

I'm using Oracle Application EBS R12 which connects to Oracle DB 10.2.0.4 Why do we need Listener.ora in Oracle EBS Application ? If so, can anyone explain why EBS Application needs it ?
0
votes
1answer
1k views

How to export all tables with user in Oracle 10g Enterprise edition?

I want to take backup of all my tables and the user too in Oracle 10g Enterprise edition and then I want to import it to some other computer. The user is not system I have created another user and all ...
1
vote
1answer
164 views

Create FAST Materialised View in Oracle 10g with ROWID

I want to create FAST refresh the below Materialized view through rowID method. `CREATE MATERIALIZED VIEW XXARG_ACC_ANALYSIS REFRESH FAST ON DEMAND AS SELECT gjb.name "Batch_Name", gjs....
0
votes
1answer
1k views

Creating a Materialized view with fast refresh and on Demand option

create materialized view XXARG_GOKU AS select XDR.GLOBAL_ID XDR.PARTY_ID, XDR.EMAIL_ADDRESS, XDU.CITY_CODE, XDU.STD_CODE, XDU.PIN_CODE_SERIAL_NO from XXARG_DUMMY XDU, XXARG_DRAGON XDR where XDR....
12
votes
7answers
4k views

Composite indexes: Most selective column first?

I’ve been reading about composite indexes and I’m slightly confused about ordering. This documentation (little less than half way down) says In general, you should put the column expected to be ...
0
votes
0answers
472 views

Oracle 10 DB link to SQL Server not working

We are using DB link from Oracle 11g to SQL Server. Now we need the same configuration for Oracle 10g, but it's not working. (The installation is Oracle 10g 10.2.0.4.0 with patch 10g R2 Patch Set 4 ...
6
votes
3answers
149 views

How to count the number of rows by datetime field with the division into time intervals

I'm using Oracle Database 10g. There is a table with information about clients: +----+------+---------------------+ | id | name | registered_at | +----+------+---------------------+ | 1 | ...