Questions tagged [oracle-12c]

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

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

Filter rows by range dates and only get the rows in a range of hours

I want you to filter the rows between a date range but I only want you to return the rows of a time range of each of the days included in the previous date range. For example, you would like to ...
0
votes
2answers
34 views

Oracle limit the number of files of audit

I would like to know how to limit the number of files of audit generated in the audit directory, I have an Oracle 12c database. The AUDIT_TRAIL parameter is equal to NONE, however it continues to ...
0
votes
0answers
145 views

oracle - Change host to 0.0.0.0 in listener

Im using oracle 12c on windows server 2016. I want to make my oracle to listen to the port 1521 to 0.0.0.0 Here is my listner.ora file. # listener.ora Network Configuration File: C:\app\bhuvi\...
2
votes
2answers
224 views

Tuning Java Pool after getting ORA-04031

I'm running Oracle 12.2.0.1 Standard edition on Windows 2012 RC2. I'm NOT running Oracle's Automatic Memory Management. We are seeing these in the alert log: ORA-04031: unable to allocate 4096 ...
0
votes
2answers
50 views

Is it possible to limit connecting users to a schema from specific terminal or program?

I read about Oracle ACL, but on first sight, it doesn't look like it limits the access to a schema on terminal, program level. Is it even possible? I did experience such limitation once. I was ...
0
votes
1answer
24 views

SQL query output to a file is failing with error code 9 when the data contains French and English characters with size > 32k

Database: Oracle 12 C I have a MESSAGE table with BODY VARCHAR2(32000), METADATA VARCHAR2(32000). Initially I had a problem when both columns have 32k+32k chars of data. I had fixed it by applying ...
1
vote
1answer
81 views

Run stored procedures in other schemas from stored procedure [closed]

I have a current process: a large procedure in one schema. There is a plan to have A, B1, B2, B3 schemas (B-schemas are identical, could be B-n schemas) in Oracle 12c database. Schemas B1, B2, B3 have ...
0
votes
0answers
18 views

tracking in odi the package which uses a given mapping

I am trying to find the whole lineage and loading process of a certain table column. To begin with i am locating the mapping used to populate the column. To do this i use: select m.name ...
0
votes
1answer
64 views

Deleting rows from Oracle table user_scheduler_job_run_details

Oracle Database 12c Red Hat Linux 7 I want to delete the last 1000 records on the Oracle table user_scheduler_job_run_details because it is getting too large. How best to delete rows from the Oracle ...
0
votes
2answers
51 views

How to export large table data into different files in oracle?

I'm having a table which contains 10 Lakh lines and need to export into different file which contails 1 Lakh lines each . sample_01.sql ,sample_02.sql and so on How can we take export like this in ...
0
votes
0answers
240 views

Installing Oracle 32 or 64 bit on a Windows Server 2019 to Import data into SQL server and use with Power BI

I am an Oracle noob and really struggling with this concept of 32 and 64 bit business with Oracle. All I really want to do, is import data on a daily basis from an Oracle 12c DW into a local 2019 ...
0
votes
1answer
61 views

Querying 500 million records in Oracle view takes forever

I really need professionals help now after wasting a week of time to solve my problem and searching on Stack Overflow. I have a view created on top of two different tables. This view has 500 million ...
0
votes
1answer
79 views

DBCA and can't init database

SQL> startup; ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0.1/db_1/dbs/initAWSDB.ora' I created a new Oracle 12c ...
0
votes
0answers
18 views

Oracle database timezone for Arizona

I have a server with OS set to CST time zone. I need to install Oracle 12C database on this server but set the time zone set to US/Arizona. Please note: Arizona does not observer Daylight Saving. ...
0
votes
0answers
25 views

oracle 12c enterprise manager default login

I am just installed oracle database in my windows machine after installation it i can't able to login i dont have username only i know password . can any body help on this advance thanks
0
votes
0answers
40 views

Prevent reserved words being used for Column Names in Oracle 12c via a trigger

Is there a way to prevent Oracle from permitting reserved words in column names via a trigger? This solution (after I fix the Declare typo) has compilation errors and doesn't work. I want to ensure ...
0
votes
1answer
25 views

ORA-00904 invalid identifer error when using alias

I'm trying to return a product of two subqueries, and thought I'd make life easier by aliasing each of the subqueries, then divide the two aliases to get the number I'm after, like this: select ...
0
votes
0answers
46 views

How can i change protection mode on dataguard configuration?

hello guys i have a problem. I have a primary database and a standby database which normally work in MaxPerformance mode. But as soon as I change the mode to MaxAvailabity I have the following error ...
0
votes
0answers
71 views

Why privileges on SYSTEM

I'm trying LiquiBase, so for testing I created new schema/user LB_TEST create user LB_TEST identified by <password>; grant create session, connect, resource to LB_TEST; alter user LB_TEST ...
0
votes
1answer
32 views

On a 12c R2 RAC DB, Oracle instance information on crsctl is shown incorrectly

crsctl status output is showing incorrect information for ora.***.db. Instance 1 and 2 are running on Node1 and Node2 respectively but crsctl status shows as below As we can see below, its showing ...
0
votes
0answers
16 views

Can I copy an ACL from 1 Oracle 12.2 database to another? And if so, how?

1 of my databases is missing an ACL, can I copy the ACL from another database? If I can, how would I do that?
0
votes
1answer
29 views

Which instance's timestamp is used as SCN in Oracle 12c rack?

Let us assume 4 oracle12c rack instance's are running on different nodes. Each node has its own clock. No two clock shows the same time. Which instance's timestamp is used by Oracle as SCN? And also ...
0
votes
1answer
26 views

Remove “almost” duplicate rows (may or may not start with plus sign)

To remove duplicated rows from Oracle, I tend to use the following: DELETE FROM your_table WHERE rowid not in (SELECT MIN(rowid) FROM your_table GROUP BY column1, column2, column3); (taken from SO) ...
4
votes
2answers
311 views

Oracle does not use transitive closure to add additional predicate

Presented with a query like this: select * from a, b where a.val = b.val and a.val = 1 Oracle optimizer can use transitive closure property and combine two predicates a.val = b.val and a.val = 1 to ...
1
vote
1answer
23 views

Aggregating Attributes

I have a product review table in an oracle 12.1 EE database that has different attributes rated on a scale of 1 through 5. How do I query this table to count up all of the reviews and group by the ...
1
vote
4answers
74 views

Investigating an Oracle 12c outage after the fact, while limited to SQL*Plus

Warning up front: unfortunately I'm limited to using SQL*Plus on remote site, with no other tools available. This is Oracle 12c (12.2.0.1.0) Standard Edition running on Windows Server 2012R2. Over ...
1
vote
1answer
46 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
1answer
48 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
33 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
158 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
359 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
232 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
52 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
1answer
35 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
28 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
105 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
1answer
104 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
48 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
41 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
0
votes
0answers
85 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
178 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
82 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 start with,...
0
votes
0answers
46 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
48 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
125 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
24 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
47 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
38 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
83 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
36 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 ...

1
2
3 4 5
18