Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

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
75 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
155 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
54 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
106 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
196 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
735 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
54 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
2k 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
499 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
422 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
158 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
137 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
4k 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
130 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
754 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
466 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
75 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
760 views

Oracle convert multiple rows to column using pivot

I have a table that contains the values +-------------+--------------+---------------------+-------------+-------------+--------------+-------+---------+-----------+---------------+--------------+ |...
0
votes
1answer
172 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
680 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
38 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
33 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
44 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
2k 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
167 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
44 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
211 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
3k 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 ...
0
votes
0answers
518 views

Oracle db crashes with ora-00822

I've restored database to another host, backup of production db was restored to our testing environment to provide actual data. And it looked like everything is fine, users switched to new db and ...
0
votes
1answer
222 views

Reclaim Database Wasted Space

In our company we have a test server on which Oracle RDBMS 11g is installed. My question is related to reclaiming wasted space. I ran the following query: select table_name,round((blocks*8),2) "...
1
vote
0answers
603 views

SAP Oracle Full Online Backup Failing

we have a SAP instance that runs on Oracle 11.2.0.4.0 DB. Since a while full online backups are failing every time. Full online backups are scheduled in SAP tcode DB13 (or DBACOCKPIT) and use BR*Tools ...
1
vote
2answers
5k views

Swap utilization is high on Oracle server

How do I reduce swap utilisation on a Linux server which is running as an Oracle 11gR2 Server? Currently it shows above 80% in Enterprise Manager. How do I identify which processes use swap memory ...
1
vote
0answers
65 views

How to keep only those archivelogs that are created after a latest db backup in oracle 11g?

I am little confused with oracle db backup. I have configured my Oracle 11G DB with ARCHIVELOG in Fast Recovery Area (NFS mount). I only need latest backup to restore in case of failure, but no point-...
2
votes
1answer
1k views

Avoid already existing objects when importing into Oracle

I need help with impdp. I have taken a backup with: expdp system/pw@orcl full=y directory=abc dumpfile=full.dmp Now I need to import the dump into another instance, which has recently been created. ...
5
votes
1answer
768 views

Same table alias for two different tables (Oracle)

This example has the same table alias used for two different tables. I don't understand why this is allowed by Oracle, and if allowed, how the results make any sense. create table Table_A (x number);...
1
vote
1answer
41 views

Oracle commitlog

I'm having what I suspect is a race-condition in an Oracle application I inherited. Is there any way to see when commits against a table was made? I don't care what was changed (at least not for now), ...
1
vote
1answer
91 views

Scheduled tasks in Oracle 11g

I have a scheduled task in Oracle 11g scheduled to run at 12:00 and 17:00 each day. If the first run takes more than five hours, what would happen to the second scheduled run? Would it simply be ...
0
votes
1answer
80 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 ...
2
votes
2answers
384 views

Execute sql file in Exception statement

Hi I'm trying to execute an SQL File in a Exception Statement when I'm executing an Spool file. I have something like this: column dt new_value _dt select to_char(sysdate,'yyyymmdd_hh24mi') dt from ...
0
votes
1answer
350 views

Error remote connection from Oracle 11g

I am trying to connect to my Oracle Database 11g from another computer connected in the same network. In the connection data I put the address of the server machine, but it does not allow me the ...
2
votes
0answers
108 views

Upgrading Oracle ODBC driver from 11 to 12 causing code to fail

In the process of replacing our servers which involves updating the Oracle ODBC drivers from 11 to 12. We have a process that executes on these servers that calls a stored procedure. The procedure ...
2
votes
1answer
87 views

Oracle DBA - what's the difference between the connection strings?

I'm working on a .NET application that is supposed to connect to any OracleDB but I'm a bit stumped, trying to get it to work on different versions. I originally started with Oracle 11g (Express), ...
2
votes
2answers
109 views

Oracle grouped row counts to columns

I have a table which contains this data: - ID - PRIMARY KEY, INTEGER - PC_ID - INTEGER - USER_ID - INTEGER - PAYMENT_DATETIME - TIMESTAMP - FIO - VARCHAR2(255) When I do a SELECT I get this (example)...
0
votes
0answers
33 views

Oracle - 'Correctly' configured ACL fails with network access denied by ACL

I have the exact same ACL privileges (used same sql script) on two separate databases. It works on one, but is denied on the other. Both databases are meant to connect to the same resource. Tried ...
0
votes
1answer
2k views

How to shrink “permanent” tablespace?

I have a tablespace has size 307,200 MB and "Used (MB)" is 103 229,81. This tablespace was created with "BIG" Datafile. For recent time "Used (MB)" value increase insignificantly. So I want to shrink ...
-1
votes
1answer
40 views

I want output as below

PARENT_COIL CHILD_COIL ROUTE ORDER_NO ORDER_NO AB1 AB2 1 111 AB1 AB2 1 111 BB1 BB2 1 222 ...
0
votes
3answers
85 views

Restrict sysdba or system administrator from reading package in oracle 11g

I have a requirement wherein the oracle database contains packages which have important stored procedures and functions which should not be exposed to the client / customer. The client / customer will ...
0
votes
1answer
24 views

Oracle 11g - PL/SQL block - Unable to use a newly added column in subsequent DML

begin execute immedate 'alter table my_table add new_column varchar2(30)'; update my_table set new_column=old_column; end; Here the update statement fails stating that the new_column is not ...
0
votes
2answers
75 views

how to join below to queries in single query

I have following query, How can I join these two queries into one. SELECT BATCH_NUMBER AS "BATCH NUMBER", ORD_NO AS "ORDER NUMBER", ORD_ITEM_NO AS "ORDER ITEM NUMBER", ...
1
vote
1answer
739 views

Oracle 11g Fast Add Column Taking 11 Hours

To the best of my understanding, a new feature of Oracle 11g is the ability to add a not null column with a default value very quickly as it would no longer auto-update every row in the table with the ...