Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

0
votes
0answers
9 views

call store procedure from sql devloper

How to call store procedure from sql developer which is using two out parameter 1. Number 2. SYS_REFCURSOR i have tried this way in sql developer but giving error, the same i can run from sql ...
0
votes
1answer
18 views

Select from one table where range is held in columns belonging to another table

I am trying to write a SELECT statement in Oracle SQL where I have a TABLE A with a "START" column and an "END" column which holds division numbers. I want TABLE B to only extract those division ...
1
vote
1answer
28 views

Oracle - Can't login with “/ as sysdba”, but can with “sys as sysdba”

I've been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container built from Oracle's dockerfiles and it is working fine, except that I cannot login using connect / ...
0
votes
1answer
35 views

Restore or reset Oracle database (No Flashback features)

I am running Oracle Database 11g Release 11.2.0.4.0 - 64bit Production Seem it not Enterprise edition, so I not able to use flashback features SQL> ALTER DATABASE FLASHBACK ON; ALTER DATABASE ...
0
votes
0answers
26 views

Run query dynamically in store procedure oracle

Problem Select all the tables of database where column match than pass table name to next query using loop. If column name and column values matches than return true and exist for loop CREATE OR ...
-2
votes
1answer
22 views

What are the default accounts in version 12 of oracle db [on hold]

What are the default accouints in version 12 of oracle db. (SYSTEM, etc.)
0
votes
0answers
36 views

How can i add a sub query for a new column on this table? [on hold]

This query creates a table but the resultant table has dups on ACT_CAND , i can get the correct count on ACT_CAND but only after running a subquery on the table. I am looking for way that i can get ...
0
votes
1answer
39 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 ...
-1
votes
0answers
34 views

Software to read or extract the data flow from databases

I want to know if exists some application or an easy way to retrieve the data flow from databases through triggers. Problem: Know all the data flow since the data comes to the the first database and ...
0
votes
2answers
43 views

Select Column Values from all the tables of database ORACLE

I am trying to fetch column value from all the tables of database where column value matches. Table A CAMPUS_ID 1 Table B CAMPUS_ID 1 Expected Result TABLE VALUE A 1 TABLE VALUE B ...
0
votes
1answer
10 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
51 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....
0
votes
3answers
59 views

How to set listener.ora and tnsnames.ora for oracle instances

I set listener.ora and tnsnames.ora, but I do not know if it is well set up. When I call the lsnrctl status command, I get instances rcadb and proddb unknown. I'm a beginner in Oracle, I installed ...
0
votes
1answer
189 views
+250

What is a “PARTITIONED OUTER JOIN”?

This just came up in a question on Reddit, and I'm wondering What is a PARTITIONED OUTER JOIN in Oracle? (definition) What does a simple example look like? (use) How would you write it in terms of ...
1
vote
2answers
38 views

How to name a constraint which was unnamed during the table creation?

I had created the table by specifying the columns as primary key and not null without giving them any constraint names and I have populated the data. I want to give names to them now. How do I do ...
1
vote
1answer
44 views

Is it possible to show DML that is locking some table?

I already saw here how I can list my locked objects. Suppose I, using PL/SQL Developer(pink cylinder logo one), run select * from someTable for update and didn't commit nor rollback. Now using the ...
1
vote
1answer
36 views

Is it possible to login to an Oracle schema using a certificate?

The question is based on having to deal with lots of automated processing (testing, mostly). As it stands, all the schemas used have the same well known password, which is stored in lots of ...
0
votes
1answer
28 views

Oracle SecureFiles LOBs Licencing

We argued in our DBA team on whether an Oracle Database with SecureFiles LOBs needs to be an Enterprise Edition. Can I use Oracle Secure File Lobs in a Standard Edition?
0
votes
0answers
45 views

TNS-12560: TNS:protocol adapter error

I cannot access oracle from remote due to my listener error. I checked all configuration files which are listener.ora, tnsanmes.ora and sqlnet but I didn't find any missing config. Below is my ...
-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 ...
0
votes
1answer
35 views

Does an ad hoc, full backup, using Oracle RMAN, flag files, so they are not backed up by the regular backup?

If I run a simple RMAN full backup, ad hoc, outside of the regular backup scheduled, does that flag files so when the regular backup runs, that regular backup won't get some of the log files? For ...
2
votes
1answer
21 views

Oracle number precision datatype performance impact

Does number size affect to speed of inserting, updating, ...(DML operations) rows? If i use number(20) instead of number(6), does it impact performance?
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
2answers
53 views

ORA-22285 Error while trying to register an xsd schema on oracle database

Here is the code for user "system" create or replace directory xml_mape as 'D:\app\Gusts\xml_mape'; GRANT READ,WRITE ON DIRECTORY xml_mape to lietotajs; Im trying to access the xsd file "dok1_shema....
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
2answers
65 views

Leading zeros are truncated when I spool to CSV

I have spooled a file to CSV using sqlplus. Everything works great but there is one issue. I have mobile numbers which start with 0, for example 04589 and 02586. After the spooling is complete, 0s ...
0
votes
0answers
50 views

Serving Oracle LOBs on a modern streaming web server? [closed]

Some kernels, like Linux, support POSIX sendfile, sendfile() copies data between one file descriptor and another. Because this copying is done within the kernel, sendfile() is more efficient ...
-2
votes
1answer
66 views

Do “Oracle Streams” have anything to do with the “Oracle Stream Class”?

Oracle has a concept call "Oracle Streams" which is extensively documented. Does this have any relation to the "Stream Class". My assumption is no, and that they're entirely distinct but ...
1
vote
2answers
33 views

Can you get a filehandle to an Oracle SecureFile LOB?

Does Oracle's SecureFile LOB allow me to obtain a filehandle to the underlying resource. Both PostgreSQL through lo_open and SQL Server with FILESTREAM's OpenSqlFilestream allow you to get a native ...
0
votes
1answer
53 views

Issues migrating Oracle Database from 11g R2 to 12c [closed]

A couple of weeks ago a database using Oracle 11g R2(11.2.0.1.0) was migrated to Oracle 12c (12.2.0.1.0). Since the migration I have performance and DML/DDL issues like Can´t create new indexes or ...
0
votes
2answers
50 views

Oracle Database LOB increases untypical

An Oracle 12c production database includes tables with a BLOB column. Usually the growth rate is 2GB per week. This is the table create statement: CREATE TABLE XXX.FILEENTRY ( FILENAME VARCHAR2(...
0
votes
1answer
36 views

Oracle 11g stuck at installation in oracle linux no error msg only showing | and stuck

oracle not install on centos7 while installation it is stuck at 84% no error msg showing
0
votes
0answers
32 views

Collect data checklist from different table

I want to collect data checklist from 5 different table. in example table c have data with same foreign key "id_name" then its state "yes" else "no". This is my sql statement select a.id_name case ...
-2
votes
0answers
38 views

Is it possible to generate a deterministic GUID in Oracle database? [closed]

In Oracle, SYS_GUID() function generates a different unique GUID every time it is invoked. Is there a way or possibility to generate deterministic unique GUID with a given unique input value? Ex: I ...
0
votes
1answer
49 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
57 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
25 views

Question on Auditing 12C

I have the following configuration information: audit_sys_operations TRUE audit_file_dest ...
0
votes
2answers
42 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 ...
-1
votes
1answer
27 views

normal hexadecimal to 0x hexadecimal conversion in oracle

i am using rawtohex to convert clob data to hexadecimal value as below: SELECT RAWTOHEX(to_char(substr(fmla_txt,1, 4000))) as result FROM pmry_fmla_flng where WKSTN_OID_SH = 100 and WKSTN_OID_LNG = ...
0
votes
1answer
20 views

How to print empty string as a result from xml node creation using oracle in a procedure

i want to print one of the node value as Author ="" empty string in xml node element as below: This syntax is in oracle: CREATE OR REPLACE FUNCTION GetRtData ( pf_wkstn_oid_sh number, ...
0
votes
2answers
48 views

Splitting Comma Separated string into columns by using REGEXP_SUBSTR

Here is my example string: select 'po1,qty1,po2,qty2,..,POn,QTYn' str from dual. The string length is dynamic. It may have more than one PO and QTY. Now, I want the output displayed as all the POs ...
0
votes
1answer
31 views

Help understanding the password file

I have one database and password file Now I'm creating a new database, do I need to create another password file or not? I'm a beginner in Oracle, maybe a bit stupid question. Thanks in advance
0
votes
0answers
36 views

What is the best way to update a few table objects of of database1 from the same structured table objects of database2?

Sorry, if I am wrong! I studied that import/export, dump, golden gate, db link can be used in oracle database logical objects updation. Please guide me in selecting proper method/tool for logical ...
0
votes
1answer
28 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 ...
3
votes
3answers
862 views

Database Connection vs Raw TCP Connection [closed]

I have some fundamental questions about how database clients & database interact Do databases support multiple transactions simultaneously on a single database connection from client? If not, why ...
0
votes
0answers
30 views

Clear Oracle database shard state

Have had some problems with Oracle sharding infrastructure configuration. Particularly added a shard into wrong shard space. Removed it (probably needed to move the chunks first) with -force option ...
0
votes
1answer
83 views

Why select statement against a table in oracle returns ORA-04021

I have a big partitioned, local indexed table in Oracle database, what I am doing is import a big dump file into it with "impdp" Why when I issue a select statement against that table Oracle returns ...
1
vote
2answers
65 views

What happens when sga and pga reach limits?

I have the following doubt, I have a server with Oracle 9i and another with Oracle 12c, in both cases I have the doubt that happens when Oracle reaches the limit imposed by the defined memory ...
0
votes
1answer
46 views

How to create stored procedure that returns query result?

I have query that has a lot of columns (about 30) and I would like to place that query in stored procedure. The reason behind that is because this query is used in multiple places in the system. There ...