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
1answer
904 views

How to limit select output from sqlplus?

I stop using SQL Developer as found more convenient to use SQL Plus inside Emacs SQLi mode. SQL Developer on selects with large amount of rows show only few rows. But SQL Plus tend to dump all rows ...
0
votes
1answer
420 views

Oracle shared memory exception ORA-04031 [duplicate]

I'm trying to establish an Oracle database connection. It throws the following exception: ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","unknown object","sga ...
1
vote
1answer
194 views

Migrating Oracle packages to SqlServer

I'm moving database from Oracle to SQLServer (2012 if that matters). The process of migrating tables/views is more or less straightforward and automated. Triggers are also not an issue since I don't ...
3
votes
2answers
154 views

Can I grant privileges to a role without specifying an object?

I am trying to create a role to simplify granting a set of privileges that I often give to users. I am wondering if there is any way to grant these privileges on only the objects owned by their schema ...
0
votes
0answers
140 views

Delete backup directories using RMAN

Is there any way RMAN can delete empty backup directories?
1
vote
1answer
664 views

Create spfile from pfile

I'm having a problem in creating spfile from pfile.I think I don't have permission to write on Oracle Home. I'm using Windows 8 SQL> startup nomount pfile='initlittle2.ora.txt'; ORACLE instance ...
0
votes
0answers
267 views

Creating and tuning a materialized view in oracle for use by Cognos BI

I am currently in the middle of a Cognos BI implementation and am having difficulty in tuning a view in order for SQL Server to select its contents for fulfilling the incremental load in a timely ...
0
votes
2answers
1k views

SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle

I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle". I am using "Export Data..." option from Task menu. I get to connect to the source database (SQL ...
0
votes
1answer
175 views

Error while opening Oracle 11g Database

I have a problem with oracle 11g database, I have shutdown my computer this morning normally, but in the evening when I tried to connect to my database I fond a problem. I cannot connect as normal ...
0
votes
1answer
45 views

Mview replication

We are setting up a large scale replicated environment and would like to know if there is a way to skip certain dml for eg. deletes during data trasfer with simple mview replication. Also, is it ...
1
vote
1answer
248 views

How to keep an Oracle 11g instance lean?

As a Mac user I run a local Oracle Enterprise Linux (OEL) Developer Day VM that houses an Oracle 11g instance for development/unit testing. I frequently refresh the data in the schemas (sometimes ...
1
vote
5answers
2k views

What happens when we create index

What happens exactly when I create an index on the empid column of this employee table CREATE TABLE employee ( empid number(5), ename varchar2(30), sal number(10,2) ); Let's assume the ...
2
votes
1answer
259 views

the value of undo_sql in flashback_transaction_query view is always null

so I have a table defined as follow: `create table test.test as (select * from dual); and ran the following update statements: update test.test set dummy = '1' where dummy = 'X'; commit; I want ...
1
vote
1answer
190 views

Oracle DBF import brings me to a weird situation

I have a big problem . One of my client send me some files to install them to his Oracle server but as a new user in oracle I am not sure how to do that. What I've recieved are this files : ...
1
vote
1answer
579 views

Oracle schema migration to new database with zero downtime

I have a problem: I have two production schemas on one database each serving two different appplicaitons. I need to migrate (move) one schema to an entirely new database that will be dedicated for ...
0
votes
1answer
2k views

Why Oracle SQL Developer does not need Oracle client?

I installed Oracle SQL Developer from Oracle's web page. It seems to work without a Oracle client installed on my computer. How is that possible? I also installed Toad for Oracle and it seems to ...
0
votes
1answer
303 views

Can we create a table in specific datafile - Oracle 11g R2?

I am buying a new server than has two HDs: 300 GB with 15000 rpm. 600 GB with 10000 rpm. I am thinking to allocate the datafiles in both hard disks. and put the less used tables in the data files ...
0
votes
0answers
94 views

Replicating Excel's CHIDIST function in Oracle 11g

I'm attempting to replicate the functionality of an Excel workbook in Oracle. One of the formulae on the worksheet uses CHIDIST, which "Returns the one-tailed probability of the chi-squared ...
0
votes
3answers
66 views

find sold subscriptions from table 1 and store name in table 2, joined by store id. (oracle)

I am trying to get the number of sold subscriptions from one table and the store name from another. The tables have a common column containing a store id, however the columns do not have the same ...
-4
votes
2answers
102 views

Find the salary difference between two months [closed]

Suppose we have 3 columns in a table emp_no, salary, month emp_no salary month 123 1000 jan 123 2000 feb 123 3000 march So, output should look like: ...
3
votes
1answer
2k views

How to combine `delete` and `insert` operations in one statement?

for the following data, I'd like to be able to delete some rows and insert others giving the result below. Is this possible with a single statement (eg with the merge statement)? create table ...
0
votes
1answer
316 views

Call pl/sql function and discard result

I'm calling a function from pl/sql, but I do not require the result in this case. Is there a cleaner way to call this function without using a dummy variable? Works: junk := performWork(); Does ...
0
votes
1answer
72 views

Can I update an Access table with an Oracle table?

I have an Access database with a table with a unique key and price field among other fields. I have been told I have access to an Oracle database with those prices in it and the linking Key. Can I ...
2
votes
2answers
1k views

Recovering a lost datafile with no backup available

How do you recover a lost datafile if: the database is running in archivelog mode there is no backup is available
2
votes
1answer
600 views

Recovering from the loss of datafile in NOARCHIVELOG mode?

How do you recover from the loss of datafile if the database is running in NOARCHIVELOG mode?
1
vote
1answer
1k views

Oracle Select with xmlquery() error - How to ignore errors?

In trying to extract a subset of data from a Oracle DB table, one of the columns is XMLType, which is extracted with xmlquery() for relevant information. The problem is that the XML data is from an ...
2
votes
2answers
727 views

Why do shadow processes exist?

Oracle architecture has two types of process: server process or foreground process and background process, but: Some people use it to refer to foreground processes, others use it for background ...
1
vote
1answer
156 views

What signals do the DBWn processes send to LGWR?

I would really like to know what signals are in the following quote from the Process Architecture docs, and how does DBWn know LGWR has completed? Before DBWn can write a modified buffer, all redo ...
0
votes
2answers
160 views

Oracle remove and place (re-install) database on 10g

I need to put together a plan to execute some change scripts to a Oracle 10g database, which will add some values, change some values a drop a table and create a new table. I have a step for creating ...
2
votes
1answer
108 views

Locking records in Oracle during update

I had a deadlock issue which was easy to fix by changing application logic, but I was under impression Oracle would behave differently, and the deadlock would never happen. I have two tables, for ...
3
votes
2answers
92 views

Deleting an Oracle database without connecting to it?

I have two databases which were created using dbca. I made some changes in the second database, and I can't login to that database anymore, and, of course, I can't delete it by using dbca. I am using ...
2
votes
1answer
118 views

Protocol used by Oracle RMAN to communicate with auxiliary

What protocol is used by RMAN to communicate with the server used for backing up/restoring data? I searched everywhere but couldn't find any docs with this information. Background: I am developing ...
2
votes
1answer
324 views

Does SQL Server have a reference partitioning equivalent?

Oracle 11g has introduced a new feature that is called Reference Partition. Using reference partitioning, a child table can inherit the partitioning characteristics from a parent table. ...
2
votes
0answers
796 views

Insert into table from a query to a linked database hangs

I have a schema with some database links to other schemas that we use to pull data from. We pull the data into a staging table, massage it, and then do some merges into our schema/database. The data ...
1
vote
0answers
315 views

rman 'delete archivelog all’ very slow

On our automated test system we use flashback all the time to reset our Oracle 11g database to a state before a testrun. We noticed some of the scripts involved started to become slower and slower. In ...
2
votes
1answer
325 views

Are there tips for writing Oracle DDL Triggers for auditing? Or should I just use AUDIT?

I've been tinkering with writing a trigger to log my table creation and manipulation for later tracking and review. The challenge is that my trigger logic is stored in the same schema on which I've ...
1
vote
1answer
3k views

Using wm_concat to concatenate rows, but in an order determined by another column

Let's say I have 3 columns: p_id, description, order_by. I am trying to do the following: I would like to concatenate the description for all like p_id values. So we are talking a group by p_id ...
2
votes
1answer
634 views

Convert Oracle database to Derby

I need to migrate an existing Oracle Database into a Derby one. I want to know if there's a tool, a script or another way to do that work. It is using any of the interesting features of Oracle, as I ...
0
votes
1answer
1k views

Cannot Connect to Oracle Database running on Windows 8 Hyper V Virtual Machine

I have oracle server (standard edition) installed on a guest VM (Windows 8 Hyper V). I have mapped a host entry to the VM as "brettvm". I am able to log into the VM and connect to the default ...
3
votes
1answer
539 views

Index on foreign key makes query extremely slow

We are recently experiencing a tremendous query slowdown with spilled over temp tablespace. A specific query causes this problem. The queried table (table3) has an indexed PK, three FK with indexes ...
0
votes
1answer
564 views

Oracle 11g http listener configuration for PL/SQL server pages

Could please someone point me how to configure oracle db to be able to display PL/SQL Server pages. I have successfully created and mapped dad with the DBMS_EPG. Here is the listener: # listener.ora ...
1
vote
0answers
45 views

What is a good way to Merge 2 range sets into a single view

The real purpose of this has to do with effectivity dates and contains additional keys and fields, but I simplified it for the sake of, well, simplicity. Sample: test_Widget Table theFirst ...
4
votes
2answers
1k views

How do you find home information for Oracle RAC on Unix?

Need help finding Oracle home path corresponding to a database instance in RAC environment. I am aware of few of the ways to achieve the same. Listing them below to avoid the same answers. ...
2
votes
2answers
2k views

unloading data from oracle dbf files

I have a list of oracle dbf files and I need to restore the information inside these files, there are no control files and anything else. only DBF file http://s9.postimg.org/mxmx0g73j/Untitled.jpg ...
0
votes
1answer
475 views

Unable to create a new listener in oracle 11g

In net manager i get an error message "A valid logfile is required" when i click on listener and choose '+' button. and then it keeps on giving me that error when i click on any other tab or button in ...
1
vote
1answer
308 views

USER_ID field in alert logs (also in V$DIAG_ALERT_EXT view)

Does anyone know what triggers the USER_ID field in the log.xml to be populated? The value also exists in the V$DIAG_ALERT_EXT view. I've found by observing the logs that if a temp tablespace fills ...
1
vote
2answers
750 views

Oracle datafile extension .dat or .dbf

I have seen these 2 extensions used for datafiles, .dat and .dbf while creating and/or altering a tablespace. I'm not sure what the difference between the 2 extensions is, or if .dat is incorrect. ...
0
votes
3answers
1k views

Sync two Oracle production server databases

I have an Oracle database that runs a 6 hours batch job every day. This process slows down performance during the 6 hours timeframe. Is there any method that I could use to build another server that ...
0
votes
1answer
1k views

Different dates Oracle 11g with TOAD

I have the following queries: SELECT to_date(to_char(to_date('01-FEB-1949'))) FROM DUAL; /*this returns 2/1/2049. */ SELECT to_date(to_char(to_date('01-FEB-1949'),'dd-MON-yyyy')) FROM DUAL; ...
4
votes
1answer
310 views

Oracle pivot on a column with delimited data

My data is like: keycol,col1,col2,col3 1,a;b;c,some data,some other data 2,x,some data,some other data 3,y;z,some data,some other data Where a column is delimited in the source system with ...