Questions tagged [oracle-12c]
Oracle Database 12c. Please also tag oracle for search purposes.
0
votes
1answer
8 views
Oracle12c: Objects attempting to import to original tablespace (despite wanting to remap them)
I've exported a schema from a DB server (Oracle 12.2.0.1.0) using exp with the following command.
exp USERID=FOO/FOO2019 FILE="D:\app\ORACLE\admin\orcl\dpdump\FOO.dmp" LOG=FOO.log
I now want to ...
0
votes
2answers
47 views
Unable to connect oracle 12 database remotely while local connection works
I have two oracle test nodes. On node 2 as root I am able to connect without credential with the command,
su - oraabc -c "/oracle/ABC/12102/bin/sqlplus / as sysdba"
Output:
SQL*Plus: Release 12.1.0....
2
votes
0answers
53 views
Why distinct flag count differs after group by function? [on hold]
I am trying to get distinct count of ACT_CAND and my count is off, issue started after I had to fix dups that was being caused by MTVE_NAME which has many to many relationship with APP_FACT, initially ...
-4
votes
1answer
47 views
csv output from SQL query [closed]
I need to run SQL query saved in test.sql file from bash script. Bash script will be run from a linux server that is also running SQL*Plus which connect to database server.in addition, generated ...
1
vote
1answer
28 views
Query to get list of busiest schemas in Oracle 12c database
I have an Oracle 12c database with many schemas, each schema belongs to a specific application.
I want to produce a query that shows me which schemas are the busiest in terms of read/write activity /...
0
votes
1answer
47 views
A trigger making a timestamp of when another column was changed
I've beeen trying to create a trigger, that'll make a timestamp, of when our account was "deleted" which we do by setting deleted = 1. Below code creates a trigger for that purporse, however it has ...
0
votes
1answer
47 views
Insert Into queries take too much time in Apache spark
I am using Oracle Database with Apache spark 2.3.0
In my code I am writing final output (after all the processing) in three tables using below spark command.
billableChargeKDF.write().mode("append")....
-1
votes
1answer
39 views
Design with new table and old tables
I have to add a new table according to some new requirements, the model currently consists of two tables: DETAIL and SUMMARY.
The relation is that every detail has associated one summary, so now I ...
0
votes
1answer
56 views
Diakrites land wrong in Oracle database
Every time we are rolling out a new release same tables are trancated and filled with fresh data. This process is done on a Windows pc with scripts that are run in SqlPlus.
When we do this on our ...
0
votes
1answer
24 views
Question on Auditing 12C
I have the following configuration information:
audit_sys_operations
TRUE
audit_file_dest ...
0
votes
2answers
39 views
Tyring to get a better understanding of ORACLE admin accounts
In reviewing some configuration information for an ORACLE 12C server, I see that the only user assigned the DBA role appears to be SYS account. Also, the only user shown with SYSDBA and SYSOPER ...
0
votes
1answer
27 views
Oracle 12c EM error on login
I'm trying to access an Oracle 12c EM and when I try to login it shows me a load error box with the errors that I expose below, which could be happening? Is there a possibility to reconfigure EM ...
0
votes
0answers
49 views
Critical error and failing to parse data returned by server
I am currently running Oracle 12c, but unfortunately I am getting this critical error message:
Fail to parse data returned by server
I have never seen this error before and every attempt at ...
-1
votes
1answer
43 views
Composite index and Normal index,redundant/duplicate index - Incurred Performance penalty
Need suggestion on below indexes, whether our composite index is enough and can the normal index be removed.
Scenario - We have ix4 and ix6 indexes as below, please review and advise if ix4 is ...
1
vote
0answers
21 views
oracle shard availability pending
Trying to adjust Oracle DB 12.2 sharding configuration. Have one DB as the shard catalog and other two DBs as shards. Just want to test this functionality so run the tree DBs on the same machine in ...
0
votes
0answers
20 views
Does clearing cache in at os level affect oracle running database?
I have 32 gb of ram for running Oracle 12c database. Now I am facing memory issue at OSlevel.
Here are the details of free -h:
[oracle@sa1 df_size]$ free -h
total used free ...
0
votes
1answer
34 views
Oracle impdb on windows generates a subdirectory
I am importing to a windows oracle, a dump file produced on Linux. But oracle generates a subfolder in the dpdump directory /76E0F91BE49D480CB2633847BD640FC5\ and causes an "ORA-31640: unable to open ...
0
votes
0answers
43 views
Oracle 12c - How to transpose rows to multiple columns using SELECT Query
I have a source table like below
PRO_ID IMD_ID URL
P1_400 P1_400_f /is/image/xyz/P1_400_f
P1_600 P1_600_f /is/image/xyz/P1_600_f
P1_900 P1_900_f /is/image/xyz/...
0
votes
0answers
25 views
Oracle MATCH_RECOGNIZE FUNCTION
I am working on a requirement that requires me to take a count of applicants that applied to same job group within six months period. Usually when an applicant applies for a job, they can be matched ...
2
votes
1answer
39 views
If the DBAs restored a single table from backup, would there be evidence anywhere in the data dictionary?
In Oracle 12.1, if the DBAs restored a single table from backup, would there be evidence anywhere in the data dictionary? If so, what would it be?
2
votes
2answers
51 views
Query to return all Oracle Deadlocks in 12c
Is there an object I can query in 12c to return all ORA-60 Deadlock alerts?
I just want to do a weekly report that outputs the number of deadlocks that have occurred and what schema they occurred on.
...
0
votes
1answer
30 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 |
--------------------------------------------------...
0
votes
1answer
49 views
Oracle 12.1 optimize_adative_features = FALSE ; using new statistics
In Oracle 12.1, does setting optimize_adaptive_features to FALSE mean that the optimizer will no longer use new statistics generated by dbms_stats.gather_schema_stats?
1
vote
1answer
49 views
Oracle Optimizer refuses to use my index
I have a relatively simple query that SELECT data in a table.
SELECT l.columnRecovered FROM schema.TABLE l
WHERE (column1 = :a or (:a is null AND column1 is null))
AND (column2 = :b or (:b is null ...
0
votes
1answer
111 views
Oracle installation error: “DBCA_PROGRESS : DBCA Operation failed.”
I tried to install Oracle 12c on CentOS VM (no docker), in the final step "Oracle Database Configuration", I got the error "DBCA_PROGRESS : DBCA Operation failed."
The VM has 64GB RAM, 500GB hard ...
0
votes
2answers
66 views
Safe to use SQLNET.ALLOWED_LOGON_VERSION_SERVER in 11g sqlnet.ora file?
I have a mixed environment running both 11g and 12c databases on the same server. One of our databases was recently upgraded to 12c, and the older Oracle clients have started throwing ORA-28040 ...
0
votes
1answer
55 views
oracle-mysql fast refresh materialized view
Is is possible to Create Fast refresh enabled Materialized view from MySQL to Oracle . i know steps for oracle to oracle Fast refresh enabled Materialized view. But now the scenario is need to ...
0
votes
2answers
128 views
Creating an Oracle 11.2-Compatible Database in Oracle 12.2.0.1
I am using an Oracle Docker image of 12.2.0.1 in my development environment:
https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles/12.2.0.1
There does not ...
1
vote
1answer
42 views
Measuring Character Set Conversion
We have an Oracle 12c (12.2.0.1) database server set up with AL32UTF8 (Unicode 5.0 UTF-8 Universal character set) character set as per Oracle recommendations.
However, the application that uses this ...
-1
votes
0answers
30 views
Full Hot Backup impact on database performance in oracle
I'm new to DBA, I have observed a few times database transactions are getting slow, sometimes seems to be stuck when full hot backup was going on and I know as per my knowledge when a full hot backup ...
1
vote
3answers
46 views
Performance tuning across two tables using indexes?
Let say I have two tables and a SQL query like this
SELECT table_a.*, table_b.*
FROM table_a, table_b
WHERE table_a.id = ?
AND table_b.col_x = table_a.col_x
AND table_b.id = table_a.id;
Would there ...
0
votes
0answers
26 views
Query time breakdown (parsing, “sub-fetching”, regular fetching)
Is there a way to distinguish the time a query spends on each of its execution stages (widely understood)?
My questions arises from the fact that I test two methods of data retrieval:
view vs. ...
-1
votes
0answers
48 views
Impdp error in MATERIALIZED_VIEW
i had take a structure backup on database. expdp works perfect. but while impdp i am getting error in mview to get ddl of Mview.
expdp :-
expdp abc/xyz full=Y CONTENT=METADATA_ONLY directory=di1 ...
0
votes
1answer
54 views
Oracle: Resetting an identity column vs resetting a sequence
An Oracle Identity column can be reset by simply changing its start value with an alter table... modify statement. Given that identity column internally uses a sequence, why is it not possible to do ...
1
vote
1answer
58 views
Turn off listener logging in oracle 12c release 2
I am trying to turn off listener logging in oracle 12c R2 (SAP on oracle), but I am getting a TNS-12508 error. I have verified that the listener.ora is owned by the oracle user and I am performing the ...
0
votes
1answer
39 views
SET_AUTHENTICATION_FROM_WALLET call returns ACL error
Running Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production. Have a wallet setup containing a basic authentication credential.
PL/sql package is executing a request over ...
0
votes
1answer
118 views
Database Hangs while impdp “DATABASE_EXPORT/STATISTICS/MARKER” at this stage
I am using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
i am facing issue while impdp on other server. it hangs at the last line message below. it takes min. over 2-3 ...
0
votes
1answer
44 views
Impdp 12c takes table original size
I want to import one of my schema "vvs1" to r&d database with content=metdata_only. expdp works perfect but when i am going to import on r&d server it takes tables original size.
for example:-...
0
votes
1answer
31 views
Extract values from oracle pl sql cursor
I have a function that returns a cursor. When I execute
select t.id, t.f_rc(id) from my_table t
I get
id F_RC(TID)
1 < cursor >
2 < cursor >
3 < cursor >
...
How to expand ...
2
votes
1answer
34 views
Network line switch-over in Oracle Data Guard
We have a Primary database with a remote Standby which established using Oracle Data Guard. They can be syncing over a private Wireless Network and a Wired LAN (There are two options as network medium)...
1
vote
0answers
107 views
Oracle XML Database database invalid, how to validate/recompile … can i drop and recreate it. Please suggest
The installed components and their status,
Oracle Database Catalog Views 12.1.0.2.0 Valid
Oracle Database Packages and Types 12.1.0.2.0 Valid
Oracle XML Database 12.1.0.2.0 ...
0
votes
0answers
20 views
Convert a query to a function
I have a query that counts nearby neighbors and looks like
select id, value /*stuff*/ from t start with ID=1 /*stuff*/ --returns result for id=1
union all
select id, value /*stuff*/ from t start ...
0
votes
1answer
33 views
Moving Oracle / Oracle datafiles to different file system on Linux
We have Oracle installed on /root, which is now running out of space due to increasing data in Oracle database. On the same machine we have another file system with free space.
I want to know the ...
0
votes
1answer
67 views
Is it feasible to escape ' (single quote) with ESCAPE clause, if yes, then how to do it?
I understand that we can use '' to escape a single quote in Oracle queries. However, I want to know if it is feasible to escape a single quote in the ESCAPE clause.
set up:
create table test_t ( x ...
1
vote
2answers
28 views
Difficulty Understanding Oracle DQL Procedures and Functions Coming from T-SQL
I am much more familiar with SQL Server, but I am doing a project now in Oracle. There is a concept from SQL Server that I am not sure how to accomplish in Oracle.
In SQL Server if I create a ...
-1
votes
0answers
95 views
39001. 00000 - “invalid argument value” error using DBMS_DATAPUMP.add_file
I been trying to use the Oracle Data Pump PL/SQL API to move data to AWS Oracle RDS. My export job is failing on my local installation of oracle database. Local database is 12c and RDS is 11g. I been ...
2
votes
1answer
43 views
Is it possible to name an ACL?
I need to create some ACL's to allow TCP connections to some hosts. These hosts can only be accessed by their IP address. To make them easier to keep track of in the future, I'd like to be able to ...
0
votes
1answer
30 views
Oracle TKPROF Insert data doesn't match text results
I'm trying to make sense of the output from a SQL Trace from an Oracle 12.2 database on Windows. I've used TKPROF to interpret the the resulting trace files. This utility generates a text file output ...
0
votes
1answer
95 views
ASM Space Usage
Oracle Version: 12.1.0.2
I had about 100 GB freespace on my +ASM diskgroup on Friday.
When I came back on Monday, I see only 45 gigs. How can I find what consumed my space?
Or is there a SQLPlus ...
1
vote
0answers
41 views
What is the cardinality in this situation?
I need to find the cardinality for a few tables in an Oracle database. I have been given a word document that has a list of tables described with details as shown in the image:
I have been reading ...
