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
1 answer
12 views

Oracle 10g impdp without REMAP_TABLE

I have the following question, and I don't know what the best way to proceed would be. I have an Oracle 10g server, and a schema table has become unusable due to operator failures. So I had to do a ...
fah81's user avatar
  • 13
-1 votes
2 answers
23 views

Oracle 10g On Windows Hard-Disk Crash

We had a hard-disk crash of our legacy application on Oracle 10g database server. We were later able to recover all the files in oradata directory. We do not have any recent export files. I had ...
Ade's user avatar
  • 1
0 votes
0 answers
498 views

how to solve error cannot communicate with CRS daemon?

I have oracle 10g 2 nodes RAC database , operating system HP UNIX Electricity shut down 1 hour and database servers also shutdown after start the servers database not running and show the error when ...
Abdullah's user avatar
  • 111
-3 votes
1 answer
60 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
11 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
580 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
1 vote
0 answers
277 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
49 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
77 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
210 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
336 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
468 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
16k 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
227 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
7k 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
231 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
1k 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
503 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
374 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
75 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
128 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
118 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
478 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
133 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
16k 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
213 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
  • 155
0 votes
1 answer
3k 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
671 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
984 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
176 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
860 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
824 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
424 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

1
2 3 4 5
8