Questions tagged [oracle-12c]

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

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

How can I get all data from a given table since my last run?

In querying a table in Oracle Database, is there any way to reliably and precisely get all rows that have changed (via inserts or updates) since the last time I checked? My tables typically have a ...
0
votes
0answers
4 views

Websphere8.5 j2ee logged out after login into applicaton [closed]

In a development environment, we are doing testing on our application after oracle upgradation from 11g to 12c. After logged in to my application, whenever I try to click on any tab, application is ...
0
votes
1answer
70 views

ORA-01114, ORA-27063 SVR4 Error: 28: No space left on device [closed]

I'm using Oracle 12c and found the error about the temp tablespace No space left on the device many times but I don't know why? My temp datafile separate on 3 filesystem paths the first path store 10 ...
0
votes
1answer
30 views

Oracle SQL- special characters delimited strings

I have a following string in my table in the following format: APPLE- GREEN- 40%; BANANA- YELLOW- 15%; APPLE- RED - 25%; GRAPES- GREEN - 20% I want a output as: Output APPLE - 65% Which is the sum of %...
0
votes
0answers
7 views

Oracle netservice name cpu utilization

Is there a way to check cpu utilization of services running. Setup is a two node rac 12c and there are more services running in one node than the other. Is there a way to find the cpu utilization of ...
2
votes
1answer
38 views

Where can I find SQL Developer Database examples (scripts) to add data to practice?

Where can I find SQL Developer Database examples (scripts) to add data to practice? I require SQL scripts that will add tables and data on those tables in order to practice with Power Bi.
0
votes
0answers
23 views

Oracle 12cR2 / ORA-02800 ORA-06512

When we run database jobs, we get the following error: ORA-02800: Requests timed out ORA-06512: at "SYS.DBMS_ISCHED", line 209 ORA-06512: at "SYS.DBMS_SCHEDULER", line 594 For 12 ...
0
votes
1answer
69 views

How to access an Oracle database from linux

We have a legacy Oracle database hosting all of the information for a now shutdown website, we need to keep the data on the DB available for a period of time due to GDPR etc. We have had some requests ...
0
votes
1answer
96 views

Oracle 12cR2 / ORA-04031 - Unable to allocate xx bytes of shared memory (Shared Pool) (Hard Parse & Parallel Queries)

Sometimes I'm getting ORA-04031 error on my DWH database. The last one like this: "ORA-04031: unable to allocate 56 bytes of shared memory ("shared pool", "unknown object", &...
0
votes
1answer
30 views

oracle sql joins returns multiple row than expected

I wanted to join table zz_value with zz_gg. table zz_value looks like: nach_id ins_id pos_id value data_id gg_id 2416 647415 176959 266355 166991 9863 2416 647421 176959 266355 166991 ...
0
votes
1answer
36 views

Oracle 12cR2 - Image Copy Backup Scenario

Backup type: Image copy. Scenario: I want to 1 full db + 6 incremental backup and keep last 7 days backup on storage. Here is my script: RUN { allocate channel c1 device type disk format '/path/%U'; ...
0
votes
1answer
69 views

Importing huge table exhausts UNDO extents in Oracle RDS (ORA-01628)

I'm attempting to do an impdp on RDS, Oracle 12c. I'm importing only one table for this particular impdp job but every time I try to import it, UNDO usage gets to about 50% and then the logs just say ...
2
votes
1answer
44 views

Can I make PL/SQL functions more strongly typed?

I like to use overloading to speed up development, and I want to structure my code to make future changes easier. I have a function that accepts a NUMBER or a VARCHAR2, but I want it to throw a ...
0
votes
1answer
47 views

Learning COMPUTED BY - what right parenthesis does it need? [closed]

I am reading this document on Automatic columns. The first snippet in it creates a COMPUTED BY column: create table PERSON ( (employee_id integer, employee_id_disp computed by SUBSTRING (CAST(...
0
votes
1answer
25 views

Is this a valid query that could allow to detect whether compression is supported or not?

I am developing against a demo Oracle instance and have no access to compression. My code has to detect whether compression is available or not. My thought was to run this statement in a try/catch ...
0
votes
1answer
35 views

How do I interpolate months in PLSQL

I'm trying to find a way to include all months in a result set my query looks like this: select to_char(changedate, 'YY-Month') Mon, sum(downtime) dt from (select * from assetstatus where assetnum ...
0
votes
2answers
61 views

Oracle 12cR1 - RMAN-11003, ORA-00354, ORA-00353 - Corrupt Redo Log

Oracle 12cR1, disaster database. ORA-00283: recovery session canceled due to errors ORA-00354: corrupt redo log block header ORA-00353: log corruption near block 8 change 80357235718 time 11/01/2020 ...
0
votes
1answer
42 views

Oracle 12cR2 RMAN - ORA-01547, ORA-01194, RMAN-06054

Oracle 12cR2. Error: channel default: deleting archived log(s) archived log file name=+RECO/.../thread_1_seq_166200.26582.1054942673 RECID=62 STAMP=1054943183 archived log file name=+RECO/.../...
0
votes
1answer
25 views

Read explain results from oracle database

hi currently i have query like this on oracle database 12 Query Detail because script is too long if input here the query is too long execute time from explain results i got this PLAN_TABLE_OUTPUT ...
0
votes
1answer
26 views

Enabling TLS and TLS-MA simultaneously for different clients of a Oracle DB

We have a requirement where we want to enable TLS-MA for some of the clients connecting to a specific Oracle database while the other clients can continue to use TLS with server certificate. We are ...
0
votes
1answer
22 views

Can't create view using a role

I am learning Oracle and have to do roles. I created an c##admin from a sys, granted him all grants. Then I created a c##manager_role and c##manager. I granted this role to c##manager. After that I ...
0
votes
0answers
51 views

How can I call a SQL Server stored procedure from Oracle and retrieve a scalar return value?

I'm developing a PL/SQL solution in Oracle Database Enterprise Edition 12.1.0.2. I'm calling stored procedures in Microsoft SQL Server 2014. I am using DG4ODBC with the DBMS_HS_PASSTHROUGH package to ...
1
vote
0answers
123 views

Anomalous performance of mass INSERT in Oracle

Can you please help me diagnose, explain, and possibly solve the problem of unstable peformance of mass insertions in Oracle? I need periodically to load large amounts of data into an Oracle database. ...
0
votes
1answer
54 views

When I set Datestyle to 'SQL, YMD' all queries still return as 'SQL, MDY'

I am working on a database migration from Oracle 12c to Postgresql 12. We must keep the same date format as the program interacting with this database is written in COBOL and should not be changed. ...
0
votes
1answer
119 views

ORA-01017: invalid username/password; cannot login with other users except sys user, Oracle Database 12c?

I have setup Oracle Database 12c on my local machine. It was working fine initially but now I cannot login to users' account except the sys user. I have altered users' passwords and tried logging in ...
0
votes
0answers
15 views

Impossible to create an SQL Server function that calls an Oracle function?

I have been trying too many hours to create an SQL Server Scalar Function that calls an Oracle function. Imagine you have a function in oracle named "Stock_Orcl" that returns the stock for a ...
0
votes
1answer
29 views

Understanding Logging Priority & Options in Oracle DB

From my understanding once we switch on database logging, the entire DB goes into logging mode and generates redo logs. I want to categorically exclude/include some tables/tablespaces from this ...
0
votes
1answer
30 views

How do I exclude unchanged fields in Flashback query resultset?

Is it possible to exclude unchanged fields in Flashback query resultset? Consider I have following table create table first_table ( id int generated as identity, name NVARCHAR2(1024), age ...
0
votes
0answers
28 views

Changes in OraOleDB v18

I use OraOleDB (Oracle's OleDB implementation) in a C++ application on Windows to create tables and insert rows. In the application it is also possible to connect with Oracle using ODBC through OleDB. ...
0
votes
1answer
732 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 ...
1
vote
1answer
36 views

Selecting a record based off conditions CLOB

I have a table with a column storing JSON data as a CLOB. The JSON has a 'miscData' field that is made up of an array of JSON objects. Each object has 2 keys which are always the same, but the values ...
0
votes
2answers
23 views

Recursive multiplication

How can I get ASSY_EXT_QTY to be the quantity of all the path? IE: LVL QTY ASSY_EXT_QTY 1 1 1 2 3 3 1*3 3 2 6 1*3*2 ... I thought making a path but for the quantities and ...
0
votes
1answer
55 views

How to enable “only” drop partition DDL for Oracle Golden Gate?

I'm struggling with how to do this, and hoping somebody could assist with some ideas. Oracle Golden Gate - general question. Version shouldn't be specific, however, I am currently running on: Golden ...
0
votes
1answer
88 views

CREATE VIEW WITH LEFT JOIN - FILTER RIGHT DEPENDING ON LEFT

I am using Oracle 12.1. I have the following tables, simplified for the question : (Note that the XXX for entity ID does represent the same ID being repeated) Events date_event | entity_id | used -----...
0
votes
0answers
146 views

Dbca hangs at 59%

Im creating database in oracle 12.2.0.1 on windows 2012 r2 64 bit and Dbca hangs at 59% of completion in db clone step. I've checked the dbca logs and it's stuck in datapatch.bat step. When I googled ...
0
votes
0answers
35 views

Number of Field in CSV File does not match with number of field in External Table

Hi is there a way to reject a record with excess csv field. For example: CREATE TABLE Table1 ( Field1 VARCHAR(255), Field2 VARCHAR(255) ) ORGANIZATION EXTERNAL ( TYPE ...
0
votes
0answers
11 views

How to appy database security patches in an oracle failsafe environment

We have 4 databases in oracle failsafe cluster. 2 are dc(primary dbs) in failsafe cluster and 2 are dr(standby dbs) in failsafe cluster. Can anyone provide steps to apply patches to these databases.
0
votes
0answers
12 views

Oracle failsafe

Can anyone guide me on how to integrate an existing database to oracle failsafe cluster? Any links or websites where steps are given. Thank you
0
votes
3answers
74 views

Oracle PL/SQL does not work — bind variable not allowed

Oracle 12.2 PL/SQL When running: declare s_sql varchar2(200); begin s_sql := 'dbms_hs_passthrough.execute_immediate@mylink' || '(''exec sp_get_names'')'; execute immediate 'begin :x; end;' ...
0
votes
0answers
23 views

Oracle 12cR2 - ORA-00905 When Creating View

I want to create a view as below: CREATE OR REPLACE VIEW "USERNAME"."VIEWNAME" ("columnName", "columnName", "columnName", ...) AS SELECT DISTINCT ...
0
votes
1answer
39 views

Oracle 12cR2 - How To Create DDL Script Of A View With All Dependencies and Permissions

I have a view in my production database and I want to create same view in my test database. I tried this commmand: ‌‌select dbms_metadata.get_ddl('VIEW','VIEW_NAME','VIEW_OWNER') from dual; It ...
1
vote
1answer
101 views

How to access oracle PDB remotely?

I have create oracle 12c instance with 2 PDBs, I am able to connect to CDB from python using cx_Oracle module but not sure how to connect to PDB.
-1
votes
1answer
54 views

Oracle index analyze stats - managed by whom?

Some questions about managing indexes. We saw in some cases where indexes weren't analyzed in weeks, even though data was inserted and queried from them - using conditions that use these indexes. The ...
1
vote
1answer
35 views

Oracle multiple databases only able to access one database

I am new to oracle. I've installed oracle 12c(required to be this specific version) in my windows pc with no problem. I created one database named LOCAL using Database Configuration Assistant. Then i ...
0
votes
2answers
4k views

How to solve Vendor Code 17002 when connecting to a remote Oracle database?

I have an Oracle database 12c standard edition release 12.2.0.1.0 running on a Linux instance of AWS ec2. When I try to connect to it remotely from my machine (macOS) using SQL Developer I get an IO ...
0
votes
2answers
109 views

Oracle 12c - Insufficient Privileges When Trying To Create A Trigger With SYS User

I want to create a trigger for CRE schema. I'm trying to create this trigger with SYS user but I have insufficient privileges error. My trigger: CREATE OR REPLACE TRIGGER CRE.TRIGGER_NAME AFTER LOGON ...
0
votes
1answer
157 views

What does Oracle impdp do when a name clashes with a materialized view or synonym?

I have a production Oracle database, and I want to export tables, data, views, materialized views, synonyms, etc, to import into a development Oracle database. Actually, this is part of my job, and we ...
1
vote
1answer
62 views

Oracle 12c recovery without system file

Scenario: Deleted system files (dbf files); and trying to recover database back to normal using available control files, and some redo logs. Backup is not available, nor are archived redo log files ...
0
votes
2answers
116 views

Oracle 12c - Logically There Is A Redo Group But Not Physically - Database Can't Open

I have an Oracle 12c Database for my enterprise manager. I could not connect to enterprise manager because the database was closed. I opened listener. However, the database remained mounted mode. When ...
0
votes
0answers
40 views

Pass Variables to SQLDeveloper Report in anonymous block

I can pass variables to anonymous block of this form SQL> set serveroutput on; SQL> DECLARE a number := &i_nr; BEGIN ..... But it doesn't works into SQLDeveloper PL/SQL DBMS Output (...

1
2 3 4 5
18