Questions tagged [oracle-10g]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
32 views

When to perform which type of incomplete recovery?

This is purely learning purpose, that which incomplete recovery type is use in which condition? And DBA is bound to choose one or can choose anyone of following Incomplete recovery type? Scn-based ...
-1
votes
1answer
57 views

TNS 12545, 00511. Oracle not start

I have a Linux server that has oracle 10g release 10.1.0.3.0 and NMS software. I need to change its IP address and default gateway. So: 1- While oracle and NMS are started I change IP and default ...
0
votes
1answer
49 views

How to check if a client can use windows authentication

My ORACLE (10g) sqlnet.ora has SQLNET.AUTHENTICATION_SERVICES=(NTS). I need to validate that no client is using Windows authentication to connect. What can I check next to make sure they don't ?
0
votes
2answers
174 views

Is it possible to attach Oracle database files after a clean install

I had an Oracle 10g instance on my Win2008R2 server. Unfortunately, the server crashed and we had to re-install the operating system on the C: drive. The oracle files are on drives other than C. The ...
0
votes
0answers
73 views

Compare previous column and current column in ORACLE SQL and do SUM

This is my query to get TIME_DIFFERENT-> TO_CHAR (DATE '1900-01-01' + ABS ( LAG(MODIFIED_DATE,1)OVER(ORDER BY MODIFIED_DATE DESC) - MODIFIED_DATE), 'HH24:MI:SS') AS TIME_DIFFERENT Now, I want to ...
0
votes
1answer
5k views

ORA-00932: inconsistent datatypes: expected CHAR got NUMBER

I am trying to SUBSTR the first 3 character in use this query -> CASE WHEN (RMSTMP_PNG.ota_activity_lotinfo.KEY = 'TestProgram') THEN TO_CHAR(SUBSTR(RMSTMP_PNG.ota_activity_lotinfo.VALUE,1,3)) ELSE ...
-2
votes
1answer
46 views

SQL for previous value in column for last 30 days [closed]

I'm looking for SQL which give me the job, present position, previous position, change date for last 30 days... Much Appreciated.. Thanks
1
vote
2answers
3k views

Can an Oracle 19c database dblink to an Oracle 10.2.3 database?

I have an Oracle 12.1.0.2 database that dblinks to an Oracle 10.2.0.3.0 database. I am upgrading the Oracle 12.1.0.2 database to 19c (12.2.0.3). Will my dblinks to the Oracle 10.2.0.3.0 database ...
0
votes
2answers
95 views

How to increase the maximum number of control files?

ORA-00208 number of control file names exceeds limit of num Cause: An attempt was made to use more control files than Oracle supports. The limit is given in the message. num = 8. I ...
0
votes
1answer
652 views

Oracle Can a Dropped View Be Recovered?

I dropped a view 20 minutes ago. Can I recover it? If yes, how?
0
votes
1answer
825 views

How to query Last inserted row for each group in oracle 10

I have two tables about users where I want to join two tables and show the latest remarks of each user bellow is table I want to query the latest remarks for each user (1 remark per user) bellow ...
5
votes
1answer
450 views

Is using association tables for One-to-Many relationships common practice?

I'm currently running into a conceptual disagreement with some database architects at work. My education in this field is purely from the UofGoogle so I'm sure they're right, but can't find ...
0
votes
1answer
307 views

Sqlplus not using NLS_LANG env variable

I am trying to login to an Oracle 10g database vía sqlplus. In the nls_session_parameters I need NLS_DATE_LANGUAGE in American, but I always have Spanish. In the database server my NLS_LANG is ...
0
votes
1answer
257 views

Oracle 10g Database Locking Session Issue

I have a problem with locking and not timing out in one of my Oracle databases. This session locks occur on certain transactions that come from Oracle Forms users. For instance, when some user ...
1
vote
0answers
53 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 ...
4
votes
2answers
1k 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
3k 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
1k 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
3k 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 ...
-2
votes
2answers
847 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.
1
vote
1answer
56 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
1answer
51 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
79 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 ...
2
votes
2answers
86 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
1k 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
41 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
957 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
853 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
11k 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
3answers
160 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] ? ...
2
votes
3answers
8k 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
2k 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
43 views

Why the length of JOBHISTORY field is 172 here?

It should be 150. Is Varray allocating some extra space?
0
votes
1answer
625 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
746 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
149 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
4k 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
619 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 ...
1
vote
1answer
5k 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
568 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
3k 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
2k 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
260 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
377 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
43 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 ...
7
votes
2answers
22k 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
725 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
5k 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.
2
votes
1answer
13k 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 ...
1
vote
2answers
1k 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
2 3 4 5
8