Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
0answers
17 views

Select only columns/fields where value is not null

I run the following SQL query SELECT * FROM emer_comp WHERE primaryKeyColumn = 'givenValue'; This way I can see all fields values corresponding to that row. However, this table has many fields that ...
0
votes
1answer
27 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 ...
-2
votes
0answers
27 views

returning records with null [closed]

This will only return records with values. I need all records to display, even if they are zeros. I though coalesce would work but maybe I'm putting in the wrong place. select district_id, school_id,...
0
votes
2answers
34 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
0answers
63 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
0answers
10 views

How works the flash recovery area

Im working with QGIS and Im trying to save a Mapinfo map to Oracle Spatial. The map file is around 1GB and has 700k road segment. The issue is when copy the segements from the source map to the db ...
0
votes
1answer
39 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 ...
0
votes
1answer
36 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
0answers
35 views

TNS-01153 : Failed to Process the String

I changed IP Server address which installed Oracle 11g on windows server. But my listener service has not worked so I can't access from the remote. Below are my listener.ora # listener.ora Network ...
0
votes
1answer
32 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 ...
0
votes
1answer
44 views

Oracle convert multiple rows to column using pivot

I have a table that contains the values +-------------+--------------+---------------------+-------------+-------------+--------------+-------+---------+-----------+---------------+--------------+ |...
0
votes
1answer
16 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
54 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
22 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
0answers
33 views

Error while importing database using impdp Oracle 11g

While importing the database using impdp I saw this in the log file . Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the ...
0
votes
0answers
20 views

Problems with SQL Loader Discarded Null or Blank Column

Hello Guys I need help I need to treat a field that be on blank or null with SQL Loader, but I'm having problem about this because the SQL Loader discarded columns on BLANK or NULL, so a tried that ...
0
votes
0answers
11 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
38 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 ...
0
votes
1answer
77 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 ...
1
vote
2answers
39 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
40 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
0answers
128 views

Prevention of ORA-01555: snapshot too old: rollback segment number with name “” too small

We have a cashier system relying on Oracle databases for data storage. Any time connection to the database abruptly goes down (for example due to the store being out of power and UPS not working ...
0
votes
1answer
34 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
44 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
24 views

Migrating Oracle 11G Fail Safe to new hardware? Multiple Cluster Nodes

We have a 11G 2 Node Active \ Passive Failover configuration that we want to move to new hardware. Is it possible to have 4 nodes running temporarily while we move everything over? I.E. 1 Active and ...
0
votes
0answers
74 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 ...
-7
votes
1answer
40 views

Please help to get OUTPUT as shown in figure [closed]

As shown in figure input, showing name, id and mount as 'AMT'. I want the output for that as I have written as OUTPUT1 and OUTPUT2 as final output
1
vote
1answer
41 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
110 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 ...
0
votes
0answers
14 views

How to link two Oracle servers

I am using two oracle servers. One is server A(local oracle server) and server B(remote oracle server). Note: Installed Oracle version is 11.2.0 Requirement I need to link server A and server B. I ...
0
votes
1answer
396 views

Swap utilization is high in oralce

How to reduce swap utilization in linux server which have running oracle 11g2 Server. currently is shows above 80 % in enterprise manager so how to identify the which process uses swap memory in ...
-1
votes
2answers
32 views

Using purge command in Oracle [closed]

I have two tables for database audit records (session, events). I know how to purge a complete table, but I want to purge two years data from these tables. Please help me how use purge in these case?
1
vote
0answers
23 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-...
1
vote
1answer
198 views

how to avoid already exists object errors while impdp 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 another instance, which is recently created. I'm going to import ...
5
votes
1answer
164 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
40 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
30 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
25 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
120 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
30 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
29 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
60 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), ...
0
votes
0answers
6 views

Problems with Oracle analytic function LAST_VALUE

I have a table like this: ID | Val | Ord --------------------- 1 | 1000 | 1 1 | 1000 | 2 1 | 2000 | 3 1 | 2000 | 4 1 | 2000 | 5 1 | 1000 | 6 1 | 1000 | ...
2
votes
2answers
71 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
20 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
0answers
102 views

Oracle 11g stuck at installation in oracle linux

I am trying to install oracle 11g in oracle Linux on virtual box. During the install process, I get stuck at the following screen for several hours. I have tried to restart the process multiple times ...
0
votes
1answer
370 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 be created with "BIG" Datafile. For recent time "Used (MB)" value increase insignificantly. So I want to ...
-1
votes
1answer
34 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
51 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
20 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 ...