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

Where to put standby control file in Physical standby database?

I am creating a physical standby database for which I am creating a standby control file using command = ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/oracle/dbs/stbycf.ctl'; but It creates only one ...
0
votes
1answer
402 views

Migrating Oracle Views to SQL Server

In the process of retiring an Oracle 11g host for an HRIS database, I've been asked to migrate as many assets as possible to a SQL Server 2016 instance for read-only archival. The volume of table ...
0
votes
1answer
13 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 (...
1
vote
1answer
82 views

Does tables under schema uses multiple tablespaces other than default tablespace

I have schema A in a database and have assigned the default tablespace as myspace. There are 20 tables that reside under this single schema and all the tables are using different tablespaces. My ...
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
2answers
1k views

Cloning the database to another server with raw data files

I'm trying to clone the database of server 1 to server 2 with raw data files. I'm using Linux 7 and Oracle 11g R2. I have the instance running with same SID in Server 2 but file structure is different....
0
votes
1answer
2k views

Oracle 11 IMPDP Table Exists but gets Does Not Exist Error

I'm running in to a weird problem with IMPDP and Oracle DB version 11.2.0.4.0 where I have a table in the destination schema that does indeed exist, but IMPDP thinks it doesn't. See this entry from ...
2
votes
1answer
2k views

When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
0
votes
1answer
11 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 ...
4
votes
1answer
2k views

How do I identify the remote db agent name to use in create_database_destination on Oracle 11gR2?

I am trying to setup DBMS_SCHEDULER in Oracle 11g to run a remote database job. I have a remote Oracle 11g R2 database on unix and a local one on Windows. I read that you can install the oracle ...
5
votes
2answers
2k views

FileWatcher Troubleshooting Options

I have setup a Credential/Procedure/Program/File Watcher/Job to monitor a folder for new files, but it is not working. I am trying to figure out what I can check to troubleshoot why this isn't ...
0
votes
1answer
556 views

Using JOINS in QUERY clause in EXPDP

I have a par file that is using JOINS in QUERY clause. But it is not working. directory=expdp DUMPFILE=Test_SIT_Query_1table_%U.dmp encryption_password=oracle parallel=8 logfile=TEST_SIT_Query_table....
1
vote
1answer
982 views

Query on SCAN in RAC

I have a two node RAC (Oracle 12c) on linux. I have 5 SCAN listeners configured. Currently, if I do a srvctl config scan I notice that out of the 5 scan listeners, one scan is running in one node ...
0
votes
1answer
28 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
78 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 ...
2
votes
2answers
1k views

Optimize large table design

First, I am a complete novice when it comes to databases, but have been given the task to speed up queries on a large set of data. (Hundreds of millions of records) The current implementation is a ...
3
votes
3answers
21k views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME -------------------------------------------------------------------...
0
votes
1answer
28 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
0answers
50 views

How to capture 'Deleted' and 'Updated' record after Merge in PL/SQL.TSQL 'Output' equivalent in PL/SQL

hope you're doing well. imagine I have a source and destination table like: Source(Column1 int , column2 varchar2(50)) Destination (Column1 int , column2 varchar2(50)) I want to merge these two ...
1
vote
1answer
36 views

How to prevent a column from repeating in the final result when using the LISTAGG function

I have a table like this: CUST_NUMBER | CUST_NAME | CUST_PROFESSION ------------------------------------------ 1 | Mike | Teacher 1 | Mike | Engineer 2 |...
0
votes
1answer
860 views

Error while installing Oracle 11g in Ubuntu 18.04

Also getting a runfixup.sh script which is also giving error root@szh-server:/tmp/CVU_11.2.0.1.0_zuman# ./runfixup.sh Response file being used is :./fixup.response Enable file being used is :./fixup....
0
votes
2answers
90 views

CSSCAN for the character set change, database version 11.2.0.3.0

According to Document 745809.1, Installing Csscan. While running the "Csminst.sql" we are getting below error SQL> @$ORACLE_HOME/rdbms/admin/csminst.sql create user csmig identified by csmig ...
0
votes
1answer
35 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
28 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
1answer
24 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
0answers
25 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
3 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
vote
1answer
1k views

Cannot connect to Oracle database server through SQL Developer but Test works OK

I am new to Oracle (from a SQL server and MySQL background) and have just installed Oracle 11g2 Express Edition. I have downloaded SQL developer which appears to be the Oracle world's equivalent to ...
0
votes
1answer
104 views

Backup files not found in ASM

I have an Oracle database 11gr2 and I have installed Oracle Grid on Oracle Linux 5.9. I have two disk groups. /etc/init.d/oracleasm listdisks : flash_recovery_area DATA The first disk group is ...
2
votes
0answers
52 views

Better ways to remove duplicate values of columns when using pl-sql “listagg” function in oracle

I have a table as you can see below : c_id | Name1 | Name2 | Name3 -------------------------------- 1 | a | b | c 1 | c | d | a 2 | d | e | a 2 |...
5
votes
1answer
25k views

Why Oracle SQL Developer does not need Oracle client?

I installed Oracle SQL Developer from Oracle's web page. It seems to work without a Oracle client installed on my computer. How is that possible? I also installed Toad for Oracle and it seems to ...
0
votes
1answer
164 views

Migration Wizard Offline SQL Server to Oracle, before Move Data, directory Data is empty

I'm migrating data that be in SQL Server to Oracle I'm doing it Offline, I generated .ocp, I ran the OMWB_OFFLINE_CAPTURE.bat, I passed the parameters and generated two directories, one called Master ...
0
votes
0answers
14 views

Oracle - How to find out ADVM file system type?

Is there some built-in command from Oracle to find out ADVM file system type? I was looking for it in advmutil command or acfsutil command. But I don't find anything. In Linux usually I use file -s [...
1
vote
2answers
48 views

How to use 'Bind Variable' with 'With clause' in a Dynamic query using PLSQL

I have three tables with these structures: 1) z_test_a(c_num number , <other columns>) 2) z_test_b(c_num number , Amount number , <other columns>) 3) z_test_b(c_num number , Amount ...
1
vote
2answers
10k views

Cleanup of Oracle killed session

I killed a session ALTER SYSTEM KILL SESSION '123,456' IMMEDIATE; But it remains in v$session for 10 days, although an attached process is absent in v$processes. SELECT s.username, s.osuser,...
0
votes
1answer
89 views

trying to get date to MM/DD/YYY

I have a coding using sqldeveloper under Oracle database using a student database, PowerSchool: PS_CUSTOMFIELDS.getStudentsCF(s.id,'CA_LastIEPDate') AnnDate This is a custom field, ca_lastIEPdate ...
0
votes
1answer
31 views

RMAN Backups - Can more than one media management software solution be used?

Does anyone know if it's possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN. So, for example, take an Oracle 11g standby DB with a ...
0
votes
1answer
20 views

Java application not using Transparent Application failover in Oracle database

I have a customer that have a RAC environment (2 nodes, database version is 11gR2). Clusterware version: [grid@server2 ~]$ crsctl query crs releaseversion Oracle High Availability Services release ...
0
votes
1answer
32 views

Is there a better way of displaying 'Count' of records beside other columns in a select query?

I have a table with below structure : Test1(c_num number ,c_first_name varchar2(50), c_last_name varchar2(50)) 1)There is a normal index on c_num column. 2)The table has nearly 5 million records. I ...
0
votes
2answers
94 views

How to use 'Bind Variables' in a 'Dynamic Query ' when the exact number of variables are not known

I have a procedure in which I'm using Dynamic SQL(variable actual_query) and I'm generating this query based on the input parameter i_tables which is a concatenation of the name of some tables. It has ...
0
votes
1answer
27 views

Oracle - Should processes limit be lower than sessions parameter

SQL> select * from v$resource_limit; RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE ------------- ------------------- --------------- ------------------ ------...
0
votes
0answers
9 views

Oracle 11g data guard in windows physical standby

I was wondering if there is a difference in setting up physical standby in windows and in Linux flavors. I don't find any documents or guides in setting up data guard in windows environment. All I ...
0
votes
1answer
34 views

The difference between using parallelism “/*+parallel(4)*/” in the subquery or the outer query in terms of performance in Oracle

I have the below query : select /*+parallel(4)*/ ---> First Location <Desc_1> Amount, <Desc_2> Amount, <Desc_3> Amount from (select /*+parallel(4)*/ ---> ...
0
votes
0answers
6 views

How to create hs oracle to SQLSERVER with rac scan

hi i am trying to create an hs for oracle rac for a course but i am unable to configure the hs How to configure the listener with scan_listener? hs example: odbc windows64 bits system dns: ...
3
votes
1answer
119 views

Alert on Table size

I need to create an alert on my application table when it reaches 98% of its threshold. I wrote an SP which checks the rows and logs the information into a log file which was monitored by alert system ...
0
votes
1answer
2k views

Why CTX_DDL.SYNC_INDEX procedure doesn't work?

I'm following the Oracle documentation to create indexes with Oracle Text. The problem is, when I update my data and want to synchronize my index with the CTX_DDL.SYNC_INDEX procedure (according to ...
0
votes
1answer
41 views

How to display the exact query in the output section of a stored procedure when using 'Dynamic SQL' and 'Bind variables' in Oracle

I have a Procedure as you can see below. In this procedure I have a dynamic querywhich is qry variable and I'm using Bind variable in order to eliminate the risk of injection and improve performance: ...
3
votes
3answers
482 views

How can I find a view column's base table column?

I program, administer, and support an ERP application. One of my more common tasks is to understand where data originates, finding the link between a particular report field and its data entry field ...

1
2 3 4 5
27