Questions tagged [oracle-11g-r2]
Oracle Database 11g Release 2. Please also tag oracle for search purposes.
1,353 questions
0
votes
1
answer
74
views
PL/SQL No Rows Selected on Views by Specific User
Hi I would like to ask for help on Oracle SQL.
I have a View that is accessible to specific users but suddenly today 1 of those users output is always "No Rows Selected". Object grants are ...
- 11
0
votes
0
answers
157
views
Why SQL plan baseline is not even considered for a statement?
I want to create SQL baseline for a very simple statement in Oracle 11g. Just to test if plan baselines work. But the created baseline is not even considered. In the resulting plan there is even no '...
- 1
0
votes
0
answers
26
views
Oracle SQLPlus taking exclusive session and not allowing to run update statements from .Net application
I connected via sqlplus like following:
sqlplus user/password@SID
I have a .Net application which also connects to same DB using same user and password. But once sqlplus is connected, it was unable to ...
- 451
1
vote
0
answers
135
views
Finding harse parse and high cpu time SQL in Oracle Database11g2
I usually check SQL statement by AWR report:
SQL Statistics - SQL ordered by Elapsed Time or SQL ordered by CPU Time
I need to identify the hard parse sql , maybe having inappropriate plan or other ...
- 11
3
votes
1
answer
408
views
How to check if Oracle Database is using EBR ( EDITION-BASED REDEFINITION) or not
As per Oracle's documentation, since version 11g, Edition Based Redefinition (EBR) is initialized with a default edition named ORA$BASE. Any future EBRs are children of this so-called "edition&...
- 31
0
votes
0
answers
160
views
ORA-12541: TNS:no listener error when trying to login through WSL to access OracleXE Database
System Details
WSL2 Ubuntu
Oracle Instant Client (Inside of WSL)
OracleXE (Inside of Windows)
I followed the instructions guide from the Oracle Documentation, added the path to the TNS_ADMIN, ...
- 1
0
votes
1
answer
170
views
how to get explain plan from pl/sql function call?
consider this working pl/sql block:
declare
o_result boolean;
io_error varchar2(30000);
tab1 someTable1;
tab2 someTable2;
begin
tab1(1).col1 := 'str'...
- 119
-1
votes
1
answer
292
views
ORA-01400: cannot insert NULL into
I have two tables:
create table country(
country_code varchar2(2) PRIMARY KEY,
country nvarchar2(57) NOT NULL
);
SQL> desc airport_final
Name Null? Type
-------------------...
0
votes
1
answer
389
views
Oracle statement inserting duplicate data
I am using this statement to insert records from another table:
SQL> insert into city(city_code, country_code, city)
select distinct(city_code), country_code, city_name
from airport_final;
2 ...
- 17
0
votes
2
answers
160
views
inserting data from another table
create user TESTING identified by "Test";
grant connect, resource to TESTING;
grant dba to TESTING;
connect TESTING/Test;
set define off;
create table airport_final
(
iata_code varchar2(3)...
- 17
-1
votes
1
answer
487
views
Need help with DBMS_COMPRESSION.GET_COMPRESSION_RATIO
I need some help on how to run the DBMS_COMPRESSION.GET_COMPRESSION_RATIO package on all the tables of a database to see if is worth the implementation or not.
This is the procedure I'm running alone ...
-1
votes
2
answers
96
views
SQL breaking my query where there is NULL value
Here is my sql statement and the error I am facing:
SQL> INSERT INTO COUNTRY(COUNTRY_CODE)
select unique(country_code) from AIRPORTDEMODATA where country_code IS NOT NULL;
2 INSERT INTO COUNTRY(...
-1
votes
1
answer
169
views
Expecting "," or ")", found "nvarchar2"
Here is my SQL*Loader: Release 11.2.0.2.0 - Production on Fri Nov 10 00:39:56 2023
OS=UBUNTU 20
I am trying to load data from csv file with the help of following code:
OPTIONS (SKIP=1)
LOAD DATA
...
0
votes
1
answer
37
views
Is that possible to count number of specific columns in Oracle
I have a table like this:
Is that possible to return the number of rules that pass or fail based on the no?
Thanks,
T
- 3
1
vote
0
answers
84
views
Restore oracle database on a new machine with only datafiles and control files?
I lost my laptop and I had an oracle database 11g r2 in it but I still have all the data files, create control files script and nothing else now I bought new laptop and I want to get my data back with ...
