Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...

learn more… | top users | synonyms

0
votes
1answer
13 views

query to concatenate columns if record duplicate

My table has two column that is id and name. I want to do concatenate the columns if the if more than two names are same like: id ...
0
votes
0answers
16 views

Foreign Key Constraint over two tables

I am trying to put the following entity-model into practice: We have a list of Payments, each Payment belongs to a certain store and is of a certain payment type (e.g. 10€ maintenance cost in ...
1
vote
2answers
37 views

Getting results without using IN

Oracle has a limit on the arguments in the IN statement of 1000, I believe, is there a way around this? If I had a statement similar to this (with 1000 ids or more): SELECT COUNT(*) FROM "VERSION" ...
2
votes
1answer
75 views

Can I exchange partition between two table with partition with same name?

I am trying to restore one partition from a backup table. Both tables have partitions with the same name. My goal is to grab the data from the backup table partition x and put it in original table ...
1
vote
2answers
28 views

ORACLE_HOME / ORACLE_SID variable - why do we need to export them ?

I am not sure if this is a bash / shell question or oracle question. I am on linux and oracle 11g. I have always export my ORACLE_HOME and ORACLE_SID variable and e.g. using invoking sqlplus is no ...
-1
votes
1answer
23 views

How to pass input parameter in stored procedure calling from single command line [on hold]

I know how to execute stored procedure by single command line echo execute some_procedure | sqlplus username/password@databasename But I am stuck how to pass IN parameter in procedure, actually My ...
0
votes
1answer
12 views

Long full scan hasn't returned but session is gone from V$SESSION

I have a query on a big table purposefully hinted with /*+ FULL() */ and uses partition pruning, and for a while the scans for each partition can be seen in V$SESSION_LONGOPS. After a while no more ...
0
votes
1answer
26 views

How can I call a remote User Defined Function?

I have SQL server which contains a link to another server(For e.g: test) I have a function in linked server(name:getvalue(@parameter)).so this function output i want to retrieve in SQL server 2012.I ...
0
votes
0answers
22 views

Is there a command like Linux `tail`, but for Oracle?

Is there a command like Linux tail, but for Oracle? For example just to leave open in a terminal, to view all SQL queries as they happen without having to refresh.
2
votes
3answers
35 views

Oracle data dictionary, tell built-in roles apart from custom roles

In Oracle, if you describe the DBA_ROLES view, you only get three columns: SQL> describe dba_roles; Name Null Type ------------------------------------------------ ROLE ...
0
votes
2answers
44 views

Getting the last data update time of a specific table in Oracle

How can I get the last update time of table, i.e. at what time the last operation (insert/update/delete) was performed on a table in oracle? I have tried using: SELECT ...
3
votes
0answers
29 views

View of structurally same tables [on hold]

Let's say I have two schemas (HR and Finance for example), in each schema I have a table with information about document types this department works with. Tables have the same structure: HR.doc_type ...
1
vote
0answers
31 views

Metrics for performance of Oracle

I am trying to measure various metrics for a stored procedure - that we are tinkering with and using under different loading (i.e. size of tables). So I have drawn up this list of metrics to plot ...
2
votes
3answers
109 views

Selecting records where date range is current year minus #years

I want to select and eventually delete records from a point in time earlier than current year minus "x" years. I'm unsure of the most efficient way to do this.
0
votes
1answer
33 views

Synchronise Oracle Tables to SQL Server

Our ERP is using an Oracle database while our BI system is based on SQL Server. We need to get the changed data in Oracle and copy it in our staging area. At the moment we get the changed rows by ...
0
votes
1answer
29 views

Location of RMAN backup

I have two servers. One is DB server another is RMAN Catalog DB server. From my RMAN Catalog, I connect to my remote DB server and I run the backup. Where will the backup files be stored? Will it be ...
0
votes
2answers
31 views

Is dmp file suitable despite ORA-01555 'snapshop too old' warnings?

Well, the title of the question is self-explanatory. Export finished successfully with warnings. Log shows several ORA-01555 snapshot too old errors. - Is it OK to use that dmp file to perform an ...
1
vote
0answers
20 views

trigger to first validate values in other table and then update

I have problem coding a trigger. The table structure is this: table 1: inventory field 1: item_code(PK) field 2: item_desc field 3: unit_price table 2: stock_master field 1: item_code(fk) ...
1
vote
2answers
39 views

Dropping Global Temporary Tables

In Oracle when you try to drop a Global Temporary Table that is in use you get the following exception: ORA-14452: attempt to create, alter or drop an index on temporary table already in use This ...
-4
votes
0answers
23 views

what is update cascading exactly in sql? [closed]

We have three table declarations for P1(A), Q1(B) and R1(C) with referential integrity in SQL. create table P1 (A primary key); create table Q1 (B primary key references P1(A) on update ...
1
vote
0answers
38 views

Oracle migration to SQL Server

I am working in a Oracle 11g database migration to SQL Server 2012, I did the migration using SSMA v5.3 and all works fine. However, I did re-write code in some objects like triggers and stored ...
0
votes
1answer
24 views

Does Oracle Instant Client 12c support LDAP?

I've been using Oracle Instant Client 12c as a lighter-weight alternative to the full Oracle installation. It works fine when I resolve service names with tnsnames.ora, but now I would like to ...
2
votes
0answers
15 views

sql error on script execution. try deleting repository before creating repository

I want to migrate my mysql databse to oracle. I have followed the migration demo from this url http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html but I got this ...
0
votes
0answers
26 views

Oracle DB - DR corruption

One of my databases in my DR is fully corrupted ( I have checked running validate database using RMAN). Now to recover all the data files which are corrupted I need to copy the data files from my ...
1
vote
1answer
18 views

Oracle How to Generate Multiple Ranges Based on a Result Set

Given a table like this: with qtys as ( select 3 as qty from dual union all select 10 as qty from dual union all select 9 as qty from dual union all select 7 as qty from dual union all ...
1
vote
2answers
31 views

Tables Visible to a Specific User?

Is there a way to get a list of tables and views that a specific user can see, without logging in as that user? Initially, I tried something like select distinct p.table_name as value from ...
0
votes
1answer
34 views

Two Oracle clients on the same server

Is it okay to have two oracle clients (both 11g and 12c) in the same db server? What are the potential issues I could face? The reason im doing this is to connect the app server where I'm deploying ...
0
votes
1answer
17 views

ASM RMAN BACKUP FAILED

I'm trying to migrate a filesystem to ASM but when I start with RMAN backup, I face the following error, which is weird because I haven't performed any backups before on the same database. RMAN> ...
2
votes
4answers
108 views

Finding all date ranges that overlap a target date range

Say I wish to store when staff are on holiday (FromDate, ToDate) and then I wish to find all staff that are on holiday between two given dates (QFromDate, QToDate). Now assume that I have many such ...
0
votes
0answers
28 views

Export backup from a different location

I have two servers. One database server and another is an app server. I have client installed in my app server and I have the respective the tns in my app server to connect to the db server. Now can I ...
0
votes
0answers
40 views

Remote connection to oracle database 12c [closed]

I have installed Oracle database 12c on my Window 8.1 x64. I want the database to be accessed through local network or internet? What should I do? Do I have to set specific settings?
-1
votes
0answers
26 views

Can MySQL Enterprise Edition be used for free with no time restriction? [closed]

My question is about product licensing by Oracle, specifically about MySQL Enterprise Edition licensing. I am not any DBA Master, I'm just a developer in search for answers from the real experts. ...
1
vote
0answers
37 views

Oracle tuning strategy for columns with long tails

We have an Oracle 11g database, where the two biggest tables are Customer and Order. The order profile of our customers has a long tail: we have millions of customers, with most only having a small ...
0
votes
1answer
25 views

Why is the result cache always disabled in Oracle 11g

I'm trying to enable the result cache in Oracle 11g. I have used Enterprise Manager to change the result_cache_max_size and result_cache_max_result values to '1M' and '100' respectively (maybe these ...
0
votes
1answer
25 views

Is it necessary for rownum = 1 with Query.createQuery().getSingleResult()? [closed]

I'm a newie and I'm not really sure if MIN(My_Date) returns just one row if 2 or more dates are identical. Reference is a FOREIGN KEY. so to limit query: SELECT MIN(Shipping_Date) FROM ...
0
votes
0answers
20 views

Reading audit records in Oracle

As a DBA, what is the best way to read the audit records on daily basis? Say, i'm the administrator and I would like to view the audit records made by the DBAs. I have enabled audit sys operatiosn to ...
0
votes
1answer
25 views

How to insert all the dates in a date range into Oracle database?

For instance, The date range is from 26th Jul to 1st Aug, that is 26th Jul, 27th Jul, 28th Jul, 29th Jul, 30th Jul, 31th Jul and 1st Aug How can I construct a function (of course, I need to ...
1
vote
2answers
34 views

Oracle lsnrctl stop

What does the oracle utility "lsnrctl" actually do? For instance, lsnrctl stop actually stops the listener and kills the process id, but does it also remove lock files or set/unset variables?
0
votes
1answer
26 views

pfile - client parameter file - starting an instance remotely

I do not understand how we can start an Oracle instance remotely using a pfile. If we ssh into the Oracle server and issue: startup pfile='/path/to/pfile';` the pfile is on the server side. How ...
0
votes
1answer
25 views

How to see query executed for a specific user from V$SQL

I am trying to have the queries used for a specific user at the end of the day. But it seems the queries in this view V$SQL are deleted every short time. I am not sure how much time. Also i dont know ...
-2
votes
0answers
19 views

How to distribute Oracle database [closed]

I want to distribute an Oracle database 11g on 3 servers but I don't know how to start. I read some documents like : http://docs.oracle.com/cd/B10501_01/server.920/a96521/ds_concepts.htm and some ...
0
votes
1answer
23 views

what are the prerequisite for installing oracle 11gr2

I have windows 2008 R2 sever and I want install oracle 11gr2 on this server. So any one tell me what are the prerequisite tools for install oracle 11gr2 like as a jdk and ect...
4
votes
1answer
31 views

How can I specify the DDL of the index that is implicitly created when creating a materialized view log?

When I create a materialized view log, Oracle implicitly creates an index on that log. For example, when creating a materialized view log on table foo, Oracle creates the view log table mlog$_foo and ...
1
vote
0answers
28 views

Allow user select from table in another user's schema that has policies set

I have an oracle10g database with 2 users - user A and user B. I want to select data from a table in user A's schema from user B. I have granted user B select privileges on the table in question but ...
1
vote
0answers
21 views

“Cut” records from one table into another in one oracle sql statement

I have a very big table T1 and i would like to copy every 15000 records to T2. After that I want to delete these same records. I want a fast and efficient way. I tried this but it wouldn't work : ...
0
votes
2answers
40 views

LOB indexes corruption in Oracle

Why is it not possible to rebuild corrupt LOB indexes? So if my LOB index is corrupted, how to recover it?
0
votes
1answer
30 views

what exactly does an RMAN backup do?

I have a database with multiple schemas and data in the tables. I create an rman backup and backup archivelogs. I drop 90% of the tables. I do rman restore and recovery with controfile from ...
0
votes
0answers
12 views

Oracle - ORA-01654: unable to extend indexIndex by 4096 in tablespace Tablespacename

I referred to below link and it is not very useful to me. ORA-01654: unable to extend index <name of the index> by 128 in tablespace <name of the Index tablespace> Now I have 2 Indexes ...
0
votes
0answers
11 views

Monitoring external Oracle db, creating changes locally to SQL Server

I have a local mirror database of an external database that our vendor provides us read access to. Occasionally they add columns and/or table to their database. The addition of columns used to play ...
1
vote
1answer
45 views

Is it possible to install oracle 12c without X window system

I am looking at installing Oracle 12c on a new server but the system admins are insisting that all new Linux servers don't have a GUI installed and that any administrative tasks are performed from a ...