Questions tagged [oracle-12c]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
448 views

Oracle using sub-optimal index on bind variables

Let's say you have a table, called ORDERS, which contains ORDER_NUMBER, CUSTOMER_ID, and ORDER_DATE (among other fields). And you have one index on ORDER_NUMBER, another on CUSTOMER_ID, and third ...
1
vote
1answer
81 views

Does tables under schema uses multiple tablespaces other than default tablespace

I have schema A in a database and have assigned the default tablespace as myspace. There are 20 tables that reside under this single schema and all the tables are using different tablespaces. My ...
0
votes
1answer
2k views

Install Oracle Database 12c Error unable to check whether the location specified is on CFS

ps://i.stack.imgur.com/0DX0d.png I am trying to install the Oracle database 12c on the Windows 10 Laptop. Have tried disk C and disk E, got the same error. And I tried to change the file properties,...
1
vote
1answer
35 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
1answer
78 views
+50

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
13 views

Swingbench Java error while installing [closed]

I'm trying to install Swingbench but while I click Next button I got an error : Exception: java.lang.NoClassDefFoundError thrown from the UncaughtExceptionHandler in thread "AWT-EventQueue-0"...
0
votes
0answers
43 views

Oracle procedure becomes progressively slow [closed]

I have an oracle 12C procedure which uses a collection to insert and update 3 different tables. The dummy code of the procedure something like - CREATE OR REPLACE PROCEDURE INSERT_DATA AS BEGIN &...
1
vote
2answers
3k views

Delete databases from oracle 12c

I want to delete multiple databases and its entries. These instances are not getting started. I want to delete data files also. EDIT: I am thinking delete all data files. Please help on below concern....
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
1answer
855 views

ORA-00823: Specified value of sga_target greater than sga_max_size dba

I was doing a modification in my database and something I should not have done well and I got the following error : SQL> startup ORA-00823: Specified value of sga_target greater than sga_max_size ...
0
votes
2answers
22 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
0answers
7 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 ...
1
vote
1answer
978 views

Query on SCAN in RAC

I have a two node RAC (Oracle 12c) on linux. I have 5 SCAN listeners configured. Currently, if I do a srvctl config scan I notice that out of the 5 scan listeners, one scan is running in one node ...
0
votes
0answers
29 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
1answer
170 views

Why is OracleDB locking up in Docker?

I am trying to set up an Oracle database in Docker, and once the database is up and running, I can exec into sqlplus just fine, but if I try to connect with another application like Oracle SQL ...
1
vote
1answer
222 views

Which Oracle datafiles grow in size?

I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to move datafiles that can grow to a separate mount point (setup as a vmdk on a HDD. more ...
0
votes
2answers
140 views

Moving DataFile to Another Location ORACLE

I'm having some problems moving DATAFILE from one location to another due to the shortage of storage space. I've managed to change the path file of control file via command(linux). Now I would like to ...
0
votes
1answer
1k views

Can't connect to Oracle 12c Release 1 in docker container from host

I pulled the Oracle 12.1.0.2 docker image from the Oracle Container Registry (container-registry.oracle.com/database/standard:12.1.0.2) and created a container as per the instructions, leaving the ...
0
votes
1answer
2k views

Configure wallet location in sqlnet.ora and listener.ora

I have a host containing multiple DBs and the connection to the DBs need to be SSL enabled. Since each DB has a unique wallet, I specify the wallet location in sqlnet.ora as: WALLET_LOCATION=(SOURCE=(...
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
1answer
488 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
3answers
103 views

How do I order the columns of a SQL statement (not the rows)?

I'm an ERP analyst, and when I find something I haven't seen in a long time, I need to jog my memory to know which column contains the data I want. I need to examine the data to do this, so a query ...
2
votes
1answer
903 views

ORA-00205 error during the startup of physical standby database

Steps I have followed:- Created a physical standby database by using DUPLICATE TARGET DATABASE. Then checked the log gap between these two databases which was fine and in sync. After that standby ...
0
votes
3answers
59 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;' ...
2
votes
1answer
3k views

Setting DataGuardSyncLatency for Oracle Data Guard

With Oracle 12.2 there is a new parameter DataGuardSyncLatency when setting up Data Guard. I keep getting the warning: Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent ...
0
votes
0answers
3 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.
2
votes
1answer
80 views

How to point tablespace in Oracle's pre-built Developer Day VM to another mount point

I have downloaded and started up Oracle's pre-built OTN Developer Day VM. The VM is running on an SSD. I want to load some data for development purposes. I am planning to create a new user and load ...
2
votes
1answer
418 views

How do I run a database heavy query over jdbc without timing out (Oracle)?

For one of our applications (Pentaho Data Integration), we need to run queries through the oracle jdbc. Some of these queries are computation expensive and can take an hour or more to return any rows ...
2
votes
2answers
247 views

Oracle: Physically reorganizing rows of a huge table by a different key

I have a huge table RECORD -- a few billion rows -- which contains data loaded continuously in a lot of batches. I can assign a primary key RECORD_ID from sequence, or use natural composite key ...
0
votes
1answer
324 views

script to spool all tables in a schema to xml format in Oracle 12c

I've written the following script, spooltables.sql, which I'm calling from SQLcl as $> @spooltables.sql The aim is to loop through all tables in a given schema and output them to separate XML ...
0
votes
0answers
11 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
2
votes
1answer
247 views

IORA-00904: Invalid Identifier when converting Radians to Degrees

I am using this simple query in Oracle SQL Developer to basically convert a value in Radians to Degrees but I get error at the function itself. SELECT Degrees(1.571) as ANGLE FROM DUAL; Error: Ora-...
0
votes
0answers
21 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
35 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
54 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
vote
0answers
43 views

Oracle - Monitoring tablespace warnings and critical events via Microsoft Windows Event log

I would like to monitor tablespace warning and critical events of my Oracle database (12c Standard Release 12.2.0.1.0) via Microsoft Windows Event Viewer and attach tasks to it. Right now only a few ...
1
vote
2answers
198 views

Oracle 12c backup question with FRA

If I wanted to backup to the FRA and another location, how would I configure the channels? Also, would I need to set parallelism? Thanks
3
votes
2answers
1k views

Case insensitive search of CLOBs in Oracle 12

Question: What is the most performant way to do a case-insensitive search in a CLOB column? I've simplified the query to easily reproduce the problem. The filedata table can have millions of rows. ...
0
votes
1answer
261 views

Load balancing on oracle (12r2) 2 node RAC is not working

Any help/pointers would be greatly appreciated. I have a 2 node RAC (Oracle 12r2) on linux, CRS and all its services are up. Both the RAC instances are up. scan listener resolves to 3 ip's. But ...
0
votes
1answer
92 views

Direct, simple SQL query results in “ORA-01406: fetched column value was truncated”

All the information I've seen on this issue is always in regards to running a query via some other utility (e.g. TOAD); however, I am seeing this issue when I simply try to select * from v$asm_disk; ...
0
votes
2answers
174 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 ...
1
vote
1answer
143 views

listagg in order and including a sequence of separator when missing any row of a sequence

Sorry for the long title but it's a little bit difficult to explain. We have a table | N rows | Atrib1 | Atrib2 | Atrib3 | Atrib4 | Final row | --------------------------------------------------...
-1
votes
1answer
47 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
30 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
37 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
26 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 ...
0
votes
2answers
452 views

How to switch between Oracle 11g and 12c on same linux

I have oracle11g and 12c installed on same machine and few test cases that need to be run on both versions. Can power up both database simultaneously and run test paralally. Do you know any document ...
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 ...
2
votes
1answer
4k views

How to increase size of temp tablespace in Oracle 12C RAC with ASM?

I have an Oracle 12c RAC consisting of two nodes (OL6) and ASM. I use it for learning. For some reason I want to increase its temporary tablespace size. It's about 50M now. I've considered it using ...
1
vote
1answer
85 views

Different execution plans and joins using synonym or table

Edit: We found the leading cause. If you join tables with the same name but in different schemas you can get this result. Same with joining two tables using the same alias (whyever this works at all)....

1
2 3 4 5
18