Questions tagged [oracle-11g-r2]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
245 views

How to implement optional query parameters

I have a relatively big (10^7 rows and growing) table and I want to query some rows from it. Since table is this big - I want to use every perfomance boost that I can. My query has optional parameter ...
0
votes
1answer
428 views

External Table: VARCHAR in Create but CHAR in Access Parameters

Consider this SO Question UTF-8 And External Tables. A proposed solution contains VARCHAR2 columns in the CREATE section but those same columns get CHAR attributes in the ACCESS PARAMETERS section. ...
0
votes
2answers
62 views

Long query causes problems

I have a huge sql query which causes problems: select distinct subjectnr from proces where (produkttypenr = 1 or produkttypenr = 3 or produkttypenr = 4 or produkttypenr = 5 or produkttypenr = 9 or ...
4
votes
3answers
69 views

How can I pass on a value in the hierarchy based on the value of the parent using an hierarchial query?

I have a table with categories and another table with a discount for categories per user: create table category ( id NUMBER NOT NULL, parent_id NUMBER, name nvarchar2(255), PRIMARY KEY( id) )...
1
vote
2answers
1k views

Goldengate warning on table with primary key

Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below GGSCI (server01.localdomain as gguser@UPGR) 3> ...
0
votes
1answer
171 views

how to create an explain plan for the below query? I'm getting ORA-00900: invalid SQL statement error

I'm getting ORA-00900: invalid SQL statement error when i tried. but the sql query is running fine without explain. Query: create or replace view TaskView as select T1.PersonID,T2.ID ,T2.Task from ...
0
votes
0answers
149 views

RAC DB Slowness - AWR Report

While going through the AWR report found that the row lock waits on indexes and buffer busy waits are more (rest of the stats look normal). Could someone tell me if we can interpret by the below if ...
0
votes
0answers
2k views

TNS-12560: TNS:protocol adapter error

I cannot access oracle from remote due to my listener error. I checked all configuration files which are listener.ora, tnsanmes.ora and sqlnet but I didn't find any missing config. Below is my ...
1
vote
1answer
788 views

Oracle 11g stuck at installation in oracle linux no error msg only showing | and stuck

oracle not install on centos7 while installation it is stuck at 84% no error msg showing
0
votes
0answers
735 views

Recommended ratios for SGA and PGA size in oracle 11g

I want to change the size of my SGA parameters SGA_MAX_SIZE and SGA_TARGET. And PGA _AGGREGATE_TARGET, what will be the ratio I should adopt to set these parameters in 11g. My current database ...
0
votes
1answer
67 views

Diakrites land wrong in Oracle database

Every time we are rolling out a new release same tables are trancated and filled with fresh data. This process is done on a Windows pc with scripts that are run in SqlPlus. When we do this on our ...
-1
votes
1answer
84 views

Composite index and Normal index,redundant/duplicate index - Incurred Performance penalty [closed]

Need suggestion on below indexes, whether our composite index is enough and can the normal index be removed. Scenario - We have ix4 and ix6 indexes as below, please review and advise if ix4 is ...
0
votes
1answer
102 views

Oracle Internal Error [closed]

Getting oracle Internal error in oracle database 11gr2: ORA 600 [kkpogppi1] It shows everyday in incidents but whenever i check oracle logs it shows nothing and when i open problem details it ...
1
vote
1answer
938 views

I need help creating an encrypted listener for my 11gR2 database using a wallet and SHA1 encryption

We are using 11.2.0.4. Since Oracle connections are not encrypted by default and access personally identifiable ( PII ) data in our application we are required to go to an encrypted listener. I am ...
1
vote
1answer
210 views

Whats the term in Oracle, when I'm speaking about SCHEMAS on SQL Server

Here, we have our applications developed both for oracle and SQL Server. Devs are trying to fix their own way to be organized, using VW on views, PR on procedures and etc. they told me that they're ...
0
votes
1answer
900 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
3answers
59 views

Database Migration [closed]

We are migrating our one of testing servers. My questions are: What is a best way to migrate database from one server to another? If I do data migration through export/import utility (Full database ...
0
votes
2answers
5k views

Safe to use SQLNET.ALLOWED_LOGON_VERSION_SERVER in 11g sqlnet.ora file?

I have a mixed environment running both 11g and 12c databases on the same server. One of our databases was recently upgraded to 12c, and the older Oracle clients have started throwing ORA-28040 ...
0
votes
1answer
427 views

Always start Oracle DB in Idle State

Is there a way to setup your Oracle db to always be brought up in an idle state so that you can then 'startup' when you want to use it. I'm running Oracle 11g R2 on Windows with lean resources.
2
votes
1answer
874 views

How to copy a tablespace to another database without using Data Pump in Oracle 11G

I have a database on a legacy system that has some data that needs to be exported to another environment. Everything I need is contained in one tablespace. Unfortunately, I am unable to use Data Pump ...
1
vote
3answers
533 views

Move expdp part file before job end

I have an Oracle 11gr2 database running on Enterprise Linux 6.6 server. I use the following command to split the expdp dump file to 10G size chunks: expdp userid=/ DIRECTORY=dmpdir dumpfile=dump%u....
-1
votes
2answers
827 views

Creating Dictionary Management Tablespace Oracle [closed]

i am stuck at creating a dictionary management tablespace in 11g Release 2 Oracle 32 bit , I can't create a normal tablespace with dictionary management because my System tablespace is locally ...
0
votes
1answer
278 views

In a database trigger on event create - How do I reference the created object?

Given the following trigger: CREATE OR REPLACE TRIGGER TRG_CREATE_TABLE_INITRANS AFTER CREATE ON SCHEMA BEGIN IF SYS.DICTIONARY_OBJ_TYPE = 'TABLE' THEN exec 'alter table '||<table_owner&...
3
votes
1answer
305 views

How do I restore an Oracle file system backup onto a new developer machine?

A server (not mine) has died due motherboard temperature problems and disk controller problems. Given that the company's IT support should have known better, and so on, the company does have a file ...
1
vote
0answers
61 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
2
votes
2answers
155 views

How can to make a new user see table in existing schema [closed]

I'm new into Oracle so this question might be dumb. I created new user and now I would like him to see table (or even better all tables by one command) in already existing schema (hr schema in this ...
1
vote
2answers
968 views

How to configure Oracle11g to send out Password Expiry Notifications vide SMS or e-mail?

Please guide me in configuring Oracle11g to send out Password Expiry Notifications vide SMS or e-mail before password expiry of one week or upon user's profile entering into grace period or any other ...
0
votes
1answer
3k views

Is it feasible to escape ' (single quote) with ESCAPE clause, if yes, then how to do it?

I understand that we can use '' to escape a single quote in Oracle queries. However, I want to know if it is feasible to escape a single quote in the ESCAPE clause. set up: create table test_t ( x ...
1
vote
1answer
126 views

Oracle 11g - DROP database command on ACFS

In Oracle 11g and higher (on RHEL 6) issuing the 'drop database' command in mount restrict mode will delete all the DB's ASM datafiles. Can somebody tell me if this command also drops all ACFS ...
0
votes
1answer
7k views

How to execute sqlplus by root using sudo in linux?

Scenario: *oracle xe11g r2 is installed( and runs properly when logged in as oracle). *logged in as user, root *added root to groups oinstall and dba as follows: #useradd -G oinstall root #useradd -...
-1
votes
1answer
1k views

How to export response file from already installed Oracle database?

I know that I can follow the steps of Oracle Universal Installer (OUI) and choose to save a response file at the end (summary step) to use it in further silent installation, but is there a way to ...
1
vote
1answer
1k views

How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?

Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody defined an undo tablespace for ora2 and provided the same datafile of the undo tablespace datafile of ...
0
votes
1answer
321 views

How to run EM of Oracle 11g, if i haven't emctl, netmgr, dbca, OracleDBConsole<SID>?

I don't know what is wrong with my Oracle 11g, but it is missing a lot of things. After reinstallation it stays the same. My overall path is like C:\oraclexe\app\oracle and after it there are folders ...
0
votes
1answer
221 views

How to delete a datafile if the father-tablespace does not exists? [closed]

I just know Oracle basic and I would like to know about the datafiles. I have some files ".dbf" associated with Tablespace that already were deleted. I don't know how I can drop that datafiles and ...
1
vote
2answers
7k views

How to export dump of some schemas exclude some tables

I need to find the way make an quick and light weight dump export. It is the reason why I want to export only specific scheme and to exclude large tables. I use Enterprise Manager for it. Data ...
1
vote
1answer
502 views

SELECT all the children of a row and concat

I have this requirement that I need to attach a new column in select statement. It holds a string series of the disp_order of its children. I currently have the SQL statement only for the immediate ...
0
votes
1answer
3k views

Unable to connect to oracle database. Getting ORA12505 error

I am newbie to ORCALE I am trying to connect to oracle server and i am getting this error. This is was working fine before but now i am facing this issue. Need help An error was encountered ...
-1
votes
1answer
907 views

ASM Space Usage

Oracle Version: 12.1.0.2 I had about 100 GB freespace on my +ASM diskgroup on Friday. When I came back on Monday, I see only 45 gigs. How can I find what consumed my space? Or is there a SQLPlus ...
0
votes
1answer
220 views

program column is null in v$session

CREATE OR REPLACE TRIGGER AWH_TOOLS_TRG AFTER LOGON ON HRMS.SCHEMA DECLARE v_prog sys.v_$session.program%TYPE; v_pro varchar2(250); BEGIN SELECT upper(program) INTO v_prog FROM sys.v_$session WHERE ...
1
vote
1answer
1k views

Oracle convert multiple rows to column using pivot

I have a table that contains the values +-------------+--------------+---------------------+-------------+-------------+--------------+-------+---------+-----------+---------------+--------------+ |...
0
votes
1answer
624 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 ...
1
vote
1answer
2k views

Error granting SELECT on view that uses ALL_OBJECTS

I'm in the middle of testing Oracle 12c for our application. I have something similar to this view in a particular schema, which we'll call MY_OWNER_SCHEMA for this question: CREATE OR REPLACE VIEW ...
0
votes
1answer
65 views

Question about alerts in Oracle 11.2

I inherited an Oracle 11.2 server. I wanted to see if whomever configured it before me had any alerts configured, perhaps to notify on audit events. Logging on as sysdba, I issued this command per ...
0
votes
1answer
62 views

Scrambling PII data in CLOB columns

I am working on scrambling PII tags in CLOB columns such as <FirstName> or <LastName> or <SSN_Number>. so I am using the below query to achieve the same. UPDATE /*+PARALLEL(8)*/ ...
1
vote
1answer
70 views

Oracle table transfer between databases in two different hosts

I have a 500Gb table which I need to transfer to another Oracle database in another remote host. I have a 10 Megabits/sec speed connection between two hosts. What can be the most efficient way to ...
1
vote
1answer
6k views

ORA-39001: ORA-39000: ORA-31640: ORA-27041: and Linux-x86_64 Error: 13: Permission denied [closed]

I used this command to export data: expdp gsw/password DIRECTORY=gsw DUMPFILE=gsw.dmp logfile=gsw.log SCHEMAS=GSW Now importing this to other server as: [root@linux gsw]# impdp gsw/password ...
2
votes
2answers
726 views

Masking PII columns in Oracle

I am using Oracle 11g R2 on Linux, and I have multiple tables in my database that has got columns that needs to be masked. I have tried the OEM to mask the data as mentioned in the below hyperlink, ...
0
votes
1answer
74 views

Dealing with Oracle ARCHIVELOG during huge updates

It's required to update columns with metadata globally in all rows of all tables in DB. Let's say every table has a column MY_META and the aim is roughly update ANOTHER_TABLE set MY_META = 'HELLO' ...
0
votes
1answer
351 views

Creating an insert trigger on views

My table definitions look like this: I've created a view as: users_questions(qid,username,question) I want to create an instead of trigger on the view which puts the data going to be inserted on ...
0
votes
2answers
9k views

How to improve SELECT performance on a big ORACLE view? [closed]

I cannot use a materialized view for the base table data changed frequently. There are about 0.6 million rows in the_big_view. The query I need to do is: SELECT * FROM the_big_view WHERE ...

1
3 4
5
6 7
28