Questions tagged [oracle-11g]

Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.

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

Error during upgrade : Oracle 11g to 12c

While upgrading catupgrade.sql, we are getting below error. Due to errors found during the upgrade process, the post upgrade actions in catuppst.sql have not been automatically run. * ...
-1
votes
0answers
21 views

Hierarchical Query with join [closed]

This the current Hierarchical Query: SELECT object_id BULK COLLECT INTO object_ids FROM objects WHERE ROWNUM <= batch_size START WITH object_id IN (SELECT object_id ...
0
votes
0answers
57 views

Getting error SP2-0158: unknown SET option

I am getting error while running my script SP2-0158: unknown SET option "errorlogging" SP2-0158: unknown SET option "echo" SP2-0158: unknown COLUMN option "ENTMAP" SP2-0158: unknown COLUMN option "...
0
votes
1answer
44 views

Oracle: Connects with sqlplus but not from perl

I need to connect to an Oracle database from a perl script, it works in my tests and when using sqlplus, but not in production. This is a summary of the situation: Oracle 11g XE (11.2.0.2.0) : (Test ...
-2
votes
1answer
71 views

SQL QUERY RELATED TO JOINS

I am practicing SQL and i got stuck at this query: "Display the salesmen id, salesmen name, total sale amount and total discount by the salesman who has made sales. Display the result in descending ...
0
votes
1answer
36 views

How do I recreate the XE database in Oracle 11g Express?

My Oracle XE database was useless mess of unused tables etc. Using SqlPlus and several google results, I finally managed to drop the XE database, but now when I connect with SqlPLus IO cannot create ...
0
votes
1answer
52 views

How To Create A New bash_profile And Connect New Database To It In Oracle [closed]

OS -> Linux DB -> Oracle 11gR2 Normally my .bash_profile file looks like this: TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=abcde.localdomain; export ORACLE_HOSTNAME ...
0
votes
4answers
73 views

Alternative to Triggers

I am working on an oracle database and want to record the exact time of any transaction happening on a specific table in the schema. Using triggers on that table is out of question as the client do ...
0
votes
0answers
37 views

Oracle 11.2.0.1.0 showing “no matching authentication protocol”

I have installed the above oracle version (personal edition) for my developmental purpose. But when I try to login through sqlplus, always it throws me the error no matching authentication protocol. ...
0
votes
1answer
40 views

Does canceling update operation perform automatic rollback

I ran into a bit of confusion. I'm under the belief that database operations are automatic - that is either the query succeeds or the transaction is automatically rolledback. For example - if you have ...
1
vote
1answer
44 views

Patching after upgrade (windows 11gr2 -> 12cR2)

I have a following scenario where I had a patched oracle 11gR2 DB (applied Windows Bundle and OJVM patches) and then it was upgrade to Oracle 12cR2. 12cR2 was a clean installation (no patches applied, ...
0
votes
0answers
15 views

Environment variables for Oracle OPAM 11g

Is there a way to set environment variables when logging through Oracle OPAM 11g to #OPAMSH console? Prior to OPAM integration, environment variables are set through a logging script where a question ...
0
votes
1answer
29 views

Oracle 11g connectivity over windows based client-server net [closed]

I have two PCs as follows: I want to create network for both PCs and share Oracle database from PC1 PC1 (windows 10 Pro 64-bit operation system) - Oracle 11g Installed PC2 (windows 10 Pro 64-bit ...
1
vote
1answer
73 views

How to select last record of each month

I have a table: Table1(DDate date,Deposit_Key Number , Amount Number) some example data are: DDate Deposit_key Amount 1/1/2019 1 10 1/2/2019 1 ...
0
votes
1answer
26 views

“Server not open” / “Drop tablespace” catch-22 situation

I am getting the "server not open" error in SQLPLUS, and the equivalent on Oracle SQL Developer, which says "Oracle Initialization or shutdown in progress". Fair enough. The fix for this is as ...
0
votes
0answers
35 views

Sql Oracle 11g. Want to find the what are all the values are modified in a table?

I have ten attributes in a table. I want to find what are all the datas are being modified and which are all the fields??? Could you please help me out
0
votes
1answer
31 views

Receiving error : ORA-01747 While trying to calculate COUNT(*) of a specific table

Hope you're doing well. I have two tables and as I far as I know for this scenario there is no need for their structures. When I run this query : SELECT COUNT(T.*) AS X FROM table1 T INNER JOIN ...
3
votes
1answer
39 views

Query Performance Help

A brief history. I have an oracle sql query which I'm looking to pull data when a certain preference is enabled. In this query I had a date range to filter the data to a specific range. This was ...
0
votes
2answers
41 views

Better ways to update columns of a table than using Merge Statement

I have a table with this structure Table1(Cust_No Varchar2(50), First_Name Varchar2(50), Last_Name Varchar2(50), Error_Code Number(1) , Error_Desc Varchar2(50)) ...
0
votes
2answers
780 views

Error During IMPDP in oracle database 12c

I create Dump file with EXPDP command in oracle database 11gR2 with operating system Oracle Linux 6.7 EXPDP Command: expdp hmis/pass directory=MY_DATA_PUMP_DIR dumpfile=12c_db.dmp logfile=12c_db.log ...
0
votes
2answers
55 views

How to use TO_NUMBER function to update columns of a table Using oracle pl/sql

Hope you're doing well. I have a table with this structure : Table1(Cust_No Varchar2(50), First_Name Varchar2(50), Last_Name Varchar2(50), Error_Code number(1), ...
-2
votes
3answers
73 views

Is Oracle DBLink Vulnerable? [closed]

We have a web page on internet that calls a web service located on our intranet. The web service talks to Database A to get some data. Database A has a DBLink to Database B. This link is used to ...
0
votes
1answer
56 views

Oracle Linked Server Long Preemptive_COM_Cocreateinstance Waits

I have a Linked Server using the OraOLEDB.Oracle provider from the 11g Oracle Client and it was working fine for a while. However, an Oracle 12c Heterogeneous Connection was setup recently. This ...
0
votes
1answer
74 views

Oracle database issues

I had my database working properly but I had an issue and when I tried to repair it I executed the following command alter tablespace system add datafile '/var/oracle/oradata/data.dbf' size 10000m ...
0
votes
0answers
33 views

What gets executed immediately after logging into an Oracle database?

When I login with SQL*Plus, without executing a command, I always get the following error: $ sqlplus db_user/db_pass@localhost/XE SQL*Plus: Release 18.0.0.0.0 - Production on Wed Aug 7 10:33:03 2019 ...
0
votes
0answers
328 views

trigger to update if not exists in table oracle pl/sql

I want to create a trigger PL/SQL for the table: ap_supplier_sites_all (oracle EBS R12), in this table i have below information: vendor_site_id (primary key), vendor_id, attribute4 (varchar250), my ...
2
votes
3answers
438 views

De-Duplicate from LISTAGG

I am using 11.2 version of oracle. I want to de-duplicate from LISTAGG. below is existing data in oracle db: Speaker | Qualification | Product P A P1 P B ...
2
votes
2answers
144 views

How to use “regular expression” to separate specific strings in Oracle

I have a string '(1:30,2:4,52:0,8:1)', and I need to use a regular expression to have this output: field1 field2 level 1 30 1 2 4 2 52 0 3 8 1 ...
0
votes
1answer
174 views

DB_RECOVERY_FILE_DEST_SIZE automatically decrease size after shutdown

I am using oracle database 11gR2. I increased db_recovery_file_dest size with alter command alter system set db_recovery_file_dest_size=60G scope=both; When I shutdown database and again open ...
0
votes
2answers
33 views

Syntax error in setting unused column

I have a table named e_emp3 in Oracle with these fields among others: FNAME VARCHAR2(20 BYTE) SAL NUMBER(8,2) DEPTNO NUMBER(4,0) I need to alter e_emp3 and set unused column(...
2
votes
1answer
313 views

RDS: permission denied for relation spatial_ref_sys when copying

I am copying tables using ogr2ogr from Oracle to PostGIS. When I run try to load these I get, ERROR 1: ERROR: permission denied for relation spatial_ref_sys when copying <table>@AWS
0
votes
0answers
132 views

Loading data from CSV file to oracle table using sql loader

i want to load the data from CSV file to oracle table with this below condition. if the table is empty then only the data should be loaded into table otherwise data should not be loaded. is this ...
0
votes
0answers
25 views

Global nonpartitioned index vs local partitioned on for a partitioned table

We have a select query which is really slow. We are using views in the from clause. Global nonpartitioned index is used for accessing the rows of a partitioned table. My doubt is that if Global index ...
2
votes
1answer
45 views

What prerequisites package is needed for Oracle 11g + 12c on the same OL7 server?

I need to install 3 Oracle homes on the same Oracle Linux 7 server, but it's not clear to me what prerequisites I need to install before proceeding. What I'm planning to set up, is a two-standalone-...
-1
votes
1answer
487 views

Facing error 'No data found ' while trying to write a query using 'Cursor' PL/SQL in oracle

Hope you're doing well. I'm new to oracle PL/SQL and I'm trying to write a query just with the aim of practicing 'Cursor's . I have three tables with below structures : Student:(Student_id , ...
0
votes
1answer
87 views

How to view databases and tables after 'imp' import using Oracle SQL developer

Maybe that's a wrong form of answer... The problem is: I've got an Oracle database dump file (very old, created with imp utility) At last, I've imported it. The command was imp file=E:\Downloads\...
-1
votes
1answer
172 views

How to generate ddl for a synonym

what is the query used to generate ddl of synonym in one environment so that I can run it in the other environment
0
votes
0answers
69 views

ORA-27369: job of type EXECUTABLE failed with exit code: There are no child processes to wait for

I have existing .bat file where i call FDSLoader64.exe on daily basis to update following tables. FF_ADVANCED_AF FF_ADVANCED_SAF FF_BASIC_SAF FF_BASIC_AF FDSLoader64.exe is supposed to download ...
1
vote
0answers
104 views

SSIS won't connect to Oracle issue after ODAC driver un-install & re-install

I installed the ODTwithODAC1120320_32bit drivers and client and could successfully connect SSIS to an Oracle database. I noticed that the installation had defaulted to the E: drive which is where the ...
-1
votes
1answer
21 views

query with LISTAGG() string function does not give the desired output

I'm new to ORACLE and I'm trying to use a string aggregation function in my query to concatenate the value of rows with a comma , this is the structure of my tables: Student(STUDENT_ID,student_name,...
1
vote
3answers
465 views

Do I Alter user quota in USERS tablespace?

I'm new to Oracle so please bear with me. After installing Oracle XE 11.2, I created user SALES and granted create session and create table to the user. Once I logged in with SALES I tried to create ...
0
votes
1answer
76 views

Facing Error 'Missing expression' while trying to create a After insert trigger in PL/SQL

Hi everyone hope you're doing well. AS you might know by now I'm new to PL/SQL and I'm trying to write a trigger as you can see below : CREATE OR REPLACE TRIGGER T_Insert AFTER INSERT ON tag ...
0
votes
0answers
28 views

Resizing and reclaiming free space on Tablespaces

I would like to reclaim some free space from our tablespaces. I can see that UNDOTBS1 and USERS for example have 30GB and 10GB free. these are the tablespaces: | tablespace | used mb | free mb ...
0
votes
0answers
34 views

cx_Oracle high memory use

I am using cx_Oracle with python to select a dataset of about 200,000 rows. I am having memory issues with my application, so I am memory profiling. The memory use for these lines is over 1G, however,...
0
votes
0answers
69 views

Everyone can't use the linked server

I'm having an issue with a linked server on MSSQL Sever 2016. I created a link to an Oracle server, TKCS. It uses the Oracle OLEDB drivers installed by the Oracle client (11g). On the security tab ...
4
votes
2answers
845 views

PL/SQL function to receive a number and return its binary format

I'm trying to write a function to receive a number and return its binary format. This is what I've developed so far and it's ok for inputs : 4,8,16 but it does not return correct binary format for ...
0
votes
2answers
59 views

Facing error while executing function inside the package in PL/SQL

Hi everyone hope you're doing well. I'm new to oracle and I'm reading about the concept of 'Package' and 'Package body'. I have a function as you can see below CREATE OR REPLACE Function ...
1
vote
1answer
85 views

Troubleshooting oracle database errors from cloud application

I am trying to troubleshoot an issue that presents as different database errors such as, ORA-01000: maximum open cursors exceeded or Unable to create DB Connection. I have reviewed the PLSQL to ...
2
votes
1answer
59 views

Oracle isn't restoring correctly a backup

First of all I'll say I'm using: Oracle Database 11g Express Edition Oracle SQL developer What I'm trying to achieve Create a backup and restore it, so for example I can delete a table after a ...
0
votes
1answer
70 views

Disable Oracle substitution parsing

I need to update a string (VARCHAR2) value in an Oracle database which contains Javascript code. The update script contains the following string: c===l&&p(a,b) which when executed from "...