Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

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

How to find historical sql_id executed by users

I'm trying to find historical sql_id executed by users within interval between snapshot_id from AWR. I'm using the view DBA_HIST_ACTIVE_SESS_HISTORY,DBA_USERS and DBA_HIST_SNAPSHOTS to try find the ...
0
votes
0answers
33 views

Failing to insert into table getting error: ORA-00600: internal error code, arguments: [ktssinseg2]

I am facing problems inserting records into my oracle database 12C R2. I have no Oracle Support. All this time I was able to do inserts into my database, but all of a sudden it is now failing. Below ...
-2
votes
1answer
44 views

Hi everybody, Create table statement in SQL not working!

I am a newbie to DBA and I am trying to create a table of vendors and products. Vendor_Name in second line is underlined and when I hover the cursor over it, it shows me a window of error syntax with ...
0
votes
1answer
24 views

how to select rows where for a column there are two rows one with null and another with non-null value then select only row with non-null value

Column A Column B 117220177 BOOK9488 117220177 NULL 14061 NULL Oracle query for selecting rows: When Column B has two rows corresponding to column A then pick row with non-null ...
0
votes
1answer
27 views

get oracle execution plan by sql_id

Is it possible to get an execution plan of currently running query by sql_id? I couldn't succeed with: select DBMS_SQL_MONITOR.REPORT_SQL_MONITOR (sql_id=>'b3x6apqyskn7x') report from ...
0
votes
3answers
46 views

Resize smallfile tablespace - ORA-01144

I have only 2% free on tablespace UNDOTBS1. It consist from 2 datafiles. When I launch alter database datafile '+DATADF/dbname/datafile/undotbs1.555.23454732' resize 32G; I got : ORA-01144: ...
5
votes
2answers
956 views

Table size grows indefinitely after deleting and then inserting the same data

I create a table and populate it with data: create table tab as select 'value' || level val from dual connect by level <= 10000; If I then delete all rows and insert the same data: delete from ...
0
votes
0answers
36 views

Oracle 12cR2 - Problem When Creating Database Using DBCA

OS: Oracle Linux 7.7 Users: root, grid, oracle, userwithmyname Installed softwares: grid infrastructure with asm in grid user, Oracle 12cR2 in oracle user I created a database in my grid user. It ...
0
votes
1answer
31 views

Scheduled Job Does not work in oracle SQL*PLUS

I am just a beginner in Oracle and can't seem to get this job running :- I want to delete old rows from my database. And created a job as follows :- CREATE OR REPLACE PROCEDURE delete_trips AS ...
0
votes
1answer
47 views

Oracle License question - migration [closed]

Oracle EE 12.1.0.2. I need to migrate an existing (licensed) database from Server A to Server B. Do I need to license Server B during the period of time that both servers are running? The period of ...
0
votes
2answers
54 views

ORACLE TABLESPACE USERS GETS 100% USED

I am facing a problem with oracles users tablespace. It automatically grows really fast. What kind of data is stored there? And what happens when it hits 100% of space used? Is there a solution to ...
0
votes
1answer
42 views

Suppress successful insert statements or review errors on large inserts in Oracle 12c

I have ~130 SQL scripts that INSERT about ~750,000 records into an Oracle 12c database. I have a master SQL that kicks all this off using this template: set termout off set echo off; delete from ...
0
votes
1answer
46 views

How to find missing sequence number in oracle ( Sequence number may recycle within same date or next date) [closed]

I am facing same problem already achieved one. Can you please provide the solution for below problem? I have below table group master groupid from_no to_no 1 00 99 2 ...
-3
votes
0answers
31 views

How to find missing sequence number in oracle ( Sequence number may recycle within date or next day) [closed]

I am facing same problem as the already archieved one. Can you please provide the solution for below problem? I have the below table group master groupid,from_no,to_no 1,00,99 2,000,999 3,0000,9999 ...
0
votes
1answer
45 views

LRM-00101: unknown parameter name '_first_spare_parameter'

I am part-way through an upgrade from Oracle 11g to 18c on RedHat. The Database Upgrade Assistant gives the message: Errors encountered during the execution of "Database Components Upgrade". ...
0
votes
0answers
31 views

Remove/distinct duplicates on listagg - oracle

I'm using the oracle-xe 11g version and I have the below sql code that I aggregation the course code, but the output has duplicates. SELECT b.alu_cpf AS login, b.alu_nomeco ...
0
votes
0answers
21 views

Best practice guidelines for a application table archive in Oracle 12C

Database environment: Oracle 12C Enterprise edition I have a table in the application schema and corresponding history table in the history schema. The application table has about 10 small varchar2 ...
0
votes
1answer
51 views

ORACLE DB literal does not match format string

I' am having this error: ORA-01861: literal does not match format string 01861. 00000 - "literal does not match format string" *Cause: Literals in the input must be the same length as ...
0
votes
1answer
29 views

Cannot dump database in Oracle on Docker

Oracle is working fine on Docker, I can connect from sqlDeveloper with no problem, but I cannot dump the database logging into Docker in the bash command line. Runnung: expdp CONFIG0001-TEST/xxxxxxx ...
1
vote
1answer
82 views

Oracle goldengate service is not starting: Failed to retrieve the name of a missing Oracle redo log

I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped. I need to start goldengate service.. I don't know what ...
0
votes
1answer
38 views

How to find admin user of pluggable database in Oracle 12c up

I'm creating a script and I need to know what is the admin user of pluggable database. I don't find nothing about it in documentation. Other question is, what happen if I drop a admin user of the ...
0
votes
2answers
30 views

TNS-12543: TNS:destination host unreachable

I have a installed oracle 19c but i am unable to login Please refer the following screen shot I am not unable to login which user credential require to login
0
votes
0answers
25 views

Listener does not recognize an instance

We have been running several instances in the past: PUC and PST. Access to PUC is still working but recently I tried to access the PST instance and we get the following message from Listener: D:\app\...
0
votes
0answers
21 views

Oracle XE 18c DBFS_CLIENT auth failing for SYS without SYSDBA privileges

I have been following this tutorial to setup an Oracle DBFS environment for testing. A certain step of the tutorial is pointing to the use of the DBFS_CLIENT: When I try to authenticate on the ...
0
votes
0answers
54 views

Access or modify tnsnames.ora on AWS Oracle RDS

I have an Oracle RDS instance running on AWS and I need to access the tnsnames.ora file and check its configuration since I am getting this error Caused by: oracle.net.ns.NetException: Listener ...
0
votes
1answer
29 views

Oracle INSERT with If statement for values

I'm trying to find a way to put together an INSERT which will insert a column value based on the value of another column, so for exampke INSERT INTO table1 (col1a,col1b) SELECT (dependant of the ...
-2
votes
1answer
38 views

oracle find to first hyphens after last vertical bar

oracle find to first hyphens after last vertical bar using REGEXP_REPLACE SELECT REGEXP_REPLACE ('sadsa|dd|g - g|hh|yyyyy - tttt - ooo', '.*(\|)(?!.*\|).*?\-{1}', '' ) FROM dual; string input '...
1
vote
1answer
58 views

How to migrate Oracle Database to MariaDB? [closed]

Currently we have a server on Oracle version 18. We are planning to migrate to MariaDB. Is there any free service provided by MariaDB or oracle that helps migrate a database from Oracle to MariaDB?
1
vote
2answers
52 views

Oracle database 12c upgrade to 19c

I was asked to advise some business analyst on migration from Oracle DB 12c to 19c. The thing is I have never used or done anything related to Oracle DB. From my experience with MSSQL during upgrade I ...
0
votes
0answers
17 views

Why is the Oracle Goldengate 12g extract working with a heartbeat table HB whithout 'add HEARTBEATTABLE'? [closed]

It is created with a default structure. Does the Oracle GoldenGate have a default heartbeat table? Could You give links to the Oracle documentation? In my company servers it's working without add ...
0
votes
2answers
42 views

Efficient approach to Query DB with data in text file [closed]

I've got an oracle DB set up and want to Query it after I receive data in a text file. Number of product-names present in text file are around a million. After Searching a lot I've found 2 ways of ...
2
votes
1answer
73 views

Nulling a BLOB column in Oracle 11 impdp

I need to import a 50 GB dump file containing three schemas. Over 90% of the file is taken up by a single BLOB column. How could I import the schemas, including the table containing the blobs, but ...
0
votes
1answer
49 views

how to solve ORACLE AUDSYS.SYS space error

I am having this problem "Warning: odbc_connect(): SQL error: [Oracle][ODBC][Ora]ORA-02002: error while writing to audit trail ORA-55917: Table flush I/O failed for log ID: 1 bucket ID: 0 ORA-01691: ...
0
votes
1answer
47 views

SELECT TO_NUMBER('MUST_BE_SAME_TIMEZONE_FILE_VERSION')

I upgrade Oracle from 11.1.0.6.0 (32bit version) to 11.2.0.1.0 (64bit version) using RMAN on the same Windows computer (64bit). After RMAN restored and recovered, I then try to run SQL> startup ...
0
votes
1answer
25 views

How do you delete achieve log image copies that are already backed up?

How do you delete achieve log image copies that are already backed up ? It seems like below command doesn't work: delete copy of archivelog all until time 'sysdate-1' backed up 1 times to disk
2
votes
1answer
36 views

Oracle - impdp - import a partition

I truncated a partition, and would like to import it from backup. How can I import a partition from the dump file? Export log: . . exported "XY_PROD"."XY_LOG_PLSQL" 69.16 MB 320459 ...
0
votes
2answers
48 views

Listener (lsnrctl) reload vs stop/start

Some blogs tell that reload is equal stop and start, but in my test it does not stop the listener (uptime does not change). What situation can I use only reload and when I must stop/start the ...
0
votes
0answers
25 views

How to clear alert.log without ADRCI?

I know there is ADRCI purge command since 11g, but how can I delete part of the alertlog without ADRCI for a specified time period, I want delete everything older than 15 days.
0
votes
0answers
17 views

Oracle 12c. Is it possible to export a TDE encrypted table using expdp / impdp to a database without TDE / wallet enabled?

I have an Oracle 12c database where I have encrypted certain columns of several tables, I want to import or load these tables into another database which does not have TDE enabled, as would be ...
1
vote
0answers
22 views

Using Merge in Oracle to update a table and clear out a field if the record is not in the source table

I need some help converting an MSSQL Merge statement into Oracle MERGE INTO A USING B on a.a_id = b.b_id WHEN MATCHED and isNull(a.a_field, '') <> isNull(b.b_field,'') THEN UPDATE SET a....
0
votes
1answer
44 views

Query that marries data between two databases

Database 1 is the master database where data on all domains in our client's industry are stored Database 2 (or Database N) are the application specific databases of our client. (e.g. Application ABC ...
0
votes
1answer
16 views

SQL*Loader and DC firewall timeout

We are loading a huge dataset using SQLLDR and there are index creation that lasts for a couple hours or even more. Firewall drops this connection as there is no data transfer during index creation ...
0
votes
1answer
50 views

PostgreSQL vs Oracle double

More of rant, than a question, but maybe someone would explain -- why PostgreSQL migration wiki states that FLOAT (Oracle) is REAL (Postgres) and DOUBLE is DOUBLE PRECISION when in PostgreSQL ...
1
vote
1answer
57 views

Having trouble starting my Oracle database

I'm a programming student and I just started learning databases in college. However, everytime I try connecting to my databse in Oracle SQL Developer I have this message: ORA-12505, TNS:listener ...
1
vote
0answers
42 views

Is it possible to alter normal column to virtual column in Oracle?

ALTER TABLE TAB_NAME ADD TEST_COL VARCHAR2(255); ALTER TABLE TAB_NAME MODIFY TEST_COL GENERATED ALWAYS as ('some_exp') VIRTUAL; Second script gives an error: Error report - ORA-54026: Real column ...
0
votes
0answers
39 views

getitng difference of two consecutive rows

Hi i have a result like this from my query. and i want to get the difference of a specific epmloyee break time so i need to minus the time (OUT-IN). I have search the net but i see nothing related ...
1
vote
1answer
37 views

Connecting to Oracle DB with LDAP-Credentials

So I would like to connect to a remote Oracle database from my Linux system using the oraclient 19c on the command line, but whenever I try to connect it sees the realmpart of my username as the ...
1
vote
0answers
33 views

GV$locked_object showing object locked but kill session is giving ORA-00030: User session ID does not exist

I have tried to execute a stored procedure but its running for an hour. So I have checked for locks using below query but it doesn't return anything. select session_id, a.object_id, xidsqn, ...
0
votes
1answer
51 views

ORA-03113: end-of-file on communication channel [closed]

i am beginer in oracle database. would you help me in this problem? when I start database with startup command i get this text Total System Global Area 3340451840 bytes Fixed Size ...
0
votes
1answer
36 views

Oracle shrink space release space to operational system in one step?

Does oracle release space to operational system when is issued alter table ... shrink space (one step) or just after move HWM (two steps) alter table ... shrink space compact?

1 2 3 4 5 131