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.

Filter by
Sorted by
Tagged with
0
votes
1answer
12 views

Oracle 12cR2 User Can Select Table Without Privilege

I noticed an interesting thing today. Consider a system where the production and test databases are equipped with the same privileges. In the production database, a user can select the table under ...
1
vote
0answers
32 views

Problem with "in" a system query in Oracle

I have this query and I want get the top 5 of force_matching_signature. After that I want to display additional information for each of the sub results. The following query works fine when the IN ...
0
votes
0answers
12 views

Truncated Bind on simple Coalesce

Changing nvl to coalesce should in theory be a drop in replacement function that provides the benefit of short circuit evaluation allowing the second parameter not to be evaluated. This can be of ...
0
votes
1answer
17 views

ORA-01109 Error (Database Not Open), But It's Open in SQL Plus - Oracle SQL Developer

I'm getting the error "ORA-01109: database not open" in Oracle SQL Developer, in Oracle Database 19c and SQL Developer 21.2.1 Windows 64-bit. I've gone into SQL Plus to open the database and ...
0
votes
0answers
13 views

How to solve Error ORA-16810: multiple errors or warnings detected for the member?

Oracle Enterprise Manager 13.5 constantly reports Error ORA-16810: multiple errors or warnings detected for the member. ... Target type=Database Instance Target name=xxxx Categories=Availability ...
0
votes
1answer
15 views

Oracle Forms 12c key next item not running on execute query

I am running oracle forms 12c I have a client_id, client name, and contact number fields where if I type client_id it gets the clients name and contact number and those fields get populated but when I ...
0
votes
2answers
29 views

How to make a restricted view in oracle?

I had to provide data for an application schema, but there is a requirement that the applications connecting using that schema user cannot query more than five rows at a time, the application queries ...
1
vote
1answer
48 views

Truncate huge table of 6.4TB - Oracle

I've never truncated a huge table like that. How long can it take? or will be a millisecond or so like usually? Can I have some issue during this operation? this table has 1.4TB size plus 4.8TB of lob ...
0
votes
2answers
44 views

How to connect to Oracle RAC from HOST

For a college project, I have to set up a RAC Instance and an application, I already managed to configure my RAC lab by using virtual machines by using this video guide, now I just need to program an ...
0
votes
3answers
41 views

Oracle, defining variables in a WITH query

Just wondering if it is possible to define variables in a WITH query? I've tried but query keeps failing. Just something like WITH DEFINE var1 = 'ABC'; SUBQUERY1 (col1, col2) AS (SELECT col1, col2 ...
0
votes
0answers
38 views

Oracle Cerfication 12c OCA vs. 19c OCP

Is there somebody who has both certificates 12c OCA and 19c OCP (Administration)? 12c OCA: https://education.oracle.com/oracle-database-12c-administrator-certified-associate/trackp_248 19c OCP: https:/...
0
votes
1answer
45 views

Trigger created with compilation errors

SQL> create table master(pno number(5) primary key,pname varchar2(20),price number(10,2),stock number(5)); Table created. SQL> create table trans(p_no number(5),no_pro_sold number(5)); Table ...
0
votes
2answers
43 views

Oracle 12cR2 RAC - ORA-06508

Environment: DB Version: Oracle Database 12cR2 EE on Exadata RAC: True Problem: ORA-06508 on procedure. One of our users had a DBA role privilege, we don't want such a big privilege to be defined ...
0
votes
0answers
22 views

See Max Simultaneous Sessions Per User

In an effort to set a reasonable sessions_per_user profile setting for shared database accounts or other non-unique account (ie. an account an application uses to log into the database for all app ...
0
votes
0answers
18 views

Create a unique local index and ORA-14039

I'am trying to partition a index from a primary key. For that, I've done: Disable the constraint. SQL> alter table DANILO.SUB_PAT_TEST disable constraint SYS_C007918; Table altered. SQL> Try ...
0
votes
1answer
26 views

Will purging listener_scan1.log, listener_scan2.log, listener_scan3.log in Oracle 12C RAC Configuration not affect database services negatively

I have a got a oracle 12c database configuration where there is RAC configuration for DB01 on one server and DB02 on another server. The issue i have is that the listener_scan1.log, listener_scan2....
0
votes
0answers
5 views

SSIS - Attunity 5.0 Oracle destination running for hours yet row count shows data has arrived so why does the dest task look in a hung state?

Using SSDT v14 A simple package that extracts data from a SQL Server view and sends via Attunity to Oracle takes about 5 hours to run, of which 4 hours seems to be the Oracle destination task showing ...
0
votes
0answers
50 views

Oracle Query Performance

I have a query that I need it to be execute fast as possible. Even though I have indexes, it is executing very slowly and I can't figure out why. This is the query, I am trying to optimize. SELECT d.*,...
0
votes
1answer
10 views

oracle query to split data into per-date rows

I need to create a report which splits the values from table A into a row-by-date format. So for example If I create a sub-set of dates for the past week and sales in the past week, I need to output ...
0
votes
0answers
28 views

How can i Restore Oracle 12c database Schema from a full EXPDP dump on a Test Server providing a new scheam name?

I have a production database whose full dump is 500Gig and and I cannot do a full restore on a test server because of space issues. However I need to restore a certain schema in from that dump into ...
-1
votes
0answers
20 views

Join Two Tables with get value AsssetCode from Max Date

I'm trying join Two tables: KDSCMSCNTRCTD CNTRCTDID | CNTRCTDCOMP | CNTRCTDLNUM | 3221 | NAV | 207 KDSCMSCNTRCTDHIST CNTRCTDHISTID | CNTRCTDHISTSDATE | CNTRCTDHISTCOMP | CNTRCTDHISTLNUM | ...
0
votes
1answer
20 views

Query to show whether a record is appeared in the previous date or not

I have a table with below structure and sample data: create table TEST_ONE ( purchase_date DATE, customer_id NUMBER ) | purchase_date | customer_id ---------------------------------- |...
0
votes
1answer
68 views

How do I SHOW TABLES in Oracle Database?

I'm trying to do a SHOW TABLES command in my Oracle Database 19c as documented here. But when I run that command all I see in the output of SQL Developer is this: Show tables handled. How can I get ...
-3
votes
0answers
24 views

ORA 20014 ERROR USER DEFINEEXCEPTION WHEN TEST ING THIS I GOT ERROR FILE NOT EXIT I AM PASSING FILE FROM PROG ERROR AT LINE 3 LINE 43 AND LINE 111

create or replace procedure SP_webconfigsave( Oresult out Varchar2, Icsoftwaretype char, ...
0
votes
3answers
37 views

Does using "qb_name()" hint (query block name) in a query have significant effect on performance?

I've just become familiar with the hint "qb_name" (query block name) in Oracle and below you can see an example of using this hint in a query: select /*+ qb_name(main)...
1
vote
0answers
33 views

RMAN: not Connected to Database

While issuing the Restore Database command, the RMAN utility says Not Connected to ORACLE, but When I try connecting Oracle using the command Connect Target it says Already connected to ORACLE. All I ...
0
votes
0answers
25 views

Communication error between Oracle and Nagios

I'm trying to adapt some Perl scripts to Bash to run them in Nagios XI. The complete script, so far, is this one: . /home/oracle/.profile_RAC ORACLE_HOME=/oracle/app/grid/19300 ORACLE_BASE=/oracle/app/...
0
votes
1answer
25 views

Oracle - EXECUTE on package without explicit privileges

I'm trying to understand package permissions in Oracle. If user A is granted EXECUTE on a package owned/created by user B, and that package makes various inserts and updates to a table owned by user B,...
0
votes
1answer
25 views

Difference between oracore and oracore3 folder?

I'm trying to fix a timezone file mismatch between a server and a client. The server points to timezone_36 files and the client points to timezone 32. I got a patch from our oracle supplier but it ...
0
votes
0answers
20 views

How to store data in loop and after assign data set to out ref cursor in Oracle

I tried to store date in loop and after that dataset set to OUT SYS_REFCURSOR. In this time I declared array variable and I tried to store data in loop by each iteration. and after, I want to assign ...
-1
votes
1answer
38 views

I have error in one machine from ORACLE cluster

I am using Oracle 10g Cluster. So, the listener on 1 Oracle machine hasn't been working for a week now. I get an error: ORA-12541: TNS:no listener When I want to start listener from oracle user, ...
0
votes
1answer
21 views

Stop Dataguard configuration to test standby database

I would like to know how it would be the correct way in which I should proceed to stop the Dataguard configuration in order to perform a series of tests on the standby database. It turns out that I ...
0
votes
1answer
41 views

Oracle 12c - Logon Trigger According To Machine Information

I want to create a logon trigger. Trigger will do the following: It will block access to the database based on certain users and certain machine information. Then it will give an information message ...
0
votes
1answer
37 views

Does trailing wildcard use index? (where column like 'value%')

I have a query on a Varchar2 field in an Oracle table: select column from tbl where column like 'value%' That query uses a trailing wildcard. Question: Is Oracle capable of using an index on that ...
0
votes
0answers
25 views

Concatenate external variable into Select Statement with no. of TABS based on length of external variable

Could someone please help with this requirement. WHENEVER OSERROR EXIT FAILURE WHENEVER SQLERROR EXIT SQL.SQLCODE FAILURE SET newpage none SET trimspool ON SET feedback OFF verify OFF tab OFF echo OFF ...
0
votes
0answers
32 views

Oracle will not start with ORA-01092: ORACLE instance terminated

I'm in need of urgent help with this one. My Oracle 11gR2, running on a VM, crashed when the datastore of the host filled up. I got the VM to start and as I'm trying to start the DB, I see this: ...
-2
votes
1answer
50 views

What is the best way to migrate from Oracle Non-CDB to CDB architecture? [closed]

We have to migrate hundreds of NON-CDB 19c Database to CDB 19c architecture. What is the best way to do that? All Oracle databases have version 19.12.
-2
votes
0answers
29 views

Need help with Oracle Archive Log Removal Script

Hello is someone kind enough to share a script to remove Oracle Archive Logs based on size threshold? (OS Level) I noticed a ton of post that removed archive logs based on Log size or date but I was ...
0
votes
1answer
29 views

Options for handling a column that is an instance count

Consider the following table CREATE TABLE example ( example_id NUMBER, -- PK parent_ref NUMBER, -- FK to parent variant VARCHAR2(8), -- An arbitrary string ...
0
votes
1answer
37 views

how oracle data guard operate SCN?

when use data guard, primary propagate redoLog and standby apply redo log. the transaction inner redo log was applied on standby will has same SCN with primary ? the apply action will cause the ...
1
vote
0answers
26 views

Extremely slow updates to small Oracle table from rails app (oracle r12 and r19)

I'm not sure if this is a rails issue, or a database issue, but as this seems to be a schema specific issue, I'm looking at it from the database side first. (Other customers with the same setup on ...
1
vote
1answer
19 views

action can't be completed cause file is open in oracleserviceorcl

I want to delete the files I installed of oracle but it says action can't be completed cause file is open in oracleserviceorcl . is there a way to delete it ?
0
votes
0answers
21 views

FGA AUDITING does not record audit

hello i dont know why my fga auditing is not working my code EXEC DBMS_FGA.ADD_POLICY(OBJECT_SCHEMA=>'PLSQL', OBJECT_NAME=>'REGIONS', AUDIT_COLUMN=>'REGION_NAME', POLICY_NAME=>'REGPOL', ...
0
votes
0answers
31 views

DBMS_HS_PASSTHROUGH Bulk Fetch

i have question about DBMS_HS_PASSTHROUGH geting result set without stored_procedure i have oracle and i have database link so i am running this query select * from table where id >20 via ...
0
votes
0answers
34 views

how to get all ROWIDS of a chained row in Oracle Database

From Query change notification receiving a row id. with the received row id when i query the table it is returning no rows. as the table have the 400 columns row data is stored in 2 blocks which in ...
-1
votes
1answer
25 views

crontab not executing oracle database image copy

Dears i have an rman script for a full Oracle Database Image Copy that i have made and i have added it to a crontab job and buts it is not getting executed and i dont know why: below is the database ...
1
vote
1answer
20 views

EXPDP - why is block estimate significantly larger than segment size?

I'm exporting one specific table for a schema which I thought was a relatively small 5.4 GB SQL> select bytes/1024/1024 MB from user_segments where segment_name='TABLENAME'; MB ---------- ...
1
vote
1answer
19 views

SSIS: Can't save "parallel load" option in Oracle destination with Attunity driver, how to solve this?

I am working on an existing SSIS package that has proven to run successfully, however, due to data volume issues, I would like to try enabling the "parallel load" option by selecting the ...
0
votes
1answer
25 views

What if a diskgroup runs out of space?

For my BD I have a DATAC8 diskgroup that has still have 38 GB usable space, day by day, it has less space... what will happen when it's over? can the BD stop or something?
0
votes
1answer
44 views

Listener oracle in pacemaker cluster

I need some help. I have created a cluster with 2 nodes. I created all resources, but listener has errors and the pacemaker cluster status shows Oracle Listener has stopped. In the web interface I ...

1
2 3 4 5
148