Questions tagged [oracle-12c]

Oracle Database 12c. Please also tag oracle for search purposes.

Filter by
Sorted by
Tagged with
1
vote
1answer
29 views

Batch - Update vs Insert then Delete [closed]

There is a plan to create a new ETL job to do a particular task. It will retrieve data from database1, and from that data, it would update equivalent records in database2. Both database1 and database2 ...
0
votes
0answers
15 views

How do I change the default ports for my Oracle database?

I can use Terminus app from my iPhone to connect to my oracle database. From my corporate network, I can't. So what ports do I need to change?
0
votes
0answers
37 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
0answers
10 views

Archive enabled and disabled [closed]

Why we cannot set archive enabled and disabled in startup why in startup mount we should set the archived enabled and disabled why not in open database plz answer
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
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 ...
1
vote
1answer
83 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
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
15 views

What are the approaches for refreshing materialized views in Oracle, when underlying tables are updated often?

I am a web developer, maintaining a web app that tracks orders, customers, products, etc, that my client uses internally. I use Oracle 12c, hosted on AWS RDS. My client has just switched some other ...
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
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 ...
0
votes
1answer
45 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 ...
1
vote
2answers
40 views

Input to be printed in different output format

I have a value (e.g. ORACLE) and I would like to print each letter on an individual line using an Oracle query. Input value: ORACLE Output: O R A C L E
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
36 views

Oracle move online

I have Oracle Release 12.1.0.2.0 and I need to reclaim wasted space due to data fragmentation. I have been told that I should use the instruction "MOVE ONLINE". I tried the following but I'm getting ...
0
votes
1answer
34 views

I want to delete connections in tnsnames.ora. I need to figure out which ones are currently in use, so that I don't delete them mistakenly

I'm using Oracle 12c in Debian 8 (on a vm) This question is for educational purposes only. I'm not using any production servers, so anything that you can tell me won't have consecuences To ...
0
votes
0answers
22 views

Creating a Real Time Materialized View and Materialized View Logs

I wanted to create a real-time materialized view with a fast daily refresh based on a query that took fields from 3 tables (PS_JOB, PS_DEPT_TBL, PSOPRDEFN) and 1 view(PS_NPS_LICCERT_VW). The query/...
0
votes
0answers
28 views

Unable to generate DDL statements using impdp 12c

I am trying to generate DDL statements from the data in a dump file, by importing the dump file using impdp. This is my export log: ;;; Export: Release 12.2.0.1.0 - Production on Thu Dec 12 01:56:...
0
votes
1answer
52 views

Error during upgrade : Oracle 11g to 12c

While upgrading catupgrade.sql, we are getting below error. Due to errors found during the upgrade process, the post upgrade actions in catuppst.sql have not been automatically run. * ...
0
votes
0answers
21 views

Incremental replication of an Oracle database to a PostgreSQL replica

I have a third party system using Oracle 12C database to which I need to do data analytics. For safety I don't want to do it to the production database server. For economical reasons I can't run ...
1
vote
0answers
44 views

Why my Oracle 12C is allowing me to a connection creation without passing network security and integrity parameters

My Integrity settings Oracle Net Manager are: -- Integrity for - Server Checksum level - REQUIRED Selected Method : SHA1 -- Integrity for- CLIENT Checksum level - REQUIRED Selected Method : SHA1 ...
1
vote
1answer
26 views

In Oracle 12c, is there an alternative to CREATE TYPE when I only have read-only privileges?

I have read-only access to a Oracle 12c system where there is zero chance I can get additional privileges or get the DBAs to change anything on my behalf (such as do CREATE TYPEs for me). I'm using ...
0
votes
0answers
38 views

Randomly getting ora-01017

I have an Oracle RAC (12.1.0.2) installed on ESXi 6.5. RAC nodes are hosted on different physical servers and there is a storage hosting their shared disk. Here is my problem: Trying on Toad, SQL*...
0
votes
0answers
24 views

SQL Syntax to get one row for each Employee ID and max date

I joined a few tables in order to get data pertaining to certification by employees. I have a query that gives me the employee id, name, certification start date JPM_DATE_3, certification end date ...
-2
votes
1answer
36 views

Common Table Expressions [closed]

Are there alternatives to common table expressions in Oracle 12 c? I'v been using the syntax from SQL Server and oracle gives me the following error. SELECT CTE_TEST AS (SELECT DISTINCT deptno, ename ...
1
vote
0answers
83 views

Oracle Context Index - finding unsynchronised records

Context indexes can be update with the procedure: Ctx_Ddl.Sync_Index (index_name); But what exactly is synchronised by this function? How does Oracle know what is unsynchronised (i.e. how does it ...
0
votes
0answers
76 views

Removing Duplicates in LISTAGG

In the query below, I used the LISTAGG function to aggregate certificate names I.e. JPM_DESCR90 . However , now I'm trying to find a way to remove all the duplications in the row, and reducing the ...
0
votes
1answer
64 views

Oracle 12c installation : reference data is not available for Release “12.1” on the operating system distribution "Linux4.12.14-94.41-default

We are trying to install Oracle 12c in Suse Linux 12.4. As soon as we start the installation, it fails saying [INS-13001] Environment does not meet minimum requirements When we checked the log, we ...
0
votes
0answers
63 views

SQL query tune to replace UNION - Oracle

SELECT FN_ENQDATA_STRING (col1) FROM tab1 WHERE tab1.col2 = tab2.col2 AND tab1.col3 = ? I also have tab2 which has same columns as tab1 and i need to call function for that too. What I can do is ( ...
0
votes
1answer
74 views

Syntax Error in Create Table Statement

I'm using Oracle 12c, I want to create a table with partition by year and subpartition by month like this. create table par.Log_his ( ID NUMBER(20) not null, Year number(4,0), -- ...
0
votes
1answer
21 views

dba_registry_history vs dba_registry_sqlpatch and OJVM patch

Should dba_registry_sqlpatch-view list all installed patches and therefore it would also list OJVM patches? Or OJVM patches are only listed in dba_registry_history-view?
0
votes
0answers
58 views

Oracle DB divide by almost smallest number ever

Oracle DB 11 or 12. Got this code: select 1/0.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001 from dual; That's ...
0
votes
0answers
36 views

How to mount current control file in ORACLE 12C1 RAC

I am trying to take a backup of my ORACLE 12C1 RAC setup and faced following error: RMAN> BACKUP CURRENT CONTROLFILE FORMAT '+FRA/RMAN/cold/ORCL/cntrl_%s_%p_%t'; Starting backup at 16-DEC-19 ...
0
votes
1answer
181 views

Verify if the client is connecting to the Oracle database using native network encryption

My environment is as below - Server: Oracle 12C 12.1.0.2.v17 ( AWS RDS Service) Client: Windows 2012 machine with Oracle 19C 64 bit full client Tools : SQL Developer and Toad on the client machine ...
1
vote
0answers
70 views

Database - limit of reading a table with a lot of concurrent batch read and writes

We have this table. It contains data which will be picked up by an hourly batch job for processing. Five times a day, there are also multiple batch ETL jobs which get data from other source table and ...
1
vote
1answer
44 views

How to manage disk space allocation for materialized views?

Summary: I have materialized views in oracle 11g that seem to hog disk space, unlike normal tables that mark rows as deleted and stats eventually show them as free space (allocated to the table, ...
0
votes
1answer
69 views

EXPDP error ORA-39374 + ORA-13158 Oracle object does not exist

While exporting one of the tables in my db I got the following error : Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS ...
2
votes
1answer
104 views

Can shrinking temporary TEMP tablespace in Oracle cause any harm?

I have a massive TEMP tablespace that is 1TB large. It consists of 30datafiles, each one is like 31GB in size. Entire TEMP tablespace has a size of 1TB, while used size is only ~600MB. I want to ...
0
votes
1answer
43 views

Can a role be granted roles+privileges in oracle all at the same time?

I know that you can grant a role: Other roles System privileges Object privileges But, can you grant to the same role all at once? I mean, for example you grant a role: 2 roles 1 system ...
0
votes
0answers
28 views

Can a user have more than 1 profile assigned in Oracle?

That's my question, as simple as it seems. I actually wasn't able to find the answer in the Oracle documentation, so I came here for asking. Still, I tried this query SELECT USERNAME, PROFILE FROM ...
0
votes
1answer
88 views

What is the default quota on a tablespace for a given user in oracle if you don't set one?

My environment I'm using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production Explanation of the situation I was creating a user with the following command create user ...
0
votes
1answer
138 views

Script to install Oracle client 12c2 on Redhat linux 7.5

Can someone help me to provide a script which I can use to install the Oracle client as part of the server build or AMI. Below script I was able to pull out from the guide in the Oracle site. But ...
0
votes
1answer
30 views

Can Oracle SE2 RAC works with only a single instance? Is it recommended?

I've got a client with an Oracle DB 12 SE2 RAC with two instances. One of the instances is giving too much problems. He wants just to remove it, and therefore leaving Oracle RAC running in only with ...
0
votes
0answers
37 views

Range vs List partitioning for YYYYMM year month field Oracle 12c

I have a table which holds monthly data differentiated by a column year month (YYYYMM, eg 201911). We have been planning to partition the table by month however we are unable to decide between Range ...
1
vote
1answer
52 views

Setting NLS_LENGTH_SEMANTICS for session via trigger

I have the following problem with my Oracle 12c database. I have to install a third party application, which needs an Oracle database instance. The supplier demands to set the NLS_LENGTH_SEMANTICS ...
1
vote
0answers
23 views

Replicate records at a specific CSN in Oracle Golden Gate

Is it possible to replicate records from the source table at a sepcific CSN? Here is my table with each rows with their ORA_ROWSCN ID Name ORA_ROWSCN 1 John 37828337 2 Mike 37828337 3 ...
1
vote
2answers
351 views

How to force oracle accept insufficient swap size?

I want to install Oracle 12c on Oracle Linux 6.10 with 5.7803GB swap size. But one of prerequisites checked failed: INFO: ********************************************* INFO: Swap Size: This is a ...

1 2 3 4 5 17