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) ...
-1
votes
0answers
5 views
Problems installing Oracle XE 11g on Fedora 20 - No apex, no network access
I need to setup a temporary Oracle XE database on a virtual machine to work as a server, so I choose Feroda as Oracle mainly support RedHat.
So, this is what I did:
a) Downloaded newest version of ...
0
votes
1answer
25 views
Tips on using SQL access advisor in Oracle
Please share how to use oracle SQL access adviser for single or multiple queries. you can assume that we know the sql ids for the queries we are interested in.
0
votes
1answer
31 views
ORA-30009: Not enough memory for CONNECT BY operation
I have a Linux VM (with CentOS 64 bit) where I installed Oracle Database 11g Express Edition. The database is running, I can use sqlplus and I can create tables and stuff. However, when I run a ...
0
votes
1answer
7 views
Oracle silent install on Redhat Linux (The Global database name was left blank.)
I am installing Oracle 11g in silent mode using the response file that is in the database/response directory. It is three response files in that directory(i.e. dbca.rsp, db_install.rsp and netca.rsp). ...
1
vote
1answer
43 views
What useful information can I get from ASH report which I cannot get from AWR report?
What useful information can I get from ASH report which I cannot get from AWR report?
What are the common scenarios in which its better to get information from ASH than from AWR?
0
votes
1answer
22 views
Bad bind variable in audit trail trigger in Oracle 11g R2
I have been trying to construct audit trail triggers and procedures in oracle and I am facing a problem with bind variables. Following is the code
create or replace trigger trg_audit_trail
for insert ...
0
votes
1answer
41 views
What index(es) should I use for three columns join?
I have a table which has the following columns:
CREATE TABLE example (
exid INT,
extype INT,
studentid INT,
(more columns)
)
The table will have hundreds of thousands rows, and each ...
0
votes
0answers
12 views
Slow exporting SAP Data Services to MySQL (Oracle is faster)
We've a MySQL 5.1 server and we are trying to import data from SAP Data Services from another server. It works but it takes 3h!
We tried to setup an Oracle XE server to test the same operation and it ...
0
votes
1answer
26 views
Oracle - Date of Selection on table
how to get last date when someone perform selection on table? Last accessed in terms of select statement only not last updated date
-3
votes
0answers
16 views
Oracle - Last Select Statement Date on table [duplicate]
How to get last date when someone perform selection on specific table or in simple last date when someone accessed that table using select statement).
0
votes
0answers
15 views
Oracle installation requires old rpm versions, what to do?
I am installing Oracle 11g R2 on OEL6.
I run the following command, for to check only prerequisites
./runInstaller -silent -responseFile /0/grid/response/crs_install_mk.rsp -executePrereqs
It ...
0
votes
1answer
14 views
Exporting from Oracle enterprise edition to standard edition reaches schemas limit
So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink.
It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers ...
0
votes
1answer
19 views
Check only prerequisites when running runInstaller in silent mode
I want to check just prerequisites and generate a log without installing Oracle database.
When I run the following command:
./runInstaller -silentvalidate -responseFile ...
0
votes
2answers
42 views
Finding all sql id, sql text, number of executions,execution time between two AWR snap ids in oracle
AWR report provide the SQL information for top 10-20 SQLs, is it possible to get information on SQLs that do not make it to the top list. How do we find all sql id, sql text, number of ...
1
vote
4answers
39 views
What does SQLCODE = -00942 signify?
I am very sorry if I am asking a very basic question, but I googled for this and found no useful info.. Please help me under what sql code -00942 stands for..
thanks in advance.
