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

How can I force a bushy tree join in Oracle SQL?

As far as I know the default join is the deep left join. How can I force a bushy tree join on 4 tables?
-8
votes
1answer
48 views

Grouping Row Values Query [closed]

How can I write a query to get the result below from the sample data given? Data in table EMP is as below: Empid Empname Sal Comm 100 ABC Null 20 100 ABC 20000 null Output should be: Empid ...
1
vote
1answer
32 views

Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?

A database application I'm working with uses Oracle scheduled jobs to perform certain tasks. The DBA insists that hard-coding the schema name in the procedures that organise these jobs improves ...
0
votes
0answers
17 views

What is a CLRExtProc oracle instance?

An lsnrctl status output: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, ...
0
votes
0answers
17 views

Oracle AQ Message Replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far ...
1
vote
2answers
165 views

Is it possible to define package procedure/function outside of package body block (for Oracle)?

Is it possible to define package procedure/function outside of package body block (for Oracle)? Simplified syntax for defining package body is: create or replace package body <package_name> IS ...
2
votes
1answer
234 views

Finding why an Oracle listener got automatically restarted

I got the following message in the <listnername>.log file. I want to find out the reason why it got automatically shutdown and restarted again with different PID. 03-MAR-2013 03:00:57 * ...
0
votes
0answers
24 views

What is the story about Oracle CREATE TRIGGER … CALL syntax?

I was able to use the CREATE TRIGGER ... CALL SOMEPROCEDURE; syntax but I'm a little bewildered about it. I expected to see some implicit arguments like TABLE%ROWTYPE new but that doesn't seem to be ...
4
votes
1answer
417 views

What is the meaning of “select * from relational(owner.table)”?

We recently got some errors in our alert log of the form 301598: Tue Jul 16 03:58:29 2013 301599: ORA-01555 caused by SQL statement below 301600: SELECT * FROM ...
0
votes
1answer
109 views

sqlplus is not starting

I have a strange error on a Red Hat machine. InstantClient is installed in and ORACLE_HOME is set to /opt/oracle/product/112030_cl_64/cl/ The user which installed the client was oracle:oinstall. My ...
0
votes
0answers
19 views

are temporal relationships a good candidate for Oracle cubes?

We have a requirement in our database to represent various "temporal" relationships in our data. A simple example would be an event table where I want to know how many days prior to the event date ...
1
vote
1answer
57 views

Why is the System tablespace in manual segment space management mode?

Why has Oracle kept the SYSTEM tablespace in manual segment space management mode? I searched on forums but didn't find the answer.
-3
votes
1answer
23 views

Why DBMS_METADATA.GET_DLL not work with EXEC command ?

Using Oracle 11g I just trying to understand the concept here.... Why the command bellow not work? (executed at SQL Developer) execute dbms_metadata.get_ddl('VIEW', 'VW_CARGA','INT') Error ...
1
vote
2answers
69 views

Oracle becomes too slow after system crash

I am using Oracle 11.2 as a database for my application. For this purpose I should import my data (around 100m records) to this database. For this purpose I used SQL Developer. Unfortunately at the ...
0
votes
0answers
38 views

explain plan ,joins and optimization

I have to join 6 tables in sql query and each of these tables have 1 join to each of there master tables . Hence i have defined 5 subqueries within a sql query but i am seeing a lot of performance ...
-1
votes
1answer
155 views

Inserting dates before year 1950 in Oracle

How can I insert date which is before 1950? update up_sif.tb_person set dateB =to_date('18.10.1949','DD.MM.YYYY') where ID = '123345'; It keeps update with date 18.19.2049. Any ideas?
10
votes
7answers
6k views

Tools to monitor Oracle Database Performance on Standard Edition

Here is what I am looking for: Works on Standard Edition i.e. No Diagnostic Pack. Provides both current and historical performance data. Good visuals for easy spotting of trends and presentation ...
0
votes
1answer
146 views

Mistake during Oracle 11g PITR

I tried using set time until.. and mis-typed the date. Can anyone help me understand how to get my backups into a manageable state? After the accidental recover, most of my backupset disappeared. I ...
0
votes
0answers
17 views

oracle timesten in-memory database connection

I am going to connect to Oracle timesten database inside java application. For this purpose I wrote a simple connection class. When I try to run this java class an error " Problems with loading native ...
1
vote
0answers
43 views

Importing bulk csv file to oracle database

I am going to import a bulk csv file to oracle database. This file contains around 200m records. I was wondering what is the best way of importing this file? I check the performance of SQL developer ...
0
votes
1answer
22 views

How to generate create table script without primary and foreign key in Oracle [duplicate]

I have lots of schemas and tables. I want to generate create script of all of my tables. I am using below statement and it is working pretty well. SELECT ...
2
votes
1answer
8k views

How do I grant execute permission to an Oracle database user?

I'm trying to call a Java function from Oracle database that does the following: Process p = Runtime.getRuntime().exec("..."); When I try to run it, I get the following error: ORA-29532: Java call ...
10
votes
4answers
3k views

Is Oracle more demanding environment for a DBA than SQL Server? [closed]

I don't know Oracle at all but I have heard Oracle DBA's saying that working with Oracle (as a DBA) is "harder" and more difficult and more demanding than working with SQL Server. Does this statement ...
0
votes
1answer
36 views

“Reformat” an Oracle instance [closed]

I'd like to "reformat" an Oracle instance. I think as if it had been reinstalled, but maybe faster. Also I want a complete cleanup. Is it possible?
0
votes
2answers
45 views

Decode everything that is not defined as 'internal' or 'Web' to 'external' (oracle)

I'm trying to decode a columns with about 30 different possible values down to 3 values. I want the decoded value to be "internal" if the original value is "Interal KS & others", or "Web" if the ...
1
vote
1answer
47 views

How to generate create table script without primary and foreign key in Oracle

I have lots of schemas and tables. I want to generate create script of all of my tables. I am using below statement and it is working pretty well. SELECT ...
0
votes
1answer
82 views

Oracle ASM Failgroup

The Oracle 11gR2 Automatic Storage Managament Administrator's Guide says: When Oracle ASM allocates an extent for a mirrored file, Oracle ASM allocates a primary copy and a mirror copy. Oracle ...
0
votes
1answer
17 views

Revised Question: How do I prevent Oracle 12c Database from starting on machine boot

I'd posted previously about srvctl, didn't realize it was only used if a Grid Infrastructure was installed, which in my case, is not. Anyways, I have Oracle 12c Database installed on my Windows 8.1 ...
0
votes
2answers
30 views

How do I tell the actual IOPS used by Oracle?

This is hopefully a simple question. We have a large DB deployment that we need to scale up over the next year. For scaling we have been relying on our vendor, but recent developments have caused us ...
0
votes
1answer
144 views

oracle XE on windows XP stopped working

I know this will be greeted with derision, but yes I'm running Oracle XE on Windows XP. Long story involving office policies and VMs. Actually it's been working fine for a couple of years, but today ...
1
vote
1answer
56 views

How does SQL*Plus connect to Oracle without a listener?

sqlplus can be used even if there is no listener in the system, or if it isn't running. How does SQL*Plus connect to Oracle without a listener?
1
vote
1answer
944 views

Cannot set MEMORY_TARGET for Oracle 11.2

I'm trying to configure an Oracle installation on a developer machine (Windows 7 Professional 64bit). The machine has 16GB of RAM and I'd like to configure MEMORY_MAX_TARGET to 8g but have ...
0
votes
1answer
90 views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME ...
0
votes
1answer
619 views

Cannot create an instance of OLE DB provider “OraOLEDB.Oracle” for linked server

i am having a bit of a linked server problem . I created a sql server linked server and it's been working fine for last 2 years and suddenly not working . SQL Server Microsoft SQL Server 2005 - ...
0
votes
1answer
61 views

PLS-00049 bad bind variable when compiling a trigger

I'm trying to implement a dedupe trigger to a table. CREATE OR REPLACE TRIGGER USER.TBL_ACTION_DEDUP BEFORE INSERT ON USER.ERRORTABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN IF ...
2
votes
2answers
698 views

12c Grid Agent installation issues - Shell path is incorrect or not defined

I am installing 12c Grid Control agent on my server via Enterprise manager. The targer server is a UNIX server with AIX OS on it. I add target host manually, enter authentication information, host ...
0
votes
2answers
48 views

Instead of static list, using a table select result for IN key

I use a static list for some queries WHERE clause like WHERE STypeID IN ('12', '13', '14', '265') This list will be changed in the future; new values will be added. When list changed, I don't want ...
0
votes
1answer
34 views

ORACLE Shifting from from one version to another

I have RHEL5 server with Oracle Home actual location is SAN, which is mounted on this server. Now for few Reasons I have one more Server with RHEL 6 64Bit. I will map those storage LUNS there, What ...
0
votes
0answers
70 views

how to stop all Oracle instances [closed]

Is there any way to stop(or restart) all Oracle instances? I can't control my Oracle service called "OracleServiceOrcl" so I need to stop all running Oracle instances.
0
votes
2answers
152 views

Oracle - Clause where in case when

all! I want to know how wrote this code of SQL, I already trying but i get message error. I wrote two way different this SQL. See you below SELECT * FROM tabela WHERE coluna IN (CASE WHEN 1 = ...
0
votes
1answer
35 views

Export synonyms content to tables

I have a distant database to replicate having huge data but I have access only to synonyms and I would like to use Oracle export/import tool to import these data into tables of local database. What ...
1
vote
1answer
143 views

ORACLE error while dbstart command

I'm trying to start up Oracle DB with startup command. But error occurred while startup. dbstart[80]: test: argument expected Failed to auto-start Oracle Net Listene using /bin/tnslsnr touch: ...
0
votes
2answers
2k views

How to move csv file into oracle database using sql developer?

How to move csv file into oracle database without creating table firstly using sql developer rather than sql loader?
1
vote
2answers
361 views

How to make sqlplus output appear in one line?

I have a table with 100 columns. When selecting data in SQL Plus the output wraps, making it difficult to read. What I'd rather like is either a horizontal scroll bar to appear or somehow send the ...
0
votes
2answers
2k views

Linux Error: 29: Illegal seek in LSNRCTL for Linux Version 11.2

I'm trying to get Oracle Database 11g Express set up on my server so that it is accessible from the outside. I can talk to the DB locally using SQLPlus, so the database is definitely running. I ...
0
votes
0answers
34 views

Oracle Enterprise Manger not working correctly

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: Where to find the log file to see what's the ...
0
votes
0answers
21 views

Multiple handler entries in lsnrctl services output

This what I get for an lsnrctl services. LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-APR-2014 10:01:43 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to ...
1
vote
0answers
38 views

DTC Timeout when trying to update oracle table through link that contains a text index

Problem Given is a SQL Server connected to an ORACLE Instance as a Linked Server. It’s using the Oracle Client OLEDB Provider. When doing an update in a transaction on a table having a CTXSYS.CONTEXT ...
0
votes
0answers
27 views

Importing dump file contents to another DB with different schema using Oracle Data Pump

I asked this question in stackoverflow but no one was able to answer it so am trying my luck here if anyone knew what am talking about. Here is the link original question. What i wanted to do is to ...
2
votes
2answers
430 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 ...