Questions tagged [oracle-10g]

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

Filter by
Sorted by
Tagged with
-2 votes
0 answers
12 views

How to compare results that saved in table columns

I have two tables like below: Besides that, I have two different lists of rules I need to check to make the decision: A: I need to check rule 1, 2 in the table 1 and rule 1 in the table 2 B: I need ...
tnddld's user avatar
  • 1
-3 votes
1 answer
47 views

MYSQL workbench like gui tool for oracle 10 g or more

I am a java full stack developer who want to write oracle sql queries to simplify writing is there any mysql workbench like similar gui tool for oracle by oracle or any other please sugest
Maddy plus plus's user avatar
0 votes
0 answers
9 views

Oracle 10.2.0.4 instance won't load after system reboot on Windows 2012 R2 server

I know it's prehistoric software but I have some legacy apps that require it. When installing Oracle database 10.2.0.4 on a Windows 2012 R2 server 64 bit system everything works perfectly until I ...
Vaiks's user avatar
  • 1
1 vote
1 answer
306 views

What are the ways to recover Oracle database that has corrupted data file, very old RMAN full backup, and incomplete/corrupted archived logs?

For an Oracle 10g/11g database that refuses to start due to datafile (SYSTEM01.DBF) corruption, does RMAN restore command immediately overwrite all current datafiles from the last found full RMAN ...
clj's user avatar
  • 11
0 votes
0 answers
15 views

How to Drop datafile oracle10g noarchive mode?

I want to drop datafile that is empty. So, I googled and found how to drop datafile that is Offline drop Recover Change status to online Finally drop datafile I did offline drop and status is ...
user avatar
1 vote
0 answers
231 views

oracle is gather statistics globally when granularity level is partition

I have the following function to gather statistics. FUNCTION generate_stats(tabelname IN VARCHAR2 ) RETURN NUMBER IS current_user VARCHAR2(100); BEGIN ...
user avatar
-4 votes
1 answer
34 views

create a oracle database user with no object in tablespace [closed]

Create user Sara with a password of sara. Make sure that any objects not created in the system tablespace and Sara can log in and create objects up to 10M in size in the MYUSERS. how to create a ...
005 maira sultana's user avatar
0 votes
1 answer
63 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 ...
Nadeem Taj's user avatar
-1 votes
1 answer
168 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 ...
setare's user avatar
  • 1
0 votes
1 answer
263 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 ?
PollusB's user avatar
  • 329
0 votes
2 answers
342 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 ...
Hakan Kara's user avatar
0 votes
1 answer
13k 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 ...
Yong's user avatar
  • 15
-2 votes
1 answer
155 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
KPS's user avatar
  • 3
1 vote
3 answers
6k 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 ...
Darcy Dommer's user avatar
0 votes
2 answers
206 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 ...
user avatar
0 votes
1 answer
2k views

Oracle Can a Dropped View Be Recovered?

I dropped a view 20 minutes ago. Can I recover it? If yes, how?
phileoseda's user avatar
0 votes
1 answer
2k 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 ...
Santhoshkumar Sivaji's user avatar
6 votes
1 answer
832 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 ...
DavidN's user avatar
  • 163
0 votes
1 answer
415 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 ...
A. Cifuentes's user avatar
0 votes
1 answer
344 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 ...
ArnauVJ's user avatar
  • 11
1 vote
0 answers
56 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 ...
munHunger's user avatar
  • 121
4 votes
2 answers
2k 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 ...
Fredric Shope's user avatar
0 votes
1 answer
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 ...
Sameer Pradhan's user avatar
1 vote
1 answer
2k 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 ...
Gerrat's user avatar
  • 137
0 votes
1 answer
4k 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 ...
Sandhya Krishnan's user avatar
-2 votes
2 answers
2k 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.
iHateBugs's user avatar
1 vote
1 answer
68 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 ...
Manu's user avatar
  • 113
0 votes
1 answer
106 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.
fetch_execute_break's user avatar
0 votes
1 answer
107 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 ...
minusnine's user avatar
2 votes
2 answers
342 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 ...
Eka's user avatar
  • 23
0 votes
1 answer
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 ...
hunterjrj's user avatar
  • 131
0 votes
1 answer
76 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 ...
fetch_execute_break's user avatar
1 vote
1 answer
1k 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 ...
themaniac27's user avatar
0 votes
1 answer
1k 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?
Marinaio's user avatar
  • 197
0 votes
1 answer
15k 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 ...
Abstract Circle's user avatar
0 votes
3 answers
191 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] ? ...
John Edward Law's user avatar
2 votes
3 answers
9k 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 ...
EAmez's user avatar
  • 135
0 votes
1 answer
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 ...
zenami's user avatar
  • 11
0 votes
1 answer
48 views

Why the length of JOBHISTORY field is 172 here?

It should be 150. Is Varray allocating some extra space?
Parth Mangukiya's user avatar
0 votes
1 answer
662 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/...
manix's user avatar
  • 385
0 votes
1 answer
931 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 ...
Álvaro González's user avatar
0 votes
1 answer
173 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 ...
user3121138's user avatar
0 votes
1 answer
5k 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?
Ramiz Tariq's user avatar
1 vote
0 answers
801 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 ...
Dave Smylie's user avatar
1 vote
1 answer
7k 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 ...
ahmd's user avatar
  • 19
1 vote
0 answers
773 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 ...
Mayank's user avatar
  • 11
1 vote
2 answers
4k 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 ...
zenami's user avatar
  • 11
1 vote
0 answers
3k 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, '...
Yuriy's user avatar
  • 128
-1 votes
1 answer
361 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 ...
Imad Belmoujahid's user avatar
0 votes
1 answer
487 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?
Nick Silicon's user avatar

1
2 3 4 5
8