Questions tagged [oracle-10g]
Oracle Database 10g (not 10g R2). Please also tag oracle for search purposes.
392
questions
-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 ...
- 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
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 ...
- 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 ...
- 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 ...
root
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
...
Rustam
-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 ...
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 ...
- 93
-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 ...
- 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 ?
- 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 ...
- 101
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 ...
- 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
- 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 ...
- 13
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 ...
Prog Man
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?
- 101
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 ...
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 ...
- 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 ...
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 ...
- 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 ...
- 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 ...
- 604
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 ...
- 129
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 ...
- 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 ...
-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.
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 ...
- 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.
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
...
- 67
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 ...
- 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 ...
- 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 ...
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 ...
- 113
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?
- 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 ...
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] ? ...
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 ...
- 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 ...
- 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?
- 101
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/...
- 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 ...
- 1,059
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 ...
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?
- 123
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 ...
- 135
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 ...
- 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 ...
- 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 ...
- 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, '...
- 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 ...
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?