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
54 views

Issues installing Oracle Database 19c on Windows 10

I am running into all sorts of issues while trying to install Oracle Database 19c on my personal Windows 10 machine. I downloaded the newest version from Oracle's website and need a subject matter ...
2
votes
1answer
2k views

Alias Names and Two Table Query Problems

I'm quite new to querying databases, I've only been doing it for about 2 weeks in the current job that I'm in and have never touched SQL prior to this. I'm working on trying to use alias names to ...
0
votes
0answers
13 views

Sql query is failing in Oracle DB [duplicate]

I run below query to fetch data from a Oracle DB - SELECT T1.Col1, T2.Col1 AS Tab2_Col1 FROM Tab1 AS T1 INNER JOIN Tab2 AS T2 ON Tab1.Col3 = Tab2.Col4 With that, I am ...
0
votes
3answers
105 views

Command Line Creation of a new 12g Oracle Database

I am new to creating an Oracle database using the command line. I am logged in as superuser; now I would like to create a new blank database, "mynewdatabase". $ . oraenv ORACLE_SID = [oracle] ? ...
0
votes
1answer
3k views

unixODBC - [IM002][unixODBC][Driver Manager] Data source name not found and no default driver specified

Folks, We installed unixODBC-2.3.7 on Aix 7.1 to connect to Oracle 11g. After setup odbc.ini and odbcinst.ini files and tried to connect with isql, we had the following error: # isql -v ORACLE [...
1
vote
1answer
43 views

Does the target database need to have the same structure of the source database before to use IMPDP?

When I do a import from another database have I need the same estruture of the source database in the target database? For example, if my source database use ASM and my target database no, what have I ...
-1
votes
2answers
48 views

Why would a scheduled job fail in SQL Developer?

I am trying to create a scheduled job in Oracle SQL Developer that would run once a month and I am testing the Scheduler/Jobs feature where I have created a simple SQL query to test the ability to do ...
1
vote
2answers
4k views

Getting an error “ORA-00093: pga_aggregate_target must be between 10M and 4096G-1” on Oracle DB startup

My Oracle DB 12c instance was not starting up. While connected as an idle instance ( / as sysdba ) and executing startup; command, I was getting an error: ORA-00093: pga_aggregate_target must be ...
0
votes
1answer
26 views

Joining two tables based on two Aggregate columns

I have a following problem as in the example. I have to join two tables based on the aggregated columns. These are the only way to combine these two tables. Is it possible to do this? I have tried ...
0
votes
1answer
278 views

Oracle 11 rman db restore file corruption

First to mention that I came to the need of asking help after furious research I reattempts for about 3 weeks. I checked previous threads in Oracle community but nothing works for me. I am trying to ...
0
votes
1answer
460 views

Oracle - Query to join fact table to bridge table and show bridge group rows in one row?

I have a data warehouse with a One-To-Many relationship: "Fact" table contains: Product_Group_ID "Product_Bridge" table contains: Product_Group_ID, Product_ID "Product" table contains: Product_ID, ...
3
votes
2answers
6k views

How do I kill Oracle DataPump expdp job stuck in DEFINING state?

My job failed because dump file already existed. Now it's stuck in DEFINING state. How do I stop/kill it? declare h1 number; BEGIN h1 := DBMS_DATAPUMP.ATTACH('EXPORT_TABLE_2017_1205_1402',user); --...
0
votes
1answer
2k views

How do I copy a materialized view to a table?

I have a materialized view. I want to create a copy of it so I can modify some of the data to test a few theories about an issue and its possible solutions. How do I make a copy of this MV as a table?...
0
votes
1answer
45 views

Oracle listener does not restart because port 1521 is not released fast enough after stop

I'm running Oracle 11g on a Windows 2012R2 server. For some reason we have some code that try to restart the listener and then perform a connection. This code has been working for years on many ...
2
votes
3answers
87 views

Oracle counterpart to `pg_cancel_backend`

Considering the Oracle statement ALTER SYSTEM KILL SESSION ... as... to some degree comparable to the PostgreSQL statement SELECT pg_terminate_backend(): Do you know of any Oracle analogy (better ...
-1
votes
3answers
32 views

Oracle 11g, show running queries [duplicate]

I've a web application which submits some queries to Oracle 11g. I want to know what are these queries, exactly. I there a way I do this in Oracle 11g? Couldn't do this in the web application itself.
0
votes
1answer
157 views

Replication using Datagaurd to FAR DR

We have already setup Oracle replication using Dataguard from a primary active site to a near DR site. The near DR is a passive site. Is it possible to replicate from the Near DR (Passive) site to ...
-4
votes
1answer
31 views

List All tables with last DML operation date [closed]

I need to get last DML operation date for all tables in my schema. I have tried following query but in case snapshot does not exists i am not getting desired output SELECT scn_to_timestamp(max(...
0
votes
0answers
26 views

Oracle DB Replication/Data Transfer

I need to replicate an oracle database without updating each other just for backup purposes. I have a Main DB(MDB) that have jobs to send to be processed data to interface DB(IDB). IDB will be ...
0
votes
1answer
64 views

Why Oracle 19c Database EM Express Webpage is not opening in Microsoft Edge?

I have recently installed Oracle Database 19c on my Laptop which has Windows 10 OS. Now, I want to open the localhost:5500/em page in Microsoft Edge browser, but when I try to do so, the webpage does ...
0
votes
1answer
16 views

Oracle - Delete dmp files from ASM diskgroup

I want to delete my export files daily from ASM diskgroup with a crontab job. I want to prepare a script for it. ASMCMD> ls exp1.dmp exp2.dmp exp3.dmp exp4.dmp ASMCMD> pwd +DATA/EXP How ...
2
votes
1answer
146 views

Scheduled snapshots of views (without using materialized views or Oracle Golden Gate)?

I have 40 views in an Oracle 18c GIS database that are used in a map in a workorder management system (WMS). The views are served up to the WMS map via a web service. There are an average of 10,...
3
votes
1answer
1k views

Why would a query return oracle.sql.NUMBER@[hex value] in place of a numeric value?

I'm seeing some odd behavior in an Oracle 11gR2 database. When I select from a particular table, using SQL Developer, certain rows of the result set include non-numeric results in a NUMBER column (...
1
vote
1answer
1k views

Is DBSNMP used only by Oracle EM by default?

I have Oracle database and I need to install agent for Oracle EM. It requires credentials for DBSNMP user, but it was lost. Is it safe to change password via SYS user to provide it to agent? Is there ...
1
vote
1answer
3k views

Select Oracle clob field from remote table over dblink

I am trying to select a clob field thru flink from a remote table.I am able to see the values in editor result but not able to select thru program or any export. SQL Error: ORA-22992: cannot use LOB ...
0
votes
0answers
23 views

Application connection pooling load balancing the transactions on 18c RAC

Application connecting a 2 node 18c RAC. JVMs are using connection pool and transactions are routed to the nodes via the connections in the pool. So the initial load across the nodes are distributed ...
5
votes
1answer
4k views

ORA-04091: table ExpenseTable is mutating, trigger/function may not see it

I have two tables and a trigger and am inserting values in ProjectsTable like this: CREATE TABLE ProjectsTable ( ProjectID NUMBER(6) NOT NULL, ProjectName VARCHAR2(200) NOT NULL, Cost ...
0
votes
2answers
38 views

What are the benefits of moving redologs, data- and controlfiles to another location?

I have installed Oracle 18c XE and was wondering what benefits/disadvantages would come from seperating the data that is stored inside the databases managed by the dbms and the actual Oracle ...
13
votes
3answers
75k views

What is the default username and password to the oracle pre-built virtual machine?

I downloaded DeveloperDaysVM2016-06-02_13.ova from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and successfully loaded it into Virtual Box. I logged ...
1
vote
0answers
64 views

oracle sqlcl and sqlplus - seperate login.sql on linux

I feel I'm probably missing something obvious here, but I can't see an easy way to have a separate login.sql for sqlplus and sqlcl This is problematic for me as the errors thrown up by sqlplus for the ...
0
votes
2answers
31 views

oracle - hashing method, excluding DBMS_CRYPTO

BACKGROUND: DBAs have hidden DBMS_CRYPTO package to any role, grantee, and I wonder why. I have to use wrapper instead :( Is there any way to get the same hash for the text field with the same text? ...
0
votes
1answer
303 views

How to convert the JSON date with to_date function

How to convert the specific string Aug 6, 2018 3:17:11 PM with the function to_date? That string is a result of a Java parsing mechanism for JSON. I would like to be able to recover it directly from ...
2
votes
1answer
448 views

Oracle using sub-optimal index on bind variables

Let's say you have a table, called ORDERS, which contains ORDER_NUMBER, CUSTOMER_ID, and ORDER_DATE (among other fields). And you have one index on ORDER_NUMBER, another on CUSTOMER_ID, and third ...
1
vote
3answers
3k views

Running Oracle Export Utility within a Shell script [closed]

I have wasted a lot of time on this. Any ideas of what I am doing wrong here? Script in bash #!/usr/bin/bash . . . /export/home/app/oracle/product/10.2.0/bin/exp $uname/$passw \ FILE="$...
1
vote
0answers
58 views

Linked Server throws metadata error

I have a function in SQL Server 2019 that copies data from a local table to an Oracle 11.2.0.4 table via Linked Server, using Oracle 19.3 client. Recently, a new column was added to the Oracle table, ...
0
votes
1answer
34 views

ORA-01045 when attempting to connect to PDB. User has CREATE SESSION privilege, but I Oracle says they don't

The user has been granted CREATE SESSION but i can only connect to CDB and not the PDB. Why is this? I'm trying this in SQL developer. I have Oracle 19c.
0
votes
0answers
16 views

Oracle Filter Full Transportable Backup for Schema

I need to use DBMS_DATAPUMP to make a full and transportable backup from my oracle DB for all objects related to a specific schema. I was looking for something like INCLUDE=SCHEMA:"LIKE 'SCHEMA_1%...
0
votes
1answer
2k views

Install Oracle Database 12c Error unable to check whether the location specified is on CFS

ps://i.stack.imgur.com/0DX0d.png I am trying to install the Oracle database 12c on the Windows 10 Laptop. Have tried disk C and disk E, got the same error. And I tried to change the file properties,...
1
vote
1answer
35 views

Selecting a record based off conditions CLOB

I have a table with a column storing JSON data as a CLOB. The JSON has a 'miscData' field that is made up of an array of JSON objects. Each object has 2 keys which are always the same, but the values ...
0
votes
1answer
81 views

CREATE VIEW WITH LEFT JOIN - FILTER RIGHT DEPENDING ON LEFT

I am using Oracle 12.1. I have the following tables, simplified for the question : (Note that the XXX for entity ID does represent the same ID being repeated) Events date_event | entity_id | used -----...
1
vote
0answers
224 views

How to turn on the expanded mode in Oracle SQL*Plus?

As in the switch \x of PostgreSQL. For more information on the PostgreSQL expanded mode, fetch https://serverfault.com/questions/618642/psql-expanded-mode-equivalency-for-mysql. Both PostgreSQL and ...
0
votes
1answer
35 views

Are recent versions of Oracle able to implement a queue with SKIP LOCKED?

My question: what is the very latest status on whether or not recent versions of Oracle actually make it possible to implement a queue in a straightforward way with SKIP LOCKED and limiting to a ...
0
votes
1answer
40 views

Oracle 18c opatch util cleanup not working

System: [oracle@hostname:/opt/oraclegrid/18]$ uname -a SunOS hostname 5.11 11.4.24.75.2 sun4v sparc sun4v Database: Oracle 18c 18.10 (April 2020 patch), RacOneNode setup Opatch OPatch Version: 12.2....
0
votes
1answer
41 views

Query returns NULL - Oracle

I've an Oracle query where I need to get some data on the basis of some records (strings). I am using IN clause and query is working fine in TOAD with hardcoded data. But when I run that query through ...
0
votes
1answer
113 views

SAP BO Freehand SQL date formatting (Oracle db)

My original query worked perfectly via SQL Developer: select * from [table] where DT_CURRENT_DT = '15-OCT-18' However when ran via freehand SQL in SAP BO I got no results. After running the query ...
2
votes
2answers
4k views

Writing Oracle BLOB field to raw file in a Cursor or For loop result empty file

I am stuck at this for a while and had been Googling for answer but can't seem to find any.... I have an Oracle 9i table with BLOB field that I need to extract the BLOB field into a raw file on the ...
0
votes
2answers
125 views

number field in varchar2 field

I have a table with a number field (non-null). I have another table with a varchar2 field. Examples: Users UID,Name 123,Mickey 41128,Joe 43,Alice Groups UIDS,Name (123,43),Children (43),Admins (),...
0
votes
1answer
83 views

Copy DBF files from production to development environment

I'm not an expert. I'm a Software Developer but got trapped in doing this DBA work. We have a development environment and we would like to copy the DBF files from the production environment to the ...
3
votes
1answer
4k views

sqlplus is not starting

I have a strange error on a Red Hat machine. InstantClient is installed in and ORACLE_HOME is set to /opt/oracle/product/112030_cl_64/cl/ The user which installed the client was oracle:oinstall. My ...
0
votes
1answer
23 views

What makes using an Oracle Wallet to connect to a data source more secure than using a username and password to do the same?

What makes using an Oracle Wallet to connect to a data source more secure than using a username and password to do the same? If someone knows the connection string for using an Oracle Wallet to ...

1
2 3 4 5
138