Questions tagged [oracle-11g-r2]

Oracle Database 11g Release 2. Please also tag oracle for search purposes.

Filter by
Sorted by
Tagged with
0
votes
0answers
20 views

Updating status on delete from another table (Oracle SQL)

How can I merge these two queries? delete from login where email='test@test.com' and date_created > created_date + interval '1' day; update staff set status_id=1 where staff.email=login.email;
0
votes
1answer
24 views

Fetch all rows and leave column value empty if no equality match

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 ...
1
vote
2answers
34 views

auto set value of a specific column after 24 hours and to delete record after one week: Oracle SQL

Here is my table: create table passwordResetLink( link_id number(5) primary key, link_date timestamp(0) default sysdate NOT NULL, isExpired number(2) email varchar2(110) UNIQUE NOT NULL, linkUsed ...
0
votes
0answers
17 views

How can I keep ASM groups in Oracle RMAN Duplicate?

Oracle 11.2.0.4 Whenever I issue a DUPLICATE on a Oracle backup, it always places all the files in to the default ASM diskgroup. I usually have the same ASM diskgroup structure at source and ...
0
votes
0answers
11 views

Oracle 11gR2 => Oracle Data Pump (expdp, impdp) => can backup be safely taken during runtime

until now I create a daily Logical backup backup of my Oracle 11gR2 Database at midnight while the database is running but the client application is in an idle state so that no queries are executed on ...
0
votes
0answers
23 views

RMAN Catalog requirement with DataGuard

If you have an 11g or 19c Oracle Standby DB setup using dataguard must you use an RMAN catalog when backing it up? I ask, because it was a requirement in much older versions of Oracle (e.g. 9i) but I ...
0
votes
1answer
46 views

Oracle 11g - Decreasing Big Table Size

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 ...
0
votes
0answers
38 views

import .dmp in Toad : Invalid format of Import utility name Verify that ORACLE_HOME is properly set

When I tried to import a DMP file using TOAD (9.0.1) Import Utility Wizard I get an error Invalid format of Import utility name Verify that ORACLE_HOME is properly set Any suggestions please? I ...
0
votes
0answers
8 views

Backing up an Oracle Standby database

I have a quick rman Backup question. If I would like to run RMAN backups on my (dataguarded) 11g physical standby database, what status should that standby db be in? At the moment the standby is in ...
0
votes
0answers
17 views

Why Oracle AWR report's I/O stats are different from the I/O monitoring data captured on operating system?

I am using Oracle 11.2 on Redhat 6.8, and working on some I/O issue. I got a AWR report of Oracle DB for a certain day, and I found that "Read per Second" in "IO Profile" section ...
0
votes
0answers
32 views

Oracle impdp INCLUDE parameter

I have an script that uses IMPDP over a database link (no expdp used) to import some data from our PROD environment to a DEV environment. Some tables are rather gigantic and partitioned, and we want ...
1
vote
1answer
52 views

The “unexpected greater” PGA size allocated in rman channel

Environment: RHEL 6.9、 Oracle 11.2.0.4 When we running some rman backup/restore jobs, we found the actual PGA size could greatly exceed the predefined limit value about PGA: Why the following ...
0
votes
0answers
35 views

Oracle XE 11.2.0 data pump expdb works on but impdb doesn't on Windows 10

New to Oracle DB administration here. I have a fresh localhost installation of Oracle XE 11.2.0 (x64 installation from here) on my computer using Windows 10 64-bit. I am able to connect to the DB ...
0
votes
1answer
30 views

Better way of handling incorrect date format in a column with “char(10)” data type / TRY_CONVERT equivalent in PLSQL

I have a source table with below structure: create table customer_info (customer_num number, birth_date char(10)) Unfortunately the birth_date column data type is char(10) instead of date. ...
1
vote
0answers
27 views

Naming a datafile with spaces in the name

I would like to know if there could be a problem when naming a datafile with spaces in the name, I have an Oracle 11gR2 database, using ASM as storage, a datafile was created, belonging to an ...
0
votes
1answer
32 views

Why is the schema name necessary here and how to compile without it

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 ...
1
vote
1answer
58 views

Oracle Enterprise Manager 11g Database Control - Agent Unreachable

Single instance DB. I can login to Oracle Enterprise Manger (OEM). However, on the Home Page it says: Status - Agent Unreachable Most tasks such as checking RMAN status, adding datafiles, etc. ...
1
vote
2answers
68 views

Query to find all dates between two specified dates using plsql

I have a table with below structure create table test_table ( customer_num NUMBER, card_number char(2), card_issue_date DATE, card_expire_date DATE ) Example data is: ...
1
vote
1answer
64 views

Query to find the “Number of days” a customer has an active card between a specified interval

I have a table with below structure : create table test_table ( customer_num NUMBER, card_number char(2), card_issue_date DATE, card_expire_date DATE ) Example data is: ...
0
votes
1answer
50 views

Oracle 11gR2 - Dynamic Registration

Database version: Oracle 11gR2 We want to use DYNAMIC_REGISTRATION_LISTENER parameter with off option. Our listener.ora file like this: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (...
0
votes
0answers
29 views

Login oracle database with Microsoft Active Directory error

I have two machines, one (let's call it dbmachine) has the database and client installed of oracle 11g release 2, the other one is the domain controller (let's call it dcmachine) and has the client ...
2
votes
3answers
281 views

If the maximum current value of an ID generated by a sequence is N, does that guarantee that all future rows will have index > N?

I'm debugging some legacy code and have found what might be a flaw in how it interacts with the database. A simplified version of it is as follows: TableA is acting as a queue. It has data inserted ...
0
votes
1answer
46 views

how to get the difference between 2 tables in 2 different schema's in Oracle? [duplicate]

I am using Oracle 11G. I have a table called Tickets in the schema called 'tickets1" I have the same table structure in another schema called 'tickets2' I want to find out What data is the same ...
0
votes
1answer
44 views

Does ' /*+parallel(<Specific Table >,4)*/ ' have better impact on query performance in comparison with simple parallel hint '/*+parallel(4)*/'?

I have three tables with below structure: create table customer_info (customer_num number, customer_firstName varchar2(100), customer_lastName varchar2(100), branch_code varchar2(...
0
votes
1answer
46 views

Same user cannot 'see' view on remote oracle database athough dblink is valid

I am running an impdp job that I have extracted the DDL from to determine why the job hangs. It consistently stops on the first object created using a dblink. I am running the impdp job as system as ...
0
votes
0answers
30 views

Can't connect Oracle 11g2 Database to Job Scheduler Agent on client/application server

Running 11g2 database on one Linux server and installed Oracle client and job scheduler agent on separate Linux (application) server sitting next to it. The connection betweeen them worked fine for ...
0
votes
1answer
292 views

ORA-31626: job does not exist during schema export

I'm exporting schema with following command - expdp system/system@xxx.xxx.xxx.xxx:1521/orcl schemas=schema-name directory=test_dir dumpfile=Schema.dmp logfile=SchemaLog.log but it results into ...
0
votes
1answer
21 views

Procedure with “bind varibale” does not return the desired result set

I have a table with below structure: create table CUST_MODERN_CHANNEL_BRANCH ( customer_Num NUMBER, channel_Code NUMBER(5) ) Some example data : Customer_Num Channel_Code ========...
-1
votes
1answer
23 views

Oracle can not find a record with a specific field

In our application we face an weird situation, consider a table name TAX exists in the database, when I query it with select * from tax where fk_pay = 123456 a record is returned with id = 654321 but ...
1
vote
1answer
139 views

Receiving error “invalid identifier” while trying to update a table in Oracle

I'm trying to transform a Merge query into an Update query for getting better performance but I could not succeed. Tables structure: create table TEST_FILE_MERGE ( customer_num NUMBER, ...
0
votes
1answer
32 views

PL-SQL “LAST_VALUE” function does not give the desired result

I have a table with below structure: create table DOC_AMOUNT_DETAIL ( col_id NUMBER, amount NUMBER, operation_date DATE ) and some example data for this table is : col_id ...
0
votes
2answers
24 views

PL-SQL query to find the most recent record the “Operation_date” of which is lower than a specified date

I have a table with below structure: create table DOC_AMOUNT_DETAIL ( col_id NUMBER, amount NUMBER, operation_date DATE ) some example data for this table is : col_id | ...
0
votes
0answers
52 views

Failling to create partition

I have this challenge with creating a partition by a range in 0racle 11g. While I wrote a script top partition my table and scheduled a job to run every month. Unfortunately just discovered that ...
2
votes
2answers
516 views

Import Tables without Constraints from Schema Export

I am trying to do an import using data pump, but I am struggling to come up with the right options. The export was taken as a schema export. I am trying to import just the tables, with no other ...
0
votes
2answers
73 views

we still can't find backup archivelog in local controlfile

Oracle database is Oracle 11.2.0.3 version. Every one hour, archivelog will backup to netbackup tape. But it is strange, even when we use resync catalog command, we still can't find the backed up ...
0
votes
2answers
43 views

Are there better alternatives rathet than joining a table twice for having one record for a specific column in the output?

I have two tables with below structures: create table TABLE_LC ( lc_num NUMBER, brn_code NUMBER, brn_role NUMBER) create table BRN ( brn_code NUMBER, brn_name VARCHAR2(50)) Some example data ...
0
votes
1answer
33 views

How to see the original text of the the function that has been wrapped by “DBMS_DDL.WRAP”

As I'm new to Oracle PL-SQL,I'm trying to be familiar with DBMS_DDL package and I used it to hide my source code,below you can see the example I'm working on: Declare v_string varchar2(32676); begin ...
0
votes
1answer
123 views

How to change the thread of redo logfile group in standby database?

Is there some way to correct the thread of redo logfile group? it's ok the thread to be wrong? executing the following query I get de logfile groups, thread and members: set linesize 2000; set ...
0
votes
0answers
56 views

Compare previous column and current column in ORACLE SQL and do SUM

This is my query to get TIME_DIFFERENT-> TO_CHAR (DATE '1900-01-01' + ABS ( LAG(MODIFIED_DATE,1)OVER(ORDER BY MODIFIED_DATE DESC) - MODIFIED_DATE), 'HH24:MI:SS') AS TIME_DIFFERENT Now, I want to ...
0
votes
1answer
214 views

RMAN restore of primary database - impact on standby database

I've just restored an 11g primary DB that was destroyed. Restored the controlfile from tape and performed a full restore, recovery, and open resetlogs. Looks fine now. How will my physical standby (...
0
votes
1answer
55 views

Oracle 11g RMAN restore without catalog

I need to restore an Oracle 11.2.0.4 database from Netbackup on to a different host. Is it possible to duplicate the DB with RMAN into an Auxiliary DB but without a recovery catalog? If it’s not ...
0
votes
1answer
48 views

What happens if log files storage is full?

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?...
1
vote
1answer
156 views

Encountered Error: ORA-00979: not a GROUP BY expression 00979. 00000 - “not a GROUP BY expression”

I want to join 3 table together and display the output as below.But i encountered the error when i tried to use group by and order by together. Is there any solution can solve this error? Below is my ...
0
votes
1answer
30 views

Seperate value of a specific column with “,” delimiter in Oracle using “Regular Expression”

I have a table with below structure: create table CUSTOMER_INFO ( cust_id NUMBER, cust_name VARCHAR2(50), cust_address VARCHAR2(50) ) Example Data : cust_id | cust_name | ...
0
votes
1answer
98 views

Why is the schema/structure dump so slow?

I'm using Rails 6 with activerecord-oracle_enhanced-adapter adapter for Oracle 11 XE database. At the beginning of the project I was working with Postgres, but due to customer requirements I had to ...
0
votes
1answer
570 views

Using 'Listagg' function and 'Regular Expression' to REVERSE the value of a specific column in Oracle

I have a table with below structure: create table TBL_TEST ( col_id NUMBER, col_name VARCHAR2(500) ) Some example data : col_id | col_name ----------------- 1 | aetnap 2 | ...
0
votes
1answer
32 views

Problem using 'Regular expression' in order to split characters of a column when there is no delimiter between them

I have a table with below structure: create table TBL_TEST ( col_id NUMBER, col_name VARCHAR2(500) ) Some example data : col_id | col_name ----------------- 1 | aetnap 2 | ...
0
votes
1answer
42 views

Oracle 11g migration to AWS

I have an on premise oracle 11g database that i have to migrate to an EC2 instance hosting Oracle 11g in AWS. I have three options to achieve this Use Oracle Data guard to replicate the on premise ...
0
votes
0answers
33 views

Startup Restrict Effect on Standby

If I do a startup restrict on the primary database, does this state effect the standby? In particular, I am interested in two things: Does it do anything to hinder archivelog shipment to the standby,...
0
votes
0answers
13 views

How to appy database security patches in an oracle failsafe environment

We have 4 databases in oracle failsafe cluster. 2 are dc(primary dbs) in failsafe cluster and 2 are dr(standby dbs) in failsafe cluster. Can anyone provide steps to apply patches to these databases.

1
2 3 4 5
27