Questions tagged [oracle-12c]
Oracle Database 12c. Please also tag oracle for search purposes.
0
votes
0answers
11 views
Adop prepare failed due to the Node Manager is not up
While i am running adop prepare stage in 12.2.6 , getting a error WLSTException: Error occured while performing nmConnect : Cannot connect to Node Manager. : Connection refused. Could not connect to ...
0
votes
0answers
10 views
How many keys does wallet keystore have?
I my scenario I have configure transparent data encryption with password based
software keystore only for example 'ewallet.p12' and create a master key for software keystore.
I want to know can we ...
-2
votes
1answer
38 views
Getting syntax error on Match_recognize [closed]
I am working on a requirement that requires me to check for cases where an employee has applied for multiple job openings. If they apply for the same job names then I need to pass it as F otherwise T.
...
0
votes
0answers
12 views
Oracle Apex 18.1 installation problem windows server 2016 (db 12c)
I am trying to install oracle apex 18.1 in windows server 2016 on database 12c.
After login sys as sysdba when I give the command:
@apexins.sql sysaux sysaux temp /i/
then this error occurred.
...
0
votes
1answer
25 views
does sequence of columns in where condition matters the sequence of composite key? in Oracle Database
here, In the code where exists clause contains all primary key columns in where, I want to know that the sequence of this columns in it, matters in query performance.
update temp_fd_dtl_svj a
set ...
-1
votes
0answers
18 views
I need to pivot the the input table in to this format using oracle
Input format of the table:
Needs to be converted into this format:
Using a PIVOT.
1
vote
1answer
53 views
ORA-48108 / ORA-48140 / ORA-48187 - diagnostic_dest value error(s) - init files / control files
This is all testing / training - none of this is related to a production env
Using ORACLE DB 12c + UNIX/LINUX 64-bit on an VM.
.
Hi Guys!
I am running in the below error(s) and seem unable to ...
0
votes
0answers
20 views
Missing bind variables in EM Database Express query download
I am investigating slow performing queries using Oracle Enterprse Manager Database Express and wanted to download the SQL text from the console. It gives the option to save the bind variables with ...
0
votes
2answers
61 views
Welcome message for oracle schema
I want to display welcome message when ever a oracle schema try to login database using TOAD or PLSQL developer only
0
votes
1answer
23 views
ORA-14224 Deferred Segment Creation is not supported for this schema
I'm trying to use deferred segment creation and not having any success.
My deferred_segment_creation parameter is set to TRUE, but new tables do not defer. I've also tried explicitly stating SEGMENT ...
0
votes
0answers
21 views
Test connection between application and DB using Oracle instant-client
Good morning
I have on one side an 12.1.0.2 Oracle database server and on the other side an application server which is running Windows Server 2012 R2 Standard.
Client connection to the database are ...
0
votes
1answer
12 views
Does tables under schema uses multiple tablespaces other than default tablespace
I have schema 'A' in a database and assigned a default tablespace as "myspace".
There are 20 tables resides under single schema and all tables are using different tablespaces.Here my doubt is "Why ...
0
votes
1answer
21 views
Consume data from other database motor from stored procedure in Oracle 12c
I have a project in which you must develop services in Oracle OSB which will call a procedure stored in Oracle 12c. The issue is that I also need data from an Informix database to build those services....
0
votes
0answers
28 views
Restrict Oracle database schema to login using Toad/PLSQL [duplicate]
I want to restrict my Oracle database schema for example john to login to database using tools like toad or PLSQL developer. this schema is used for application login using JDBC thin client. I cannot ...
1
vote
1answer
36 views
Is EXPDP the best backup approach when running Oracle on Windows with no RMAN?
Well, I'm the SQL Server DBA here, and we have a Oracle Senior Dba that manages Oracle Databases and users. I'm curious about how he is handling these servers/users.
What is the best approach, when ...
0
votes
0answers
21 views
Access tables from multiple schemas
I have two schemes with multiple tables. The queries in packages heavily reference schema names. Is it possible to remove schema names from the queries and oracle to identify the tables based on roles ...
-1
votes
0answers
18 views
Refer table from another schema
I would like to refer to multiple tables in another schema without schema prefix or altering the session.
I have the below query -
Select * from schema1.app_table
There r multiple queries like these ...
0
votes
0answers
3 views
Keeping INSTANCE_NAME on Data Guard failover
I have a legacy application which uses a lot of PL/SQL stored procedures. It has a deeply ingrained need to know in which environment it is running, and uses the INSTANCE_NAME for that. For the sake ...
0
votes
0answers
11 views
Get the current upper limit value for nvarchar2 in an Oracle 12c db
Starting from 12c, Oracle Database provides a way to control the max byte-size of a NVARCHAR2 column. To use up to 32767 bytes instead of 4000, one has to set the parameter max_string_size to EXTENDED....
2
votes
1answer
42 views
START WITH and CONNECT BY condition in Oracle SQL
I have a question on the START WITH and CONNECT BY condition (in Oracle 12c):
This is my Oracle SQL:
SELECT
employee_id,
lpad(' ', level*2-1,' ') || last_name,
manager_id,
level,
...
0
votes
0answers
25 views
audit policy on a table does not log expected results
Running on Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production. Attempting to test auditing with the following steps:
Created a new user, MYUSER.
CREATE TABLE mytest (
id ...
0
votes
0answers
7 views
Oracle: set prefix to log messages
Is there any way to add a prefix to the log messages in an Oracle DB?
In PostgreSQL, for instance, there is the application name that can se set as a prefix to any message.
Is there any function I ...
0
votes
1answer
23 views
Why does the system generated TNSNAMES.ORA have two entires, one with a full connect descriptor and another with just a network address?
My TNSNAMES.ORA file was auto-generated when I installed my database. It generates with two entries for my database however. One entry looks "complete" with a full connect descriptor, while the 2nd ...
0
votes
1answer
18 views
Oracle set schema in a PreparedStatement
Using an Oracle Database through a Java application, I need to execute a SET CURRENT SCHEMA statement using a PreparedStatement to overcome potential SQL injection.
So, I cannot do
public void ...
1
vote
1answer
25 views
Added a new listener to my 'listeners.ora' file. How can I connect directly to it with SQLPlus? (skipping tnsnames.ora for now)
I updated my listeners.ora file to include a new listener on port 1523. I then started the listener with lnsrctl start. I'd now like to connect to the database on that port via SQLPlus without ...
0
votes
1answer
33 views
Error (2.17): PLS-00201: The identifier 'DAYS_INTERVAL_TABLE' must be declared
I recently installed an Oracle 12c in Oracle Linux 7.6, it was previously in Windows. In the first database restored, some functions are with compilation errors.
The query below informs you that ...
1
vote
0answers
36 views
Cannot access remote table after parallel/insert direct load txn
This is the Oracle error message I'm getting ORA - 12840.
We just upgraded from 10i to 12c version and some of the processes aren't working as they did before. I get this error when I execute a CREATE ...
0
votes
0answers
11 views
Compute subnetwork in Oracle PL/SQL
I have a table of links with startnode and endnode as strings:
create table my_links as (
select 'AZ' as nodeid, 'A' as startnode, 'Z' as endnode from dual union all
select 'AB', 'A', 'B' from ...
0
votes
1answer
120 views
ORA-27102: out of memory
We're facing an Out Memory Problem with an Oracle database SE 12c Release 1 (deployed as a Docker container) ...
The only information that I have is this one:
Caused by: java.sql....
2
votes
0answers
37 views
Oracle impdp error when importing data
I get this error ORA-02289: sequence does not exist when I try to import a schema to my database, could you give me some recommendation?
Import Command:
impdp '"sys/mmm as sysdba"' directory=...
1
vote
1answer
31 views
Oracle linked server shows all tables from all schemas in sql server management studio
I have created a linked server to an oracle database ( 12c ) in sql server management studio. I am mapping the local user to a special remote user in the oracle db. Connection is working fine. The ...
0
votes
0answers
21 views
Oracle impdp only imports one schema from a dump into which expdp exported many schemas
I have the following problem and doubt in Oracle. I am trying to import with impdp a dump from my database into which I exported several schemes.
The problem comes when I try to import into the same ...
1
vote
0answers
41 views
oracle slow query with diferent user
I have a question with an oracle query that takes almost 20 minutes when it is executed from a schema and yet when it runs as sys users it runs in 1 second maximum ... how is this possible? ... I do ...
0
votes
0answers
48 views
ORA-00955 Object name already exists when it actually doesn't
I'm using PowerDesigner to model my database. I'm creating tablespaces and setting the correct properties to columns, tables, indexes, etc. (at least I think so).
With PowerDesigner, I can then ...
1
vote
2answers
65 views
Create dynamic folder using SQL*Plus
I need to create directory in Linux with date stamp from SQL*Plus. Is there a command that can be run in *.sql file to create a directory with current date?
0
votes
1answer
25 views
Oracle PL/SQL find nearest object
There are two tables containing objects and their coordinates. One contains hotels, the other contains restaurants. How to build a table that for each hotel lists nearest restaurant name and the ...
0
votes
1answer
48 views
Where is the database SERVICE NAME defined and what is the proper method for changing it?
I'm researching the connection methods for an Oracle 12c database and I understand the difference between an SID and Service Name, but I cannot figure out where the service name is defined or how to ...
1
vote
2answers
27 views
Comparing duplicates and choosing the duplicate with most recent date in a join
Assume i have table A:
id: name: timestamp:
1 Bob 2018-05-31 04:46:37
2 Alice 2019-01-31 07:13:56
1 Bob 2019-01-15 18:23:74
And i want to join with another table B:
...
1
vote
1answer
86 views
expdp Hangs at DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM in oracle 12c
Expdp Hangs at Below Stage for long time even in structure backup also .
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type ...
0
votes
2answers
92 views
Does anyone know of resources for the Oracle 1Z0-072 exam objectives?
I am currently studying for the Oracle 1Z0-072 certification exam and I'm finding some of the early objects very ambiguous and difficult to study for. Topics such as:
Relational Database Models
...
-1
votes
1answer
51 views
What query can i use to get me the desired results in this example [closed]
This screenshot shows the results of my first query when I run this query to get a correct count of active_flag using `
select distinct act_flag, empid, emplmnt_date
from mytable;
it give me the ...
0
votes
1answer
22 views
Getting ORA-32042 even though i can create the view in SQL Developer
I have a strange problem creating a materialized view using the code generated by the export wizard.
I have created a materialized view and pasted following code into the sql query tab from the popup....
4
votes
3answers
61 views
How can I pass on a value in the hierarchy based on the value of the parent using an hierarchial query?
I have a table with categories and another table with a discount for categories per user:
create table category
(
id NUMBER NOT NULL,
parent_id NUMBER,
name nvarchar2(255),
PRIMARY KEY( id)
)...
0
votes
3answers
85 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 ...
1
vote
0answers
41 views
Impdp (Oracle 12c) on Ubuntu 16.04
I am trying to import a dump into Oracle 12c by using the below command:
impdp SROUSER/<password> directory=dump_dir dumpfile=SROUSER.dmp logfile=dp.log full=yes
Which is resulting in the ...
0
votes
1answer
47 views
How to sort categorical values by an arbitrary order?
I have a table called ANIMALS which looks like this
| name | category |
------------------------
| fluffer | CAT |
| tooter | ELEPHANT |
| tooter_jr | ELEPHANT |
| woofer | DOG ...
0
votes
1answer
23 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
58 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....
-4
votes
1answer
54 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
34 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 /...
