Skip to main content
Database Administrators

Questions tagged [oracle-11g]

Ask Question

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

717 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
5 votes
5 answers
1k views

This won't work in Postgres since it doesn't have any DUALs. SELECT 'Ok' AS RESULT FROM DUAL On the other hand, this won't work in Oracle since it requires a FROM clause SELECT 'Ok' AS RESULT; The ...
Sergey Zolotarev's user avatar
  • 263
0 votes
0 answers
161 views

I've been requested to make a dump of an Oracle 11g EE Database. However, i can't use the Oracle Data Pump utility, since I have no direct access to the host machine, nor I think the db user have the ...
Dont Throw Me Away's user avatar
  • 1
1 vote
0 answers
49 views

Question? is there a way or possible way to Connect Oracle11g and Oracle19c Database the Scenario is Oracle11g Table1 transfer specific Columns of data to Oracle19c Table2 same column structure for ...
Ian's user avatar
  • 11
0 votes
0 answers
68 views

I am trying to make my all table columns in lowercase but the following error appears: SQL> UPDATE COUNTRY SET country_code = LOWER(country_code); UPDATE COUNTRY SET country_code = LOWER(...
Raakh's user avatar
  • 17
0 votes
1 answer
337 views

DB: 11g Release 11.2.0.3.0 OS: RHEL server 5.8 I'm trying to shutdown an oracle instance, but every time I try the following ORA-03113 error appears and the instance restarts itself: sys@db_name> ...
Mendbayar Alzakhgui's user avatar
  • 11
0 votes
1 answer
246 views

As shown on below image, I have two tables; Customer : with about 4 million records; and 3 columns [Customer] : Customer ID [Date] : Creation date [Num_Days] : Number of working days to calculate ...
LEOPOLDO's user avatar
  • 1
-3 votes
1 answer
96 views

I am a java full stack developer who want to write oracle sql queries to simplify writing is there any mysql workbench like similar gui tool for oracle by oracle or any other please sugest
Maddy plus plus's user avatar
  • 47
1 vote
1 answer
414 views

I created an updatable view V1 in an Oracle 11g DB (it has INSTEAD OF triggers for UPDATE, DELETE and INSERT); it originally had a GROUP BY query in it, which I moved to another view V2. This other ...
ENOTTY's user avatar
  • 406
0 votes
1 answer
3k views

I have 1TB tablespace that have one bigfile , The disk size now full and added extra disk to my server but there is no way to expand Drive that bigfile in it , so need to add another bigfile ,if ...
FarshiD Naqizadeh's user avatar
  • 5
0 votes
0 answers
289 views

It was marked offline and it is fixed already. We want to know the list of causes that marks the temp tablespace offline.
Suresh Dooly's user avatar
  • 1
0 votes
2 answers
2k views

I am exporting a complete database (full=y) on oracle 11gR2 on Linux, and always get this error. There are no other messages, so the problem is not about timeout or permissions as shown elsewhere. ...
eppesuig's user avatar
  • 5,142
1 vote
1 answer
1k views

For an Oracle 10g/11g database that refuses to start due to datafile (SYSTEM01.DBF) corruption, does RMAN restore command immediately overwrite all current datafiles from the last found full RMAN ...
clj's user avatar
  • 11
1 vote
1 answer
2k views

I'm currently working on a database migration, from Oracle 11g to SQL Server 2019. We're talking here of about 10-12 GB, in something like 300 tables (so creating them manually is out of reach, as is ...
BenSQL's user avatar
  • 13
1 vote
1 answer
3k views

Below , I'm trying to use the data of the array I've declared, in the where clause of the query but I receive the following error : declare v_input varchar2(400) := '0,1,2,3,4'; type ...
Pantea's user avatar
  • 1,502
-1 votes
1 answer
258 views

My Oracle database Test server crashed, I have no rman backups but I still have the datafiles because they are on a SAN Storage, so if I have datafiles, how can I restore my Oracle database?
arodp's user avatar
  • 29
0 votes
1 answer
84 views

I have a query that always must return a single row and its execution time is about 5s, so I need to optimize it: SELECT * FROM RESPONSE res INNER JOIN REQUEST req ON res.ID = req.ID WHERE res....
grf2018's user avatar
  • 1
0 votes
1 answer
126 views

I have a executable application that using Oracle ODBC Driver V9.2. My Old server Have Oracle 10g on windows 2003 32bit. I install and configure new server using Oracle 11g on Windows Server 2016 x64. ...
user3123721's user avatar
  • 1
0 votes
0 answers
225 views

Please let me know which approach you would take. The problem I have a large Oracle 11g DB that needs to have old records purged to free disk space. One of the requirements for the project is that we ...
Google Fail's user avatar
  • 193
1 vote
1 answer
353 views

I have a problem inserting in a nested table in oracle These are the relevant types and tables; create type movies_type as Table of ref movie_type; create type actor_type under person_type ( ...
user062's user avatar
  • 13
0 votes
1 answer
75 views

I want to select the maximum value, but if the user has more than one value in one column, then leave all I have a table : create table package (U_id, service, offer,product) as select 1, 12345, ...
user18552635's user avatar
  • 1
0 votes
1 answer
3k views

We will migrate our database using datapump. It will be full database export with exclude some table's datas. But we want to do a different operation for 2 different tables. We want to export the data ...
jrdba123's user avatar
  • 29
2 votes
1 answer
68 views

My employer has six Exadatas: three in a RAC in one data center, and the other three in a RAC in another data center. One is primary, and the other is a DataGuard standby. On the standby RAC, we also ...
S M's user avatar
  • 196
-1 votes
1 answer
898 views

While reading Oracle 11g Sql by Joan Casteel, the author mentions that many to many relationships couldn't exist in relational databases. I was wondering what the reasoning behind this fact was.
Kevin Bai's user avatar
  • 11
0 votes
1 answer
91 views

I want to know the total of each product that each customer has bought and I don't know how to add the total per customer. The tables are as follows: CREATE TABLE CLIENTES -- Customers ( CODIGO ...
Jose Luis Bravo Gonzalez's user avatar
  • 1
-1 votes
1 answer
137 views

I need to know why example table space is created by Oracle 11g ? Does it effects the performance if it is full ? if yes how can we stop it being used ? Thanks
Waseem Hassan's user avatar
  • 3
0 votes
0 answers
414 views

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 ...
Neo4242's user avatar
  • 1
0 votes
0 answers
81 views

I am trying to migrate oracle 11g database from Windows to a Linux server. I have followed these steps for migration: I have opened database in mount mode. Then I have backed up file on the Windows ...
sps's user avatar
  • 1
0 votes
1 answer
317 views

We have an oracle 11g cloud database that was working fine until recently when it started throwing the ORA-12514 after every reboot. The instance is programmed to be started up every morning and ...
Anass Naqqad's user avatar
  • 1
0 votes
1 answer
321 views

We have a database of 2000 users. We will drop all remaining schemas, leaving only 2 end users, excluding Internal (Oracle maintained) users. After this operation, there will be a very high reduction ...
jrdba123's user avatar
  • 29
0 votes
3 answers
1k views

Running Oracle 11.2.0.4.0 on CentOS and discovered the hard drive filled up, giving error in alert log: ORA-19815: WARNING: db_recovery_file_dest_size of 64424509440 bytes is 99.98% used, and has ...
user46688's user avatar
  • 149
0 votes
1 answer
118 views

This is purely learning purpose, that which incomplete recovery type is use in which condition? And DBA is bound to choose one or can choose anyone of following Incomplete recovery type? Scn-based ...
Nadeem Taj's user avatar
  • 93
1 vote
1 answer
231 views

Why does Oracle think that the timezone offset of Denver is UTC-7:00? The server time and systimestamp look right. Server 1: Oracle 11.2.0.4.0 SELECT SESSIONTIMEZONE FROM DUAL; America/Denver cat ...
Charles Burns's user avatar
  • 251
0 votes
1 answer
236 views

Here is my code: create table failed_login_attempts( login_id number(5) primary key, date_created timestamp default systimestamp, email varchar2(110), ip varchar2(24), mac varchar2(18), attempt number(...
MikeJ's user avatar
  • 13
0 votes
1 answer
805 views

I have a query where I want to fetch all rows where the value in column x is between 400-600. Including in this I want a matching column value from antoher table. But I want all 200 rows between 400 ...
Burry's user avatar
  • 103
1 vote
0 answers
148 views

I'm encountering error ORA-28374: typed master key not found in wallet when attempting to run alter database datafile '+DATA/testdb/datafile/users.2514.1233355332' encrypt; against an 11g database ...
Franco's user avatar
  • 51
1 vote
1 answer
703 views

I am confused about when Oracle database won't do parsing? In the AWR report, there is a metrics called "execute to parse", which means more SQL just execute without parsing when it ...
Jason Yang's user avatar
  • 11
0 votes
1 answer
2k views

I want to reduce the size of a table. I thought if I could do this with export / import, but when I check it with the ESTIMATE_ONLY option, it doesn't seem to work. I have no chance of using ...
jrdba123's user avatar
  • 29
1 vote
2 answers
2k views

I'm new with Oracle DBA in my new office, and they gave me a development server that already have a lot SID database online in SuSe (I checked with lsnrctl status) My questions are : How to check ...
ilham setiawan's user avatar
  • 11
0 votes
1 answer
515 views

I'm working on an Oracle Forms 11g application linked with an Oracle 18c database and I stumbled upon a strange error when compiling my form. Here's a snippet to illustrate the problem (I changed the ...
Riptide's user avatar
  • 101
0 votes
1 answer
324 views

I am trying to import a dump file from an 11g database into a 19c database instance. I am running the job as SYSTEM as recommended by Oracle. The job starts but quickly devolves into failing SQL ...
Daniel Grindstaff's user avatar
  • 5
0 votes
2 answers
5k views

I'm trying to join two tables and filter join results but I couldn't manage it and I'd appreciate any help. I have these row sets: Table A id | userid | targetid | start_date --------------------------...
dstr's user avatar
  • 101
2 votes
2 answers
1k views

I am using oracle 11g express edition and I am getting the below error when trying to create a change set. Error report: ORA-06550: line 2, column 3: PLS-00201: identifier 'DBMS_CDC_PUBLISH....
lse23's user avatar
  • 131
1 vote
3 answers
29k views

What's difference between parallel (4) and parallel 4 with and without brackets? For eg : select /*+parallel(4) */ * from table_name; select /*+parallel 4 */ * from table_name;
yash singh's user avatar
  • 11
-1 votes
3 answers
2k views

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.
Javad KHI's user avatar
  • 1
0 votes
1 answer
3k views

I'm currently studying oracle 11g,i had this question in mind but never found the answer even in the docs. What happens if log files storage is full? does the DB stop or block any DML or DDL execution?...
Zidani Mehdi's user avatar
  • 3
0 votes
2 answers
277 views

I am a student. I have assignments and projects simultaneously. I want my project database and the other simple databases separate. I have no option to use MySQL or others as my lecturer suggested to ...
abc's user avatar
  • 11
3 votes
1 answer
150 views

There are three tables with the same name Pantea in my recyclebin section of pl-sql developer and I don't know how to find the one that had been dropped the last (I mean the last version of the table)...
Pantea's user avatar
  • 1,502
0 votes
1 answer
18k views

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, ...
Kathir E's user avatar
  • 5
0 votes
1 answer
102 views

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 | ...
Jaw Mendoza's user avatar
  • 13
0 votes
1 answer
7k views

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 ...
Kathir E's user avatar
  • 5

1
2 3 4 5
…
15