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
0answers
39 views

Oracle database EXP default directory

I am trying to export a table under a user schema in oracle using the EXP command. I am doing this on the command line. This is the syntax that I used: EXP scott/passcode TABLES=users STATISTICS=none ...
0
votes
0answers
13 views

Unit Testing ORDS - Oracle Rest Data Services

I've been wanting to develop some unit tests for my ORDS functions as part of my push for better CI/CD - I am running ORDS functions on an Oracle Autonomous Database 19c, and while I'm developing a ...
0
votes
2answers
21 views

Move Oracle to new drive

I have a customer who currently runs Oracle on Windows (not my choice, I just have to deal with their current setup) The basic layout of the server C:\ - operating system and oracle application D:\ - ...
0
votes
1answer
28 views

Adding multiple files to a tablespace

In Oracle, we have huge amount of data imported daily, which requires us to create data files off and on in a tablespace. Wonder if we create two data files simultaneously, will it use both when one ...
0
votes
1answer
28 views

How to quote a SQL*Plus identifier in a bash script?

I get "ORA-00904: "MEMORY_TARGET": invalid identifier" no matter how I try to quote the identifier in the following command: MEMORY_TARGET=$(su - orat01 -c " echo 'select ...
0
votes
3answers
40 views

Oracle - Is a separate database more secure than using the same database and a separate schema

We have very few developers and the ask from management is insane (computer vision, AI, IoT, etc.). Management wants to split the production database which uses Oracle Apex because the Apex ...
0
votes
0answers
20 views

How to avoid GROUP BY on one field in Oracle SQL

i'm using a query : SELECT t.tID, min(t.CONTEXTTIMESTAMP) contextTime, CONCAT(' ',CONCAT(ac.NAME, CONCAT('=',ac.VALUE))) as idf FROM TABLE1 t INNER JOIN ( select t....
0
votes
0answers
7 views

Oracle Audit Vault Create Custom Interactive Report

I have installed and configure Oracle Audit Vault server and i deploy my production database environment to Audit Vault which is sys.aud$ table. I can get predefined reports which is like entitlement ...
-1
votes
0answers
14 views

Oracle 19c impdp hangs on SCHEMA_EXPORT/VIEW/VIEW

I have attempted multiple datapump imports into a new Oracle 19c database. The datapump backup was created from Oracle 12.2 environment. I verified I could import in another Oracle 12.2 environment ...
0
votes
2answers
16 views

Oracle: Scopes of the CURSOR_SHARING parameter

In Oracle databases (12.2 and above), is it possible to configure the CURSOR_SHARING parameter differently for different schemas, tables or views, or is that parameter always global?
-2
votes
0answers
17 views

Best and quick approach to Oracle Database Backup and Restore options? [closed]

Here I will add tested backup and restore options for oracle.
0
votes
1answer
24 views

Create ORACLE TRIGGER which (INSERT OR UPDATE) in TABLE1 whenever a new INSERT is done in TABLE2

i'm trying to create a TRIGGER for my Oracle database. I Have 2 tables in it(table1 , table2) Table 1 has 3 columns (id, name, value). id can be non unique here Table 2 has 2 columns ( id, concat) id ...
0
votes
0answers
19 views

Liquibase on Oracle SQLcl - table and index drops not being propagated

I've been using Oracle's SQLcl, specifically the lb command to use Liquibase, for the last day or so to use for versioning my development, staging and production databases, which are using Oracle's ...
0
votes
1answer
10 views

Oracle 11g - Database Job About User Lock

I have an Oracle database (Oracle 11gR2) and I want to create a job. The job will trigger my procedure. The procedure must comply with the rules I have specified below: If a user's expiry_date value ...
0
votes
1answer
38 views

Deploying Oracle ADW Changes from development environment to production

I'm currently running an Oracle Autonomous Data Warehouse (Oracle's cloud-based database offering) on version 19c. I have a development database on the Always Free Tier and my production database is a ...
0
votes
0answers
31 views

Oracle Golden Gate - Initial data load and CDC

Im going to setup an oracle golden gate to BigData adapters. I know we can create an extract SOURCEISTABLE for the initial load. But I want to continue after initial load with CDC but without any ...
0
votes
1answer
28 views

ORA-01653 Unable to Extend Table AGILE.A_DW_TXN_LOG BY 128 in Tablespace AGILE_DATA3

I am trying to import an oracle database from a dump file. While importing I am getting ORA-01653 Unable to Extend Table AGILE.A_DW_TXN_LOG BY 128 in Tablespace AGILE_DATA3. I have tried to fetch the ...
1
vote
1answer
33 views

Using SQL*Plus to connect to remote DB from local server, how do I export a backup to my local server?

I am trying to have my entire remote DB backup made to my local server. Running the following command from my local server: expdp \"user/user@ip as SYSDBA\" full=Y directory=/backup/backup/ ...
0
votes
0answers
20 views

Oracle Single table with json vs set of tables using joins

I'm building a reporting solution. The data will be stored on Oracle database. I expect to get near to several billion data set since i have to keep data for 1 year period. When designing database ...
2
votes
1answer
39 views

UTL_FILE directory name changes oracle 19c

I've scripts where UTL_FILE.FOPEN is used and the parameter passing for directory is an absolute path i.e., /asr/file/path and the corresponding oracle directory name as ASR_ABC but after up-gradation ...
0
votes
1answer
19 views

Table Filtering Using Big List

Briefly, I am trying to filter a table using conditions plus a list of items in Oracle. In detail, I have a reporting table which has millons of records. I would like to filter it using external lists ...
0
votes
0answers
19 views

Oracle Kerberos LDAP authentication without KTPASS

I am working on trying to set up LDAP authentication on an Oracle 19c machine. The Active directory server I am authenticating against is a government service and they don't allow the kind of ...
0
votes
2answers
18 views

Insert Only first Occurence in Oracle table

i have a table CREATE TABLE PEOPLE ( NAME VARCHAR(64 BYTE)PRIMARY KEY NOT NULL, TIME TIMESTAMP(6), NICKNAME VARCHAR2(16 BYTE), STATE VARCHAR2(50 BYTE), CITY VARCHAR(128 BYTE) ) I want to insert in ...
-1
votes
1answer
22 views

ADD IGNORE_DUP_KEY = ON IN Create Table

I'm trying to add a IGNORE_DUP_KEY in the creation of my table PEOPLE, but I'm facing a ORA-00907: "missing right parenthesis". Can't manage to find my mistake, any help would be ...
0
votes
2answers
20 views

Creating roles and granting rights to the role

I wanted to create a role called "user_updates" and this role should have the rights "table_note_updates". The rights called "table_note_updates" is already available in ...
1
vote
2answers
37 views

Column name on NOT NULL constaint violation not shown

I'm using an Oracle 19 DB that is structured into multiple layers by using DB users. Here is a simplified overview of the structure: User DATA: Has the table XTEST and the view TEST. The view is ...
0
votes
0answers
26 views

ASM filter drive not starting automatically

After migrate from asmlib to asm filter drive using the Doc ID 2172754.1 the ASM Filter drive not start automatically and I always need configure again using asmcmd afd_configure command to start it ...
0
votes
0answers
24 views

Oracle Enterprise Manager 13c - query used in metric

I got task - "send me the query used in this metric?" It is related to Job with status "FAILED". I find this failed Job but can't find with which query this metric detect this ...
0
votes
0answers
21 views

How to querying SCD Type 2 on Oracle [closed]

My database is Oracle I have 2 tables called dwh_tbl_dim_supplier_type2_ar (target table) stg_tbl_dim_supplier_ar (source table) dwh_tbl_dim_supplier_type2_ar contains 6 column SUPPLIER_KEY (PK) ...
0
votes
1answer
23 views

How to join two table without getting duplicate from both left & right table in Oracle

Tables Details: CREATE TABLE Test2 ( ID INT, Value INT, other INT); CREATE TABLE Test1 ( ID INT, TYPE INT, other INT); INSERT INTO Test2 VALUES (123456, 5, 12); INSERT INTO Test2 VALUES (123456, 10, ...
0
votes
1answer
10 views

How to add duplicate records by basing on the count from another table (SQL)

I wanted to add a duplicate record by basing on the count from another table For example: In table #1, I have the following records: +------------------------+------------+ | first_name | last_name | ...
0
votes
1answer
25 views

How to join two table without getting duplicate from right table in Oracle

Tables Details: CREATE TABLE Test2 ( ID INT, Value INT, other INT); CREATE TABLE Test1 ( ID INT, TYPE INT, other INT); INSERT INTO Test2 VALUES (123456, 5, 12); INSERT INTO Test1 ...
0
votes
0answers
17 views

Oracle 11g Rac One Node - How To Change SYSMAN Password

How can I change the SYSMAN password on Oracle 11g RAC One Node without affecting anything else? I am considering following the steps below. Can you help if there is wrong step please. cd <OMS_HOME&...
0
votes
1answer
27 views

Oracle DB : Export only table data from from all tables of given schemas

Scenario : I want to export all data(or rows) from all tables from given schemas let say s1, s2, s3 from oracle DB installed on unix server(U1) . This data has to imported on another oracle DB ...
0
votes
1answer
40 views

How to add a new listener on a new port and restrict it to one instance only

I am running oracle 11.2.3 and we have a server with multiple instances running. All of them are registered to port 1521 with the default listener. Now we are required to make one instance available ...
0
votes
0answers
23 views

In ORACLE 11g , triggers, how i can get EXCEPTIONS, BEFORE they can be trigged

I had a package, very extensive who cannot be modified nor debugged. So i wrote an trigger then to get the table info before the process crash, BUT, in testing of the trigger as i insert in the table, ...
0
votes
0answers
18 views

Oracle - Monitoring tablespace warnings and critical events via Microsoft Windows Event log

I would like to monitor tablespace warning and critical events of my Oracle database (12c Standard Release 12.2.0.1.0) via Microsoft Windows Event Viewer and attach tasks to it. Right now only a few ...
0
votes
0answers
26 views

Oracle - SCD Type 2

I am new to Oracle I have 2 tables called dwh_tbl_dim_supplier_type2_ar (target table) stg_tbl_dim_supplier_ar (source table) dwh_tbl_dim_supplier_type2_ar contains 6 column SUPPLIER_KEY (PK) ...
0
votes
0answers
48 views

Direct, simple SQL query results in “ORA-01406: fetched column value was truncated”

All the information I've seen on this issue is always in regards to running a query via some other utility (e.g. TOAD); however, I am seeing this issue when I simply try to select * from v$asm_disk; ...
0
votes
2answers
52 views

how to resolve ORA-04042: procedure, function, package, or package body does not exist and ORA-00942: table or view does not exist

I am trying to grant EXECUTE and READ privilege on two tables to a user ktest1. grant EXECUTE on SYS.KIR_DOKUMENT to ktest2; grant READ on SYS.KIR_DOKUMENT to ktest2; when i give grant execute i get ...
-1
votes
1answer
18 views

how to resolve the error “ADMIN option not granted for role 'my_role_1'”

I am trying to grant a role to user. grant my_role_1 to ktest1 with admin option; But i am getting the below error Error report - ORA-01932: ADMIN option not granted for role 'my_role_1' 01932. 00000 ...
0
votes
1answer
25 views

Oracle: database not showed

I created an Oracle's container database (CDB) at CentOS named demo0, then I also created an user named c##demo. The issue is that the dabase is not showed at using ORACLE_SID=demo0 but it's only ...
0
votes
2answers
49 views

Number of threads in Oracle XE 18c

I just installed Oracle XE 18c ... In this page, they list the available features/resources. One of them is the use of two CPU threads ... But, in practical terms, what does this mean? Does this ...
0
votes
2answers
44 views

Impact of “_oracle_script”=true in Oracle database 18c

I just installed Oracle XE 18c (I migrated from 11g XE) ... After running the installer, I saw new features; for example, Oracle now supports a multitenat model and a concept called pluggable ...
0
votes
0answers
24 views

autonomous database in two regions

Backgroup on the autonomous database For the last couple of years Oracle have offered a "autonomous" or "self driving" database in their cloud which is only available on the Oracle cloud. If you ...
0
votes
2answers
50 views

I can open a connection with SQL Developer but when i do the same with .NET returns me ORA-12514

In SQL Developer In my .NET proyect, Web.config: <add name="DBConection" providerName="Oracle.ManagedDataAcess.Client" connectionString="Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST ...
1
vote
1answer
37 views

How to get a list of current Oracle CDBs on server

If I have a server with one or more CDBs, what command can I run on the server in order to obtain a list where each item uniquely identifies one of the CDBs? (a "CDB" is an Oracle Container Database) ...
1
vote
1answer
51 views

Oracle - MUST_RENAME_THIS_LOGFILE in logfile name

I'm creating a data guard using hot backup from the primary server. In my restore I've used the following commands to restore: run{ set newname for database to '+DADOS'; restore database; switch ...
0
votes
1answer
20 views

RMAN Creating automatic instance fails

I am trying to transport a tablespace in RMAN. The command I'm running is transport tablespace usr_table auxiliary destination '/oracle/rman/auxFiles' tablespace destination '/oracle/rman'; The ...
0
votes
1answer
42 views

How to copy user rights and roles from one user to another

I require a PL/SQL script that copies all of a user's rights, roles and mandates from one user to another. I am using Oracle 12c.

1
2 3 4 5
135