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) ...
0
votes
1answer
12 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
1answer
13 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
1answer
19 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
0answers
16 views
Connecting to Oracle from SSIS using ODBC
I am using SSIS to pull data from Oracle DataSource. In the Connection when I chose the Oracle provider and gave the necessary inputs I got error saying "Oracle client and networking components were ...
0
votes
1answer
33 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
0answers
26 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 ...
0
votes
1answer
56 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
72 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 ...
-1
votes
0answers
54 views
2 Outer Joins on Same Table? [closed]
Here is a question which has been boggling me for few days now, and I searched and searched but couldn't find any convincing answer !
Simple question, why is it restricted to have 2 Outer Joins in ...
2
votes
1answer
21 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
19 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
43 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
53 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
35 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
43 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
44 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
35 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
100 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
0answers
23 views
Oracle: Lost significant part of foreign-keys
I wonder how it's possible to lose in database about 80% of foreign keys?
We had development and test databases in parallel.
Now I have found that diff of the schemas shows that FK's are not there. ...
0
votes
1answer
31 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
0answers
14 views
How can I arrange / control the order of objects beeing exported from SQL Developer to a sql-file?
I want to define a specific order in SQL Developer, if I export the database.
I.E. First the Tables, then the package, afterwards the views etc.
Is it possible?
I'm using Oracle 11g and SQL ...
0
votes
1answer
23 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
43 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
40 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
30 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
1answer
59 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 ...
-6
votes
0answers
56 views
Difference between Sql server and Oracle [closed]
What is the Difference between Sql server and Oracle?
1
vote
1answer
66 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
1answer
24 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
46 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 ...
2
votes
2answers
32 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 ...
1
vote
1answer
25 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
58 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
48 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
24 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
28 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
41 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 ...
1
vote
1answer
30 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
34 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
73 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
30 views
Oracle 11g http listener configuration
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
37 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 ...
0
votes
1answer
34 views
Getting error ORA-01722: Invalid number but can't figure out why
I am trying to update a Oracle script to join in a new table but as soon as I add the new table via an inner join it generates an invalid number error and I cant figure out why. I have looked at the ...
-2
votes
0answers
24 views
How to Full Backup, Differential Backup & Transactional Backup Oracle in Linux OS [closed]
I'm beginner in Oracle. I just wanted to add to my knowledge. I have an Oracle database. I've done a full export of my database. It works pretty well so far.
My question is whether export is the same ...
2
votes
1answer
58 views
How to find Oracle home information 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.
...
0
votes
2answers
90 views
unloading data from oracle dbf files [duplicate]
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
...
-1
votes
1answer
45 views
Restore oracle database from DBF files [closed]
I have a list of DBF oracle files and I need to rebuild a database from these files, but I am a little newbie in oracle db administration
http://s9.postimg.org/mxmx0g73j/Untitled.jpg
0
votes
1answer
25 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 ...
0
votes
1answer
25 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 ...
0
votes
0answers
22 views
Giving schema a access to schema b? [duplicate]
For example one of the practice schemas that ships with Oracle 11g is hr. If I wanted to create a new schema on my home computer named 'my_cool_monkier' how would I grant that schema privileges to ...
