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
4k views

How to fix error ORA-00322: log is not current copy

I have to submit my project a day after tomorrow. My project is ready but I am having above mentioned error while connecting to Oracle database. I tried the following solution: Enter user-name: sys ...
0
votes
0answers
80 views

Viewing tables and data from a tablespace that was attached from another database

I'm using a database Oracle 11g. I have a DBF file of an old tablespace from a different database that I want to connect to the existing database. I've created a tablespace with REUSE caluse, and it ...
0
votes
0answers
117 views

Error ORA-06550

CREATE OR REPLACE PROCEDURE pro_department_report AS v_did department.deptid%TYPE; v_dname department.dname%TYPE; v_sname student.sname%TYPE; v_count NUMBER(2); v_sdid student.deptid%TYPE; CURSOR ...
0
votes
0answers
80 views

Oracle APEX Button creating ORA-00920

I have a table for user registration with a column for account_status which I filled with the content from SYS.dba_users. I also have a APEX application for this table and some other stuff and want to ...
0
votes
0answers
219 views

See list of queries executed by a user in Oracle

As an Admin I would like to see the list of queries executed by a particular user? How can I configure DB to keep track of all the queries executed and how can I see them? I am using Oracle 10g.
0
votes
0answers
75 views

Query with large number of or'ed predicates on the same column?

At one place we need to query a table to determine whether any records exists that are in a subset of the same table. The columns that are queried are varchar columns containing file-paths, and we ...
0
votes
0answers
161 views

How does tablespace sizing works in Oracle

Let's say I have an input of 20 gigabytes of raw data (text file) which in turn I would into an external table and would then swap partition in order to place them on my database. The question now is ...
0
votes
0answers
84 views

How to grant privileges for a user to create views on specific tables on Oracle SQL?

I just added: GRANT CREATE VIEW TO user1; But it gives user1 access to ALL the tables, I would like them to only have access to the tables where the field X is user1
0
votes
0answers
122 views

Oracle - How can I improve this query?

We have performance problems with some queries. We always use the rank() function to get the latest entries with a status. The question is, how to speed up things. CREATE TABLE PAYMENT ( CLIENT ...
0
votes
0answers
302 views

Oracle Installation issue on Oracle Linux 6.4

I am trying to install Oracle 11g(11.2.0.1.0) on Oracle Linux 6.4(Remote Server). I get the following error(s) when Database Configuration Assistant is running ORA-01092: ORACLE instance terminated ...
0
votes
0answers
221 views

How to get session parameters changed by the user in Oracle?

Oracle 11.2.0.3 . I need to identify all "alter session" changed for a specific session. There is some v$session_* where I able to get this information? My objective is part of investigation what ...
0
votes
0answers
102 views

Oracle DBMS_MVIEW.REFRESH debugging output?

Is there any way to see what DBMS_MVIEW.REFRESH is actually doing? I want to investigate partition change tracking (PCT) and verify that it is indeed only updating modified partitions.
0
votes
0answers
367 views

migrate APEX to a new database with newer APEX version?

what is the best approach to migrate an APEX app to a newer version of APEX (4.2.3) on a fresh installed database on a new server? is there any straightforward step by step? I never done that before! ...
0
votes
0answers
667 views

FOR loop oracle query with calulation

I have a list of distinct areas, and would like to track statistics for those districts in a SQL statement. I currently have a setup that runs some summary information, but it doesn't include the ...
0
votes
0answers
178 views

After RAM upgrade on 32-bit Oracle server, ORA-04031: unable to allocate x bytes of shared memory

We are in the process of upgrading our Oracle database server at work, from SUSE Linux Enterprise Server 10.4 / Oracle 10g / 4GB RAM (Intel 32-bit) to Scientific Linux 6.4 / Oracle 12c / 8GB RAM ...
0
votes
0answers
944 views

Not able to login in Oracle 11g console using sys/system@SID as sysdba

I am not able to login into Oracle 11g console using administrative account, when I tried it gives me error of wrong username and password. Then I tried from SQL plus, it got logged in without any ...
0
votes
0answers
31 views

Reliability of blobs in MySQL

I'm in the process of migrating an application working with Oracle to MySQL. That application stores data in the form of blobs, which can be pretty big. The Oracle production database is 60 Gb large ...
0
votes
0answers
814 views

Oracle merge query vs correlated update

I have a query which updates a table with data from another table. The current query is written as a correlated update with an exists clause to remove unnecessary rows. The problem is since both of ...
0
votes
0answers
224 views

Oracle prevent CPU usage per process/session

I have an Oracle instance to which several applications from different machines connect (http servers). Normally Oracle CPU usage is ~5-10% even on high server loads. But from time to time, one of ...
0
votes
0answers
75 views

How oracle syncs data across nodes in a cluster

If I have a oracle db server clustered across 2 nodes, it means both nodes have a copy of the whole data, the data is not lying half and half on each node. Now when I make an update using my ...
0
votes
0answers
1k views

Start Oracle 12c enterprise manager in Windows 7

I have installed Oracle 12c in Windows 7. The installation was succesful and the RDBMS and the database that I created are working properly. Then I tried to access to the enterprise manager via web ...
0
votes
0answers
145 views

Efficient, up-to-date way to import an Oracle database into MySql

Here's the situation: I need to automatically merge data from an Oracle and a MySql server into a single, new MySql server. The merging will happen daily, and the resulting server will be hosted on a ...
0
votes
0answers
161 views

Delete backup directories using RMAN

Is there any way RMAN can delete empty backup directories?
0
votes
0answers
291 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
0answers
101 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
0answers
1k views

Oracle 11gR2 DBCA installation failing with TNS Lost contact

I am getting below errors while running DBCA with silent install using response file ORA-12547: TNS:lost contact PRCR-1079 : Failed to start resource ora.ocl.db It's a fresh installation and not ...
0
votes
0answers
363 views

How to clone a database from one environment to a database on another environment?

OS: RHEL DB: Oracle 11g version 11.1.0.7.0 I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
0
votes
0answers
249 views

DBA_SCHEDULER_Job is not giving any result

I have created one procedure that is supposed to trigger on 5th date of every month.for that i have used dba scheduler job.but its not triggering. select job_name,status from dba_scheduler_jobs; ...
0
votes
0answers
368 views

Temporarly disable cache in oracle 11g

I want to disable the caching for my session in oracle 11g to see how long a query takes. Is this possible or is there a better way for meassuring the time a query takes to run?
0
votes
0answers
228 views

Use cases for NoSQL databases: Time series

I need to set up a database that will record temporal series data (sensors). A friend of mine has recommended me to use a NoSQL database instead of using Oracle (for instance). There're also some ...
0
votes
0answers
83 views

file extension of the file types cdump, incident, trace

I need to know the file extension of the file types cdump, incident, trace, alert. Actually I want to create files of the above types manually using mkfile command. There are no existing files of ...
0
votes
0answers
360 views

Error PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records

i've problem here. i wanna create a Stored procedure like below, but i encountered error PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records. create or ...
0
votes
0answers
123 views

How can we hide our procedures in Oracle?

How can we hide our procedures in Oracle? Is there any other way except Wrap utility?
0
votes
0answers
314 views

Oracle Alternative to EXISTS EXCEPT

I wonder if there is an equally elegant solution for Oracle for the problem posted and answered here: Comparing Columns that can contain NULLS - is there a more elegant way? I can't get this ...
0
votes
0answers
382 views

DBA group in Linux

When we need to install Oracle database in Linux then the user should be in dba group. What is this group and why the user should be in this group for installing Oracle database. What happens if the ...
0
votes
0answers
199 views

No network ACL, yet my user can successfully connect to external server

This one's had both me and our dba scratching our heads. We have an Oracle 11.1.0.7.0 instance, DEV, with a user who can successfully connect to our ldap server, e.g.: DECLARE l_session ...
0
votes
0answers
64 views

Troubleshoot abnormal connections

We experienced extreme slowness of login on 6 Mar in 1 of our Oracle servers (Solaris 10) running Oracle DB. During that period of time, our firewall had detected and dropped many TCP connections ...
0
votes
0answers
200 views

TimesTen performance as compared to 10g

I am new here, so please be nice... I have a question regarding TimesTen & Oracle. I have attempted an experiment with both pieces of software, and realize that the query speed on a table is ...
0
votes
0answers
60 views

Database too slow after CHARSET Conversion

I have an Oracle database which runs on version 9.0.1 with WE8859P1 charset and i'm trying to migrate it to the version 9.2i which has the WE8MSWIN1252 charset. The conversion is made without any ...
0
votes
0answers
613 views

How to display Oracle Enterprise Manager 11g (OEM) alerts and reports in Nagios?

I am working on a project that requires an unobtrusive integration of OEM data into a Nagios front-end. I know there are ways to use SNMP traps to do this, but I am not completely familiar with how ...
0
votes
0answers
253 views

implementing DAC and MAC in Oracle

I want an example that might help me implement a dynamics modes of an access mode model. From from page 58 of Secured Database Application Development: Static Access Modes are: use 1 ...
0
votes
0answers
312 views

Understanding the time difference between data grid initial display and export/full display using Toad for Oracle

I am trying to run a query on a local Oracle DB and output the results to a .CSV file. The query runs in a decent amount of time (usually less than 5 minutes), but returns tens of thousands (possibly ...
0
votes
0answers
157 views

Materialized view for a yet-to-be-defined DBlink

In our product we have a main application with an oracle 11g DB and an optional module with another DB. We want the two to communicate through a dblink and I was told to put some code for the ...
0
votes
0answers
1k views

12154 error when using PL/SQL Developer

I have installed a few versions of Oracle on my machine. I have tried 64 bit and 32 bit versions. I have installed 11G. I need Oracle 10G 32 bit. Using the following guide I removed all versions of ...
0
votes
0answers
79 views

SYS_CONTEXT INSTANCE changing on failover?

When using Oracle RAC with either Fast Connection Failover or TAF (Transparent Application Failover), for a given database connection, is SYS_CONTEXT('USERENV', 'INSTANCE') going to change when ...
0
votes
0answers
503 views

How to resolve TNS error in Oracle when using an ODBC DSN

I have come across this error when I was trying to insert data from front end (using JSP) to back end (Oracle 10g): java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12154: ...
0
votes
0answers
51 views

How can I backup Oracle with Listener error

On my server that I have installed Oracle, I encounter a TNS Listener error and i couldn't connect Oracle. Is it possible to backup database with Only my user and password, without listener?
0
votes
0answers
41 views

Oracle User Profile for REST API

What sort of profile would you recommend for an Oracle user that is manifested through a RESTful API; particularly where there will be a lot of asynchronous requests? So we're talking about a ...
0
votes
0answers
2k views

Oracle GoldenGate - adding trandata

ADD TRANDATA <table name> will add the supplemental logging to all columns of table if the table does not have either primary key or a unique key. Once we applied the ADD TRANDATA how do we ...
0
votes
0answers
1k views

Achieve log transfer to standby (Data Guard)

I am not able to transfer my archive logs from primary to standby. I executed the following query: archive log list Database log mode Archive ...