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
2answers
23 views
Oracle tables partition related
Here is my doubt. Is it possible to apply a partition to one table depending in the partitions values of another one?
Why I am asking?
I have one table where information headers are persisted, and ...
0
votes
1answer
17 views
Trunc sytax problem
If any one could help me with the syntax issues which I am facing here.
sqlshipped := ' and a.ORDS_COMPLETED_DATE between( '
||shippedfrom
||' and trunc('
...
0
votes
1answer
29 views
Slowness after migration to RAC 11gr2
we are getting slowness after migrate from ORacle 10gr2 single db to Oracle 11204 oracle rac (standard ed) with asm, on oracle solaris 11. at this momento we have only one node. In the next days we ...
0
votes
0answers
22 views
ORA-15321: cannot set attribute with connected clients
I need to set an attribute on my ZFS Storage Appliance. I have shutdown all attached databases but still I get this message:
SQL> alter diskgroup DATA_ZFS02 set attribute 'storage.type'='ZFSSA';
...
0
votes
1answer
20 views
Defining the host on a new installation of Oracle 12c Enterprise Manager
I just started working with Oracle's products, and I downloaded the "Developer Day" VM from the following link:
...
-1
votes
1answer
35 views
How to compare a result of a query to a number? [on hold]
I have a query that return selects a table and returns one column with a number, and I want to know if the result is > 0.
SELECT * FROM Table WHERE
(SELECT amount from Table2) > 0
...
0
votes
0answers
29 views
dynamic query manupulation
I am trying to append a dynamic query given below to a non-dynamic query.
Given below is the dynamic query.
sqlFilter1 := ' and (g.STSL_USRS_ID = ' || User_ID || 'OR (dept.DEPT_NAME IN (select ...
0
votes
1answer
37 views
ORA-15081: failed to submit an I/O operation to a disk
I have a test environment for Oracle single instance on ASM 11.2.0.3.
I have restored database from tape and during the recovery, the system crashed by some I/O error.
I restarted the server, ...
0
votes
0answers
36 views
How to forwarding connection between 2 Oracle Database?
I have 2 Databases on independent 2 Linux server. I'm using Oracle 10G and 11G.
I have this stage:
client -> connect to Server A
-> check Database A (check specific tablespace or database A is ...
-2
votes
0answers
18 views
Which databases allow signed and unsigned datatypes [on hold]
Which databases allow set signed and unsigned datatypes, i mean among prodution versions, of popular dbs like oracle, postgresql, mysql, sql server?
0
votes
0answers
16 views
Oracle data obfuscation on specific columns with set field sizes
Would like to obfuscate data held in Oracle tables, but:
Requirements
only apply to specific columns e.g. personal data
obfuscated value should not be longer then column size
possibly only ...
0
votes
0answers
24 views
EMCA port Issue on Installing Oracle on Windows Server 2008 guested on VMware
I am trying to install Oracle 11gR2 on Windows Server 2008 guested on VMware Workstation 10 but I am getting this error on Enterprise Manager Configuration.
I also tried to login to the database ...
0
votes
1answer
24 views
Implement a deduplication trigger in Oracle
I am new in Oracle DB. We are using Toad for Oracle. I need to implement a deduplication trigger for our table. It's an alarms table and a third party vendor will be sending alarms to our database. ...
0
votes
1answer
28 views
Why we usually have UNIFORM Allocation type for creating Temporary tablespaces in ORACLE?
Actually i'm a new to Oracle DBA field , when i was going through my database i saw that for temporary tablespaces we have UNIFORM allocation type . So i just want to know the exact reason for this .
0
votes
1answer
65 views
table or view does not exist
am trying execute this lines in procedure :
FOR I IN (SELECT * FROM TBL_MT_MOATA WHERE MT_RECEIVED_TIME between TO_CHAR(TRUNC(SYSDATE,'Month' )) AND LAST_DAY(TRUNC(SYSDATE, 'Month'))) LOOP
...
0
votes
1answer
42 views
12c Shell to Linux
I am replacing two Oracle 11g servers with 12c
TL/DR - when shelling out to a run an O.S. file, the PATH environmental variable is not being set.
On the old servers we use an external library to ...
0
votes
0answers
19 views
How to display '0' against an empty database field (number) with defined fomat mask [duplicate]
I have an Oracle Report (11g) in which I have selected a number field containing amount and have mentioned the format mask as 999,999,999,999. The data is displayed as follows.
Data1 25,000 Data2
...
0
votes
1answer
28 views
How to display '0' where no data found in PL/SQL Oracle Reports
I have an Oracle Report (11g) in which I have selected a number field containing amount and have mentioned the format mask as 999,999,999,999. The data is displayed as follows.
Data1 ...
0
votes
1answer
22 views
Recover data from bak Oracle 9i file
Our customer gave us a .bak archive with name file_decrypted_379299.bak which we know was created with Oracle 9i in "hot" style.
We tried to recover the bak file with Oracle 9i RMAN but we don't know ...
2
votes
1answer
36 views
Oracle idle connections lost
I have a problem with an Oracle 11g instance.
Every connection that has been idle for about 20 minutes are lost.
I get the following error
ORA-03135: connection lost contact
I did the following ...
0
votes
0answers
48 views
“ORA-19599: block number 1 is corrupt in archived log” while doing active duplication of database
I am attempting for Active database Duplication and facing the ORA-19599 error.
Script used and error are below:-
duplicate database to reynolds from active database nofilenamecheck spfile set ...
0
votes
1answer
40 views
Oracle strong ref cursor with dynamic sql
I'm using Oracle 10g. I have a query in a stored procedure that selects entire rows from a table. Currently it returns a strongly typed ref cursor (tablename%rowtype). Now I have to add some dynamic ...
0
votes
1answer
63 views
How index work in oracle? [duplicate]
I want to understand :
How index work in oracle.
How they are stored in the disk.
How they increase the efficiency of a query?
By third point I means how Index contribute to the efficiency of ...
0
votes
2answers
43 views
How to store a database table in multiple disks with assigned ratio?
I am going to deploy database tables to multiple disks.
My database layout would be like following example:
There are 3 tables (Customer, Order, Product) and 4 disks (disk_A, B, C, D).
Customer: 5% ...
0
votes
1answer
30 views
Installing Oracle 11g on Windows SBS 2011 64 bit
In the Oracle web site, I found the following requirements:
http://docs.oracle.com/cd/B28359_01/install.111/b32006/reqs.htm#CHDHGGFE
Oracle Database for x64 Windows is supported on the following ...
0
votes
1answer
39 views
query to search a particular word/string in toad/oracle
I trying to find out a word/string named 'audapro_ind' in oracle database in toad. This word can be present anywhere in column of table, function, procedure etc. in oracle database
I tried few ...
0
votes
2answers
58 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
40 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
18 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
64 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
3 views
Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00
I'm trying to use data pump to move the database to a different server with this command:
impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP
But I got this error:
...
0
votes
1answer
28 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
50 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 ...
1
vote
1answer
5 views
ORA-29339: tablespace block size 16384 does not match configured block sizes
My box is RHEL 6.2, and file system BLOCK SIZE is 1024.
# tune2fs -l /dev/sda1
...
Block size: 1024
...
My Oracle is 11g, and database block size is 8192.
SQL> show parameters ...
0
votes
0answers
17 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
37 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
35 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
23 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
27 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
58 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
48 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.
0
votes
0answers
24 views
Where to get the old version oracle service?
I want to do some work with the existing long-run-time of Oracle database, such as 8, 9 or 10, because the newest Oracle's TNS protocol has changed(and always between different release), so Wireshark ...
0
votes
0answers
35 views
how to install Oracle Developer Tools for Visual Studio
Does anyone knows how to set up this Oracle tool in asp.net vs2012? this is the link http://www.oracle.com/technetwork/topics/dotnet/index-087367.html
2
votes
1answer
38 views
Does Windows Server File Compression slow Oracle DB performance?
I'm starting a new a new contract and I get to troubleshoot their Oracle instance... I'm more apps and sql, but I'll be trying to figure out their crashes and slow performance. Go figure.
I can ...
-1
votes
1answer
22 views
How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?
This error shows up when I try to connect to database string host:port/servicename.
0
votes
1answer
49 views
exporting oracle tables on command line as sql files
I use exp and expdp to export database tables on command line but it generates binary .dmp files. I want to export/import tables as .sql* files on command line like pl/sql developer app can do. Is ...
0
votes
2answers
53 views
How to make a trigger work after a certain UPDATE
I would like to know if it's possible to create a trigger on Oracle that is invoked only when a certain UPDATE is done. For example:
UPDATE colors
SET tastes_good = y
WHERE color_name = 'Apple';
...
0
votes
0answers
41 views
Equivalent of old style join with new style
Can someone please help me write the following join expression in new style:
Select tb1.col1,tb2.col2
from table1 tb1, table2 tb2
where tb1.col1>=tb2.col2
I know that the equivalent of
...
2
votes
2answers
298 views
Query hangs forever at first but works after one day
I have two schemas namely A and B. I regularly copy contents of 10 tables from A to B. Here's is how I do it
First I rename the original tables in schema B
Then, using SQL Developer I copy the table ...
