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

0
votes
0answers
92 views

index usages on table with recursive relationship

we are working on a project that uses jpa and oracle. In this project we have a table with a recursive relation: Create table alarm ( id varchar2(200), ... alarmcode varchar2(50), parent_id ...
1
vote
1answer
34 views

Move Complete ORACLE from one system to another [duplicate]

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. [Oralce 11G Enterprise Edition] Entire ORACLE HOME ( bin , control files, data files ...
2
votes
2answers
649 views

Loading XML documents to Oracle 11g DB with control file

I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
2
votes
1answer
402 views

Enabling/disabling/changing Oracle auditing without a shutdown?

I have a large database that needs auditing on a very detailed level (every select, update, insert, and delete, along with the actual text of the statement) for about half the users. I know how to do ...
0
votes
0answers
44 views

in Oracle, which tables/indexes in query are responsible for disk reads?

Looking at the V$SQL_MONITOR view, I noticed some long-running queries where all the time is on disk I/O. I can see the total number of disk reads for the query. But how would I get the next level ...
0
votes
1answer
21 views

Stored Procedure with ROW instead of a list of parameters

i have a table with 15 columns, and trying to create a stored procedure in PL SQL that will only insert a row in a table using the INSERT statement. i would like to know if it is possible to declare ...
0
votes
3answers
45 views

What is the instance name of the box I'm logged into?

I'm at the linux prompt of a computer running Oracle 11. Without connecting to the database, how can I determine what is the instance name of the Oracle server running on this box?
0
votes
1answer
99 views

Compare Number of Rows of Tables

I have two or more tables different by structure and I want to compare their numbers of rows, which I get with the count-star query: select count(*) from table_a For two tables I would like to see ...
0
votes
0answers
24 views

Oracle Database Gateway for SQL Server - Output changes to multibyte view

I have a really strange problem querying a Microsoft SQL Server through a Oracle Database Gateway for SQL Server. Some query outputs look like this SELECT NAME, RawToHex(NAME1) FROM XY; Output: J ...
2
votes
1answer
40 views

Does a DDL in Oracle affect other transactions?

I understand that DDL statements in Oracle have an implicit commit before and after the statement, which obviously affects the current transaction. However, does a DDL statement in any way affect ...
1
vote
2answers
3k views

In Oracle how do you move a Schema to a different Tablespace?

I noticed that a Schema has been created in the USERS Tablespace but our local rule is that it should be in a Tablespace by itself. In Oracle how do you move a Schema to a different Tablespace?
-2
votes
1answer
88 views

Stored procedure syntax error [closed]

I am writing a procedure, independently the queries run fine with no errors.. But, when I run it as a procedure I get errors. Given below is my procedure create or replace PROCEDURE xyz(inuserid ...
0
votes
1answer
38 views

Access and filter in oracle plan

I came to a execution plan where oracle choose to access the index but instead of using the columns as predicate it only filter by them. My question is what are the reasons that can cause that(all ...
3
votes
1answer
417 views

Oracle: How to gather stats in a logical standby database?

I have a Primary and a (logical) Standby Database. The Schema 'APP' gets synced. Now a User has performance issues running a query against some tables in this 'APP' schema of the Standby Database. On ...
4
votes
1answer
89 views

date formatting in Oracle

this query: select to_char(sysdate, 'Ddspth MONTH, Yyyysp') from dual will return: Eighteenth MARCH , Two Thousand Fourteen i am wondering if there are any additional formatting keywords that ...
0
votes
2answers
92 views

In Oracle, why would an OR / LIKE(A,B) take far longer than running the same query for each condition separately and unioning

I have a complicated subquery that looks something like this SELECT ... FROM ... WHERE my_column IN (1,3) It takes a long time to run. I tried splitting it out into: SELECT ... FROM ... WHERE ...
0
votes
4answers
34 views

Oracle How to find Debug Compiled Stored Procedures/Functions

How can I get list of stored procedures/Function which are compiled for debug? I do not see relevant column in following tables. DBA_PROCEDURES DBA_OBJECTS
0
votes
2answers
45 views

Help about Oracle licensing

I would like to know some details about oracle licensing. What is oracle processor licences? How does it differ from the other?We are planning for a dual processor server, do we need to purchase 2 ...
0
votes
2answers
89 views

maximum number of interval partitions in Oracle 11g

Does anyone know the maximum number of interval partitions permitted in Oracle 11g? didnt find anything in Oracle documentation -perhaps missed something. Thanks in advance!
0
votes
1answer
44 views

Inserting data into a table with one value as clob and blob

My table has one clob column and one blob column. I need to insert data into it through insert statements. The length of data to be inserted is more than 4000 chars. When I do export of insert ...
0
votes
3answers
76 views

Oracle 12c create user

I have some problem with creating user in Enterprise Oracle Database System. A could'n create user using command like create user name identified by password; because of exception: ORA-65096: ...
2
votes
0answers
60 views

Historical SQL Monitoring

Is there a built-in Oracle feature that extends Real-Time SQL Monitoring to historical activity? I am specifically interested in getting wait events aggregated at the SQL operation level, not just ...
1
vote
0answers
65 views

Export Oracle Database User data from client

I am working on client system. There is a database on server contains many users. I have the access to database with a userid and password. my userid is "ncon" and Database name is 'HYDPPD'. We are ...
1
vote
1answer
48 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
1
vote
1answer
23 views

Cannot create directory with sysoper

My user has the two roles sysdba and sysoper. When I connect as sysdba I can sucessfully perform in sql plus: @> connect myuser/mypassword@myservice as sysdba; Connected. SYS@service> CREATE OR ...
1
vote
1answer
78 views

RMAN rename datafile created in an archivelog

I'm trying to restore an Oracle database (11.2.0.4.0) to a test system with a different file layout. The production database is being backed up using RMAN, no catalog. We do a full backup of all the ...
0
votes
1answer
56 views

How to interpret undo statistics in Oracle AWR report?

How can I use undo statistics in oracle AWR report for tuning Oracle? which indicators are important to identify that size of undo segments needs to be increased?
0
votes
0answers
26 views

Return a string from a pivot query

I have a query that uses around 6 or 7 tables and uses pivot to return a formatted string from this entire structure. Actually, today this query is dynamically generated via C#/Entity Framework and it ...
0
votes
1answer
29 views

Oracle to SQL Server

We have a table with 169 million rows in a Oracle 10g database, we need to move this table to a MS SQL Server 2012 database. Describe on the table: aaa NOT NULL NUMBER(38) bbb NOT NULL NUMBER(38) ...
0
votes
0answers
37 views

Exception in SQL client but not in stored procedure

I am using Oracle 11g and SQLDeveloper for this scenario. In this scenario, I am trying to simulate an exception within a stored procedure but it is not happening. My DB runs in GMT. My client ...
0
votes
1answer
31 views

Why don't HOST comands appear in the spool?

spooltest.sql: SPOOL test.log CLEAR SCREEN SET VERIFY OFF PROMPT Queries will appear in spool select sys_context('USERENV', 'INSTANCE_NAME') from dual; PROMPT Output from the HOST command will not ...
0
votes
0answers
168 views

Database Open but Oracle gives ORA-01033: ORACLE initialization or shutdown in progress

We are using 4 node Oracle 10GR2 RAC in Windows x64. 3 instances of our database crashed today and later started normally. I started them by connecting (Remote Desktop) to individual instances and ...
0
votes
0answers
31 views

Oracle Merge performance

I've a question about the merge performance in oracle. I work in the business intelligence area of a big company and its quite common to have to move millions of records one side to other. The other ...
2
votes
1answer
62 views

In Oracle AWR report how to use “Latch statistics” section in analysis

Latch statistics in AWR report contain following sections 1.Latch Activity 2.Latch Sleep Breakdown 3.Latch Miss Sources 4.Parent Latch Statistics 5.Child Latch Statistics How can I use these ...
0
votes
2answers
159 views

Backup Oracle DB using TSM server version 6.3.0

I'm new to Oracle and TSM server. I installed Oracle11gR2 and TSM server version 6.3.0 (linux Centos 6.4 OS). I did the configuration and everything works fine. so far I arrive to run the following ...
0
votes
1answer
158 views

Oracle Patch Update

We have an Oracle RAC production environment with primary and secondary DB. Our DBA has asked to update oracle version from 11.2.0.1.0(64 bit) to 11.2.0.3(64 bit) with patch 6880880,10404530,16803769 ...
0
votes
2answers
3k views

Oracle 12c Installation in Windows 7 error INS-30131

I am trying to install Oracle 12c in a Windows 7 x64 computer and after a while I get this error: SEVERE: [FATAL] [INS-30131] Initial setup required for the execution of installer validations failed. ...
0
votes
0answers
31 views

What is meant by the RMAN Duplicate “noncurrent point in time”?

When doing a RMAN DUPLICATE from backup connected to the target, how current does the duplicate make the database when no until time is set? The closest thing I can find in the documentation is the ...
0
votes
1answer
57 views

How to export oracle 11g database partially

I have a huge oracle test database whose size is more than 100 GB. I want to export only 1% of all the data and import it into my local database to have a local replica of that application. Is it ...
0
votes
2answers
48 views

Optional parameter in where condition

I have the following where condition: lr."dateEnd" >= to_date(?, 'dd.mm.yyyy') and lr."dateEnd" <= to_date(?, 'dd.mm.yyyy') All works fine. But the second unnamed parameter is optional. How ...
0
votes
1answer
27 views

Oracle, changed NLS_LANGUAGE and is now invalid and can't fix

I'm using oracle 12c, and changed the NLS_LANGUAGE variable to a invalid text using the manager at localhost:5500/em, after reboot the oracle db doesn't get up and Database Configuration Assistant ...
0
votes
1answer
49 views

Why Does SSIS Oracle Source by Attunity return DT_WSTR for Oracle CHAR(1) Column?

Using SSIS 2012 and Microsoft SSIS Connector for Oracle by Attunity v. 2.0. When I add an Oracle Source for a particular table, it is setting the data type for an Oracle CHAR(1) field to DT_WSTR. I ...
4
votes
1answer
46 views

Changes access method for non-correlated subquery

Oracle 11g R2 Unfortunately our application has per row security "features". We have a query that looks about like this: Bad, slow: SELECT someRow, someOtherRow FROM bigTableA a WHERE EXISTS ( ...
1
vote
3answers
40 views

ORA-12528 TNS Listner

When I try to connect the database using sql developer it gives the error below: ORA-12505 TNS:listner does not currently know of SID given in connect descriptor I have tried all the suggestions ...
3
votes
2answers
179 views

Perl DBI takes 60 seconds to connect to an Oracle database, every single time

I feel like I must be doing something wrong with my SQL connections. I've generally ignored it, but I'm finally going to try and get to the bottom of this. my $dsn = ...
0
votes
0answers
44 views

Explain difference between insert as select and select

Can someone explain why there is plan difference? Same query, same time the explain plan taken. I understand what happen (different order of getting the data) and how to fix it(move to forall insert ...
0
votes
2answers
1k views

Trying to create a sequence in Oracle that starts with the max value of primary key of a specific table. Why does this not work?

Trying to create a sequence in Oracle that starts with the max value from a specific table. Why does this not work ? CREATE SEQUENCE reservation_sequence MINVALUE 0 START WITH (SELECT ...
4
votes
2answers
2k views

Shrinking the SYSTEM tablespace in Oracle

Our SYSTEM tablespace grew out of control because of the SYS.AUD$ table. We have truncated SYS.AUD$ but the datafile is still very big (~30G). Resize doesn't work because the file contains used data ...
1
vote
1answer
60 views

Oracle dead with unknown reason

Our oracle database dead from time to time.When i look into the log in the alert.It shows: Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFEAA7DD0E0] [PC:0x8213123, ...
1
vote
1answer
37 views

assign “all values” instead of “null” in Conditional Where clause

I have to extract from a table based on user input. I have a table named Vehicle_Register with vehicle details and users are allowed to filter the data using vehicle type (car, bus, truck...). If no ...