Questions tagged [oracle-12c]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
41 views

how to create a duplicate table with the same constraints as the original in Oracle

I usually create a duplicate table like this: CREATE TABLE TEST_NEW AS SELECT * FROM TEST; This does create a replica of the original table, however, the constraints aren't replicated. is there a way ...
datascinalyst's user avatar
0 votes
1 answer
79 views

Oracle 12cR1 - How to Switchover In Multiple Physical Standby Environment With Cascaded Standby Scenario

Current Environment: 12cR1 RAC Production Database -> Let's say PROD 12cR1 Single Instance Physical Standby (Active Data Guard) -> Let's say DR1 Planned Environment: 12cR1 RAC Production ...
rndm_acct1's user avatar
1 vote
2 answers
92 views

How to search text in oracle view

I need to create a filter where I can locate specific text in my views. I tried using the following queries: SELECT OWNER, VIEW_NAME FROM DBA_VIEWS WHERE UPPER(TEXT) LIKE UPPER('%ABC%'); But ...
Igor Oliveira's user avatar
0 votes
2 answers
46 views

Oracle Batch Deletion

I have an Oracle table that has over 1.8 Billion rows, I need to delete up to 260 million of these rows. I am a Microsoft SQL DBA, so not fully comfortable with the Oracle syntax and best practices ...
Stockburn's user avatar
  • 429
2 votes
1 answer
85 views

How to locate a procedure in the body of a trigger

I'd like to perform a validation by capturing all my triggers that call procedures.To do the search, I'm looking for the words "Call" and "Execute" in the trigger body -- I'm using ...
Igor Oliveira's user avatar
0 votes
0 answers
16 views

Geting ORA-01017 after copying oracle home directory to different linux server

-- Oracle V 12c I have two different servers. I have copied the entire oracle directory from one server to another, and now I am using made relevant changes in .bash_profile. when executing sqlplus, ...
datascinalyst's user avatar
-2 votes
1 answer
106 views

Oracle SQL - Selecting First Row for each ID

I am using Oracle SQL Developer and I am trying to pick the first entry of the student population. So, that I have one row for each ID. ID DEGREE AWARDED ACADEMIC PERIOD 147 GR MS 2022 147 UG BS ...
DataAnalyst's user avatar
0 votes
1 answer
54 views

Moving data from Oracle12C to SQL 2022

Currently we have to migrate off of our SQL 2012 server since it is outside Microsoft support. We currently have replication from an Oracle 12C database to current SQL 2012. We like to move to 2022 ...
Leo Torres's user avatar
0 votes
0 answers
20 views

bypassing application controls from database

I'm currently doing an audit on oracle payables & CC&B and I noticed that the DBA team has full access on the database and with no audit trail enabled. Is it possible to bypass the application ...
Ibrahim aj's user avatar
0 votes
1 answer
125 views

Using at sign "@" in password Oracle Database/Forms

We have an application running in Oracle Forms which connects to an Oracle database (12c). We've always had issues with using the "@" sign in passwords so we always instructed our users not ...
rkonings's user avatar
0 votes
0 answers
62 views

Oracle Database schema validation

I am working on a database migration and want to validate the destination schema against the source schema for Tables, Views, Indexes, Sequences, Constraints etc. I can do that by querying the dba_ ...
JuniorDeveloper's user avatar
0 votes
1 answer
1k views

Can not set ORACLE_BASE with oraenv command after install in CENTOS 7 server

Im trying to install Oracle DB version 12.1.0.2.0-1 in my customer server, my installer file name is oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm. After run this file with sudo rpm -i oracle-...
May'Habit's user avatar
  • 101
0 votes
0 answers
103 views

Oracle 12c - Invalid username/password for ctxsys after password change

I am running an SQL script which starts with these commands: connect sys/intershop as sysdba ALTER user ctxsys account unlock; ALTER user ctxsys identified by ctxsys; -- Grants with Grant Option for ...
Ricky Sixx's user avatar
0 votes
0 answers
99 views

Top reasons for temp tablespace to go offline

It was marked offline and it is fixed already. We want to know the list of causes that marks the temp tablespace offline.
Suresh Dooly's user avatar
0 votes
0 answers
87 views

Cross Version EXPDP/IMPDP of Indexes

Our source database is 11g and target is 19c. My question is about exporting and importing indexes. Does the EXPDP command "exports" the actual index structure or just the "Create index&...
oradbanj's user avatar
  • 141
0 votes
1 answer
83 views

Unable to use data pump utility in Oracle to import data to another server

I am using this command: impdp atif/[email protected]:1521/serv1 DIRECTORY=DATA_PUMP_DIR DUMPFILE=mltpltblbkp.dmp LOGFILE=mltpltblbkp.log to import data from one server to another. this is my ...
dbafix's user avatar
  • 54
0 votes
1 answer
321 views

LSNRCTL cannot stop Listener

When I'm trying to lsnrctl start, i have following error: TNS-01106: Listener using listener name LISTENER has already been started However, if i try to lsnrctl stop: Connecting to (ADDRESS=(PROTOCOL=...
igor1707's user avatar
0 votes
1 answer
665 views

CREATE CONTROLFILE failed ORA-01210: data file header is media corrupt

I am trying to recover a DB beacause I've lost control file. So I try to create a new one: CREATE CONTROLFILE REUSE DATABASE "MYDB" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 2 ...
igor1707's user avatar
0 votes
1 answer
147 views

Centos 7 Oracle Database 12c Installation Out of Memory

I am new to Oracle Database Installation and I tried to install newer version but it does not work, and when I get a full documentation on how to install version 12c, somehow I got an error out of ...
Hwangry's user avatar
0 votes
1 answer
90 views

Database Dependency Chart?

I have several SQL Server (2008 forward) and Oracle (12c forward) legacy databases running on a server... I know for a fact that various stored procedures point to other databases, like select * from ...
Leonardo's user avatar
  • 217
1 vote
0 answers
13 views

How to get the value from the most detailed hierarchy row

I have a table with the following structure: Country State City Value BR SP qwert 10 BR SP yrtu 12 BR SP 13 BR 14 BR RJ zxc 11 BR iop 9 This table contains a multiplicative value that I ...
Felipe Deguchi's user avatar
0 votes
1 answer
614 views

Operation not allowed from within a pluggable database Pre-Built Developer VMs for Oracle VM VirtualBox

I downloaded Pre-Built Developer VMs for Oracle VM VirtualBox , which contains Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 I want to BACKUP the Database using Rman, but it is in ...
Tomas A's user avatar
0 votes
1 answer
504 views

sqlplus: command not found Using SSH on Windows to VMware linux

I have oracle Database 12c in a virtual machine with the database working normally in a linux environment (Centos). Through windows, using ssh I was able to connect to the linux virtual machine. But ...
Tomas A's user avatar
0 votes
1 answer
705 views

Upgrade Oracle DB from 12C to 19C with minimum downtime

We are planning to apply the below steps --> Export Live DB setup on the Oracle version 12C Import on the new DB setup on version 19C At this point, V12, and V19 schema structures will be exactly ...
rajan dawra's user avatar
1 vote
1 answer
668 views

Oracle 12c: Remove JSON object from JSON array

Need to create a function which takes input of CLOB and I need to remove array matching the condition. create or replace FUNCTION remove_config_node_by_key ( p_in_json IN CLOB, p_in_key ...
Deepak Negi's user avatar
1 vote
1 answer
556 views

Oracle12c - EXPDP hangs when using NFS share

I have a problem with the export via EXPDP for Oracle12 databases. When the export is local, no problem. When I use an NFS share, the export starts, creates the log file, then nothing. VM where the ...
Quentin Rey's user avatar
1 vote
0 answers
17 views

Oracle schema wise replication selection

We have 2 Oracle DB schema (ABC, XYZ) in two geographies (site 1 and site 2) where both schemas are running on separate cluster. Schema ABC has golden gate replication between site 1 and 2 and is an ...
katipra's user avatar
  • 11
0 votes
0 answers
190 views

Truncate table takes too long waiting db file async i/o submit

I've got Oracle 12c data warehouse database on oracle Linux 7.3, and there's job that truncating one table. Table has size of 5GB And always truncate takes about hour with waiting for "db file ...
Sebastian 's user avatar
0 votes
0 answers
29 views

Oracle date issue with query

Using Oracle 12c database. The following fields are set as Date for the datatype in the database. The following query either shows dates that are not in the database or throws the Ora 0092 error. I ...
jrdnoland's user avatar
1 vote
0 answers
434 views

Is it safe to sync Oracle 19c to 12c via dblink?

Source database: Oracle 19c Target database: Oracle 12c, via dblink Is it safe to sync tables from a higher version to a lower version? I will create a materialized view on the target with scheduled ...
Alex Borja's user avatar
0 votes
1 answer
1k views

Offline install of Oracle 12c on Oracle Linux 8 without yum or GUI access

I am trying to install Oracle 12c on Oracle Linux 8. I have the relevant files (linuxamd64_12102_database_1of2 and linuxamd64_12102_database_2of2), but the installer uses a GUI, which I can't do (I ...
simonalexander2005's user avatar
0 votes
1 answer
947 views

Upgrade 12c client to 19c client

Does Oracle 19c client upgrade 12c client if installed or does 12c client have to be uninstalled prior to 19c installation?
SherryJ's user avatar
0 votes
0 answers
794 views

sqlplus is not working, it is frozen

When I type sqlplus / as sysdba It simply gets frozen, the cursor stays there, and I can type more character but after pressing enter nothing happens. Neither CTRL + C. My pmon service is running, ...
Raul Mercado's user avatar
0 votes
1 answer
4k views

how to identify what is causing the CPU Wait status ORACLE

I'm new to oracle and I have a problem because CPU Wait rises and I can't identify what is causing it
Edgar Rodriguez Testa's user avatar
-1 votes
1 answer
732 views

Proper way to setup oracle database for TCPS SSL in local machine

I am using oracle database 12c and would like to setup TCP SSL connection to be able to connect using the same machine where the database is hosted. So, connection would be from database machine to ...
Generalex's user avatar
0 votes
1 answer
61 views

ORA-02270 - can FK in Oracle be defined on VARCHAR2 column?

SQL is more than words: CREATE TABLE "currency" ("id" NUMBER(10) NOT NULL, "currency" VARCHAR2(50) NOT NULL, "name" VARCHAR2(1020) DEFAULT NULL NULL, PRIMARY ...
mvorisek's user avatar
  • 418
0 votes
3 answers
9k views

export multiple tables using expdp with query condition

I have requirement to export multiple tables using datapump job and the ultimate goal is that we are doing a migration from on-Prem . They have something like 6TB of AUD data and we are not required ...
sarat's user avatar
  • 60
0 votes
1 answer
2k views

Is it possible to set Audit_trail parameter to both DB and OS in Oracle database

In Oracle database ,we can direct audit records to either db , os or in xml file by using the below command: ALTER SYSTEM SET AUDIT_TRAIL= DB SCOPE=SPFILE; But is it possible to direct audit records ...
Allan's user avatar
  • 1
0 votes
0 answers
170 views

Oracle - How to Set Table and Index Statistics on empty table in order to test out explain plans?

I have an empty table with some indexes. I would like to test out different queries on this table to verify the explain plan is behaving as expected. Normally I would insert a large amount of fake ...
Matthew Moisen's user avatar
0 votes
1 answer
201 views

How get role inside another role oracle

I am trying to make a script that allows me to get the roles that are inside another role of all users
Edgar Rodriguez Testa's user avatar
0 votes
1 answer
325 views

understanding oracle pluggable databases

I'm learning a little bit about Oracle Database. As I understand: In previous versions of Oracle DB (versions <= 11ng), each DB should be installed in a separate server. Is this statement true? ...
Ravexina's user avatar
  • 103
0 votes
1 answer
467 views

2 node RAC: gv$encryption_wallet has wallet in different locations?

Linux x86_64 Exadata X8, Oracle 12.1.0.2, 2-node RAC. I created a wallet on node 1. In $TNS_ADMIN, sqlnet.ora contains "wallet_location=/u01/oracle/correct_dir" Node 2, I spaced creating ...
Andrew Grady's user avatar
0 votes
1 answer
86 views

Oracle client 12c , if i can't find uninstallation file, can i install 19c client on same server?

I have a server that has oracle 12 client installed but now have an application that references the same server that needs oracle client 19c installed in order to work with the service. I cannot seem ...
OluT's user avatar
  • 1
0 votes
1 answer
306 views

Oracle - Big Table Archiving

Version: Oracle 12cR2 EE The table contains the following column types: NUMBER, CLOB, NVARCHAR2, TIMESTAMP, VARCHAR2 Table size: 95GB Table row count: 20M Table partitioned? No Indexes on table: there ...
jrdba123's user avatar
0 votes
0 answers
3k views

Set 'WE8ISO8859P15' character set for existing Oracle 19c DB while migrating 12c DB

I have a database in 12c (12.2.0.1) which I need to migrate to an existing live oracle 19c DB.(This DB already hosts a couple of live DBs’s) Character set of DB’s are as below: 12c -> ...
picku's user avatar
  • 1
-2 votes
1 answer
63 views

Which sql statement is more efficient (Oracle SQL)?

Create a query to get the customer with the most numbers of orders - am wondering which one is a more efficient query? SELECT c.customer_id, c.first_name || ' ' || c.last_name as Name, count(...
punsoca's user avatar
  • 109
0 votes
1 answer
2k views

ORA-12152: TNS: unable to send break message - Only LISTENER restart works

i have a strange problem with our Oracle 12.1.0.1.0 on our VM Windows Server 2016. I create a daily batch script whichs creates a dump file (via EXP) and execute some sql statements (via SQLPlus). ...
Athris's user avatar
  • 11
0 votes
1 answer
6k views

Oracle 12c to 19c Internal Schema Export & Import

I want to exp & imp operations for APEX users from Oracle Database 12cR1 to 19c. Data Pump Utility can't do that. When I try to export by using following parfile and command: DUMPFILE=APEX.dmp ...
jrdba123's user avatar
0 votes
0 answers
118 views

Can an Oracle Database request a system crash (One Instance Crash)?

I am Junior Database Administrator at a Bank and there was an issue that caused the Oracle Database Instance one to crash (We have two instances). So the system rebooted itself and everything is ...
lulmail's user avatar
0 votes
2 answers
206 views

Oracle 12cR2 - After Logon Exception

Logon trigger as below: create or replace TRIGGER USER3.MY_TRIGGER AFTER LOGON ON DATABASE BEGIN IF SYS_CONTEXT ('USERENV', 'SESSION_USER') IN ('USER30') THEN IF SYS_CONTEXT ('USERENV', 'HOST') NOT IN ...
jrdba123's user avatar

1
2 3 4 5
19