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

1
vote
2answers
86 views

Table design for multi-type data

The information model I am modelling from includes an "any type". For example a customer can have zero or more 'entries' each of which can have a number of values. Each value could be a either date, ...
2
votes
1answer
126 views

Oracle TimesTen vs Oracle database in-memory

Oracle has recently announced its latest Oracle database in-memory feature in 12c. Oracle already had an in-memory database TimesTen and now I was wondering as to what the the differences between ...
-1
votes
2answers
56 views

use of synonyms in oracle

I want to know the usage of Synonyms in oracle.I have searched in internet there i have learned like synonyms will be created in one schema and we can use that in another schema. But still am not ...
1
vote
0answers
50 views

How to ensure on Oracle RAC One Node that the OWB control service is started on the active node after a planned relocate or unexpected fail-over? [closed]

I followed the document 'How To Install a Warehouse Builder 11g Repository on a RAC' (Doc ID 1571166.1) to set up the OWB repository (11.2.0.4) on my Oracle RAC One Node system. Because it's a RAC One ...
2
votes
1answer
79 views

Oracle database startup fails several times. Giving ksvcreate

Last night my production server database (ORACLE 10.2.04) was showing me number of connection exceeded as some times it show me. Then as usual I shut down abort my database then at the time database ...
2
votes
2answers
211 views

Design of an application log database

We are generating logs like following example(this is a table no actual pipes): 2014-06-10 09:00:03.457 | Channel1 | Operation3 | Function15 | 15ms 2014-06-10 09:00:08.245 | Channel2 | Operation5 | ...
0
votes
0answers
41 views

What are the key points while using Oracle12c as application database

We want to use Oracle12c database as the default data store for our application. We would not be using the plugable database features ; only single instance standalone database. The database would be ...
0
votes
2answers
55 views

How to get next value of Sequence dynamically in Oracle

I used to a SQL guy and trying my hands on Oracle front. I am getting dynamic values of sequence in a variable. I like to fetch next value for that sequence object in some output variable. How to ...
2
votes
1answer
106 views

Does Oracle run queries to completion after SQLdeveloper disconnects?

The query is a CREATE TABLE t as SELECT .....; statement. Can I reliably count on Oracle to complete this after I disconnect? After I re-connect, how can I check on the status of this query?
0
votes
1answer
58 views

How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously

I have two servers, Oracle and SQL-Server. I have same database on both the servers. I want to perform DML (insert,update,delete). How can I perform same DML statements on both the servers ...
3
votes
1answer
57 views

How can I prevent having inconsistent data under isolation level serializable in Oracle SQL?

I have the following table: InStores +--------+---------+-----+ | ProdID | StoreID | qty | +--------+---------+-----+ | p1 | s1 | 25 | | p1 | s2 | 70 | +--------+---------+-----+ ...
0
votes
0answers
64 views

I use sqlDBx to connect oralce 12c, cannot connect

My computer is 64 bit.The sqlDbx that I am in the official website to download. I am a Chinese, hope ace to help me,thanks a lot !
1
vote
1answer
32 views

Is there a way to use Oracle XE as an easy-rollback “proxy” to regular Oracle [closed]

For development, we're currently connecting to shared dev databases that are way too big for XE (some are 100s of GB). Is there a way to set it up so that we can have a local XE on each developer's ...
2
votes
2answers
162 views

Why can't I drop this Oracle datafile - even though it seems empty?

This system is Oracle 11.2.0.3.0, using ASM. We had an issue where there seemed to be a corruption issue of some kind - every time a row tried to get inserted into the table, we'd get the following: ...
1
vote
1answer
62 views

Insert with different key values to avoid contraint violation

I have a set of Inserts traced of a database and I want to issue them into another similar one. The problem is that I'm getting contraint violation errors due the similar database already has the keys ...
0
votes
1answer
34 views

how do i configure Oracle Net Listener on a server with two network connections

I have a server that i have virtualized and as such it has two network connections, one to simulate a network between several virtual machines and the other to connect to the host physical network. ...
2
votes
0answers
99 views

Do OR conditions in Oracle SQL queries spoil index use / cause full table scan?

I have a query on Oracle 11g of the following type, which results in a series of highly inefficient full table scans: select t.Id, t.ObjectId, t...[other Tasks columns] , od1...[ObjectData1 ...
0
votes
1answer
50 views

Redo log size results into performance degrade

We are continuously doing heavy insert and update query, but after 10 hours data base is returning answer late in minutes normally it takes around 1 ms. I observed that "free buffer wait" and "redo ...
0
votes
0answers
64 views

Archive Logs not applied on Primary Database

I have a oracle database and some archive logs in the primary database have not been applied. When I run SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG order by SEQUENCE# I get the following ...
0
votes
0answers
50 views

INDEX SKIP SCAN performance on Index where first columns only contain 1 value

We're running an Oracle 11.2.0.3 database and have a table with above 10 columns in it. There is a non-unique index over all these columns. For simplicity in this example, lets assume the columns are ...
0
votes
0answers
20 views

10.2.0.5 RAC instance running on Linux-64 recieved KEWRRFC: Remote Flush slave Failed, return code: 2

Last Friday one of two instances in our 10.2.0.5 RAC cluster was non-responsive after logging the following messages. We ended up rebooting the node and it came up successfully. While I will likely ...
0
votes
0answers
24 views

Oracle sql developer: generating “CREATE” query list from an existing database [duplicate]

Is it possible with Oracle SQL Developer? If not, any other tool were also okay.
0
votes
1answer
26 views

Oracle structural synchronization [duplicate]

I'm having two oracle databases. A is used for production, B is some kind of staging instance where people are preparing content that is brought to the production system over night. It is a fully ...
0
votes
1answer
61 views

Oracle DB - Is it possible to distribute data of a table onto multiple servers?

BigTable[1]-like systems (HBase[2] for instance) allows a table to be distributed transparently accross multiple servers. This works as follows: Each server perform the read/writes operations on ...
1
vote
1answer
71 views

How do I differentiate between user-defined public synonyms and built-in public synonyms?

I am trying to query the Oracle ALL_SYNONYMS view, but filtering by OWNER=PUBLIC returns both synonyms I have created and Oracle created ones. Is there a way to distinguish between the two?
3
votes
1answer
78 views

Installation of Oracle Instant Client on an Ubuntu 64 machine

I would like to install Oracle Instant Client on a Ubuntu 64 bit machine. Following this link, I have installed the rpm packages basic, development and sqlplus using alien. Then: sqlplus ...
0
votes
1answer
38 views

Efficient matching rows across two tables with huge data set

I have two tables with about 300+ columns and 20k+ rows each. Each row is characterized by a primary key which both tables have.I have to find the identical rows, rows with changes,and rows without a ...
0
votes
1answer
189 views

How to know which process is causing high memory usage on DB?

I've got one Onesight alert mail stating below: Short Description: Onesight Alert: ZEUS DB Monitor (zeus04) Description: Solaris 5.8: vmstat memory(free) - Free Memory for zeus04 2065112 8:06:02 ...
0
votes
0answers
60 views

How to fix type conversion error in Data Flow task?

I have an SSIS job with a data flow task having an OLEDB source and OLEDB destination. I am moving almost 40,000 rows from one DB to another DB. In my SQL query**(Source**) , i have 10 columns all ...
-1
votes
1answer
44 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
1
vote
1answer
48 views

Script to Output Tables to CSV Showing Heading Only Once [duplicate]

I am trying to write a script that will output a table to a CSV. The tricky part has been to get the output to only show the header once. The script below does not show the header at all. The other ...
0
votes
1answer
99 views

Couldn't find the long running SQL under v$session_longops

I have following SQL running from a long time. I couldn't see the status When I tried to look the time remaining for the query to complete. Can someone explain me why I couldn't find the SQL status ...
0
votes
2answers
44 views

check constraint where values must be a table name

Is there a way to write a check constraint such that values in a column are limited to table names currently in the schema? It appears subqueries are not allowed (ORA-02251), but logically I am ...
0
votes
0answers
64 views

How to install ROracle on Linux

I am trying to install the ROracle library. This fails: install.packages("/storage/Downloads/ROracle_1.1-11.tar.gz", repos = NULL, type = "source") ** package ‘ROracle’ successfully unpacked and MD5 ...
0
votes
1answer
39 views

Testing multiple queries from input file

I have set of tables and need to execute select query based on different users. Table names are stored in file and I am looking forward to write a script to execute a script to read table name from ...
1
vote
1answer
70 views

Object changed during datapump

If some object is being changed when data pump is run how will that object go into datapump file?
4
votes
3answers
223 views

Is there a good way to link tables and sequences?

I'm pretty sure you can't do this like you can with foreign keys but I'd like to document at the database level (even if it's just as a bit of free text somewhere) these relationships. Is there some ...
0
votes
0answers
34 views

Oracle 9i Low performance on Windows Server Enterprise 2003

I'm facing some problems with performance with my Oracle database running on a virtual machine with Microsoft Windows Server Enterprise 2003 with 8GB RAM. It works pretty well after the database is ...
0
votes
1answer
52 views

How to call the unix Sendmail from oracle

I know that is possible to send mails using the oracle-db by UTL_SMTP, and there are several examples of such usage everywhere. My question is: Can I call the GNU/Unix/Linux Sendmail to perform a ...
0
votes
1answer
652 views

ora 20001 error in oracle dbms scheduler

i have written a test job like begin DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_job' ,job_type =>'plsql_block' ,job_action => 'null' ,enabled => true ); end; / after a while when ...
2
votes
1answer
179 views

ORA-00922 encountered in Oracle 11gR2 installer

I've just run the installer for Oracle 11gR2 on a Windows Server 2008 (64-bit) OS. I encountered the "ORA-00922: missing or invalid option" error at the last stage of installation when it was doing ...
1
vote
2answers
125 views

Oracle 11.2 using too few memory

it is about one year that I have changed my server from Oracle 10g to 11.2g (and also changed the hardware and Windows from 2003R2 to 2012). The problem is that with more than doubled cpu power, ...
0
votes
1answer
76 views

Unable to migrate local database to RDS instance

I recently created an MySQL instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance from the MySQL command line. I will brief you the details. 1) I want to move/migrate my ...
0
votes
2answers
303 views

Moving a table to a different tablespace in Oracle using Online Redefinition Vs Alter table move tablespace

I have a table with 1 Billion records with size 300GB to move to different tablespace. My question here is - What is the advantage of using DBMS_REDEFINITION (Online redefinition) package over Alter ...
0
votes
1answer
92 views

FAST REFRESH ON COMMIT on Materialized view

I am trying to implement a materialized view which would Fast refresh on commit. I have created materialized view logs on base table as well but i am faced with the following error. ORA-12052: cannot ...
0
votes
1answer
47 views

Specific issue on data pump API in oracle

I have a client/server architecture. Using an Oracle dbms on the database server side. I need to perform a user-triggered (from client side) backup of the database, where the best way to perform that ...
0
votes
3answers
53 views

Invalid create index syntax

I cannot create index with the where clause. Refer the below query: CREATE INDEX c_bplocation_isdefault ON c_bpartner_location (ad_client_id,c_bpartner_id,isdefault) WHERE isdefault = 'Y';
0
votes
2answers
82 views

How to reuse code in Oracle Script?

I have a script where I am creating some test data. At the beginning of the script I create some tables where I have to insert the data. Before creating them I check that they do not exist. declare ...
0
votes
0answers
75 views

How to startup a oracle database with sql plus or with any developer tool without connecting to the Database

How to startup a database without connecting to Database. Actually what I did is I shutdown my database and then my sql plus screen hanged and so closed unhandled. then I tried to connect my ...
1
vote
1answer
54 views

Oracle dump to csv an keep NULL as empty string

I have the following sql file: SET COLSEP ';' SET ECHO OFF SET FEEDBACK OFF SET TERMOUT OFF SET PAGESIZE 32766 -- Maximum number we can set. -- i.e there will be duplication of ...