All versions of Oracle. Also add a version-specific tag like oracle-11g-r2 if that context is important in the question.

learn more… | top users | synonyms

2
votes
2answers
1k views

Oracle 10g XE GUI

I've designed a database on Oracle 10g xe (Windows Platform) and I want to export the tables I created in a sql file. I've googled all night and didn't find anything. I also tried to install a Windows ...
5
votes
1answer
2k views

Oracle 10g express database link to Oracle 8i

I upgraded a 9i install to 11g with only one problem. Database links between 11g and our legacy 8i database are no longer supported. I have to transfer data from 11g to 8i two or three times a day ...
10
votes
1answer
13k views

Limit the degree of parallelism (DOP) available to any query

On Oracle Exadata (11gR2), we have a relatively beefy database. cpu_count is 24 parallel_server_instances is 2 parallel_threads_per_cpu is 2 We noted, through observation in Oracle Enterprise ...
4
votes
1answer
6k views

Good video tutorials/series for learning Oracle? [closed]

I am a better learner with visual content. Therefore I actively seek video tutorials when I start learning a subject. For oracle below links are my finds. I would like some additions to these. ...
5
votes
2answers
1k views

Find out if two rows came from same transaction in Oracle

I am using Oracle 11.1 and would like to figure out if two rows in one table where inserted by the same transaction. Is there an easy sql statement to map a row to an transactions id? The table is an ...
2
votes
1answer
70 views

Oracle 10g Administration

Redo log files are not multiplexed in our database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer ...
12
votes
3answers
16k views

Script out Oracle DDL in an automated fashion

Oracle SQL Developer is able to export DDL through Tools -> Database Export... This works very well, but requires manual intervention. I know of DBMS_METADATA.get_ddl(), but have found that the ...
1
vote
1answer
1k views

ORA-00449: background process 'MMAN' unexpectedly terminated with error 7446

One of our Oracle servers went down rather badly last night, and we have been unable to bring it online since. Attempting to startup each instance results in: SQL> Connected to an idle instance. ...
2
votes
2answers
6k views

WITH using INDEX hint in Oracle

I have a fairly complicated query. I have written two different query to accomplish my goal. First one is using WITH, other one is using global temporary tables. First One: WITH A ( KNO .. ) , ...
2
votes
1answer
6k views

What operating systems are certified for Oracle 11gr2 RAC?

How can this information be found?
2
votes
1answer
1k views

Which packages are required to install Oracle 11.2.0.3 on Solaris 11?

Where can I find information on which packages are required to install Oracle 11.2.0.3 on Solaris 11? The documentation only mentions Solaris 10. I tracked down the packages required for Solaris 10, ...
2
votes
2answers
12k views

How can I list all user-owned functions?

Is there a way to quickly list all the current user-owned functions in Oracle? Something along the same lines as this, which lists the current user's tables select * from user_tables;
4
votes
2answers
5k views

Where to start learning to become a successful Oracle DBA [duplicate]

I am IT Graduate with good knowledge on SQL and C. I have done most of the SQL programming on Microsoft SQL Server in my academics. But i want to become Oracle DBA. Could you please suggest me a ...
5
votes
1answer
3k views

Calculate months between two dates

For a University course I've been given the following task Suppose that we have an employee table like (first_name, last_name, salary, hire_date, ...). There is regulation which states that every ...
4
votes
2answers
4k views

Oracle Enterprise Manager read-only access for non-administrative users

Can access to OEM be restricted to the point where you can allow a non-admin user access to it but they can't modify any objects but can still view performance data, alerts, sessions, etc? I am a ...
3
votes
1answer
9k views

SQL*Loader-605: Non-data dependent ORACLE error occurred

As I try to load data into Oracle, I've encountered SQL*Loader-605: Non-data dependent ORACLE error occurred error. Data is (are?) in .txt file and its size is 95GB. Here are some more details ...
0
votes
1answer
73 views

How to select rate for all selected modules and all selected years no matter they got rate for that year or not

How to write a SQL to achieve the "goal" section? Select rate for all selected modules and selected years no matter they got rate for that year or not. The years and modules will be input by users, ...
1
vote
1answer
2k views

Creating an index in a temporary tablespace

I am trying to create an index for a relatively large table (80M rows). First I got an ORA-01652 error, then I searched in SO and found a related question. However, trying to implement the steps ...
2
votes
2answers
3k views

“ORA-00942: table or view does not exist” when deleting from a very real table in the user's schema

I have a table that definitely exists in the logged-in user's schema (therefore I own the table) and is not a view/synonym/anything wacky. I can select from it, but when I try and either insert, ...
2
votes
1answer
16k views

Oracle 11g Listener not working

The listener on my Oracle 11g instance is no longer working. I tried to start it but that doesn't work. There are no Linux processes for the listener: > lsnrctl start LSNRCTL for Linux: Version ...
1
vote
2answers
932 views

Oracle Linked Server query error

We have a problem with a query from a SQL Server 2008R2 - 64bit to an Oracle Linked Server. We use the Oracle 64-bit driver for Windows. When we query a certain table we get the following error: ...
5
votes
1answer
1k views

What is Sql Server Clustered Index in Oracle terminology

A clustered index in sql server like a dictionary or telephone directory. A,B,C,D it goes on. If you look up with a name Ozgur you start O then z etc. I would like a simple explaination for this ...
2
votes
3answers
742 views

RAM Impact on Oracle database operations

We are seeing drastic change in the amount of time taken for db operations depending on ram size. The same content when inserted into a db running on a 4gb ram machine takes about 600% more than into ...
1
vote
1answer
81 views

RAM Impact on database operations [duplicate]

Possible Duplicate: RAM Impact on Oracle database operations We are seeing drastic change in the amount of time taken for db operations depending on ram size. The same content when inserted ...
0
votes
1answer
611 views

Oracle: Extract Graphical Database Representation [duplicate]

Possible Duplicate: Oracle Creating ER Diagrams and Data Dictionaries How can I extract a graphical (schema) representation of an Oracle database (tables and their relationships; with colums ...
3
votes
1answer
529 views

Oracle Materialized View

I need your help with a issue on Oracle Materialized View. I created the Materialized View using the following command: CREATE MATERIALIZED VIEW SNAP_TEST TABLESPACE tbs NOCACHE LOGGING NOPARALLEL ...
16
votes
2answers
91k views

Oracle: Quick way to list all database links

The title says it all, is there a way to quickly list all the current database links in oracle? Something along the same lines as this, which lists the current user's tables: select * from ...
1
vote
2answers
4k views

Confused about the Oracle CONTROL_FILES initialization parameter

This is the explanation of this parameter from Oracle. This is the description of the description in the explanation. From the documentation we know that this parameter is not modifiable (Modifiable: ...
3
votes
2answers
278 views

Recovering from Oracle host OS disk failure (options)?

If an Oracle host OS has a complete disk failure and the host can be restored (assuming from a recent clone of the host OS disks) from backup, is it possible to then point the host to the existing ...
7
votes
2answers
3k views

Is DB2 more reliable and stable compared to PostgreSQL or MySQL?

Always i was using MySQL or PostgreSQL for my projects such as Web/Desktop apps. I had data loss few times and thanks to old backup i was always up and running. But for a recent project for Airport, ...
12
votes
1answer
10k views

What are the benefits of packages over standalone procedures and functions?

Looking for a canonical answer to the question of why packages should be preferred in an Oracle database over stand alone procedures and functions.
4
votes
2answers
30k views

Determine Oracle session client character set?

I know how the database characterset (NLS_CHARACTERSET in select * from v$nls_parameters;) and the client character set (the client environment setting NLS_LANG) interact. What I can't find out ...
1
vote
2answers
659 views

Converting an SVN repository to SQL database

I have downloaded the svn repository of Atunes using TortoiseSVN. I would like to transfer the logs of activity of the developers to a SQL database, preferably an Oracle one. Is there any software ...
1
vote
1answer
686 views

ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal

I have had invalid public synonyms in my database. Some of them references to ordinary schema objects and others to sys schema objects. I compiled all these public synonyms by the following command: ...
2
votes
2answers
189 views

State of the art self healing and self protection in DBMS

At the moment I'm writing a paper and I need some input about the state of the art of self healing and self protection in DBMSs. Does somebody read some interesting articles or books about this topics ...
3
votes
1answer
874 views

In a two-server dataguard setup, can I store the recovery catalog in the same database?

We currently have an Oracle 11gR2 database that is backed up with rman, with the rman records stored in the control files. Control file auto-backup is turned on. Backups are to disk (and, ultimately, ...
1
vote
1answer
511 views

schema shows through standard client connection but not through ODBC connection?

Hoping you can help! The Gist When I log into an Oracle 11g DB using SQL Developer or DBVisualizer, I can see schemas and execute queries against them. However, when I use the same credentials to ...
2
votes
2answers
12k views

How to monitor backup jobs on Oracle 11g?

Background: I'm trying to monitor that backups run as expected on several databases. Zenoss is used to monitor most other stuff. A couple of KPIs are already monitored using Zenoss in combination ...
1
vote
0answers
3k views

Convert the Highvalue of user_partition in varchar2

I have a requirement where I would like to use the HIGH_VALUE field of user_partition table as a Varchar2 or TimeStamp value and I would like to get it used as a Function in SQL Query. Something like ...
1
vote
1answer
2k views

Oracle XE 11.2 Export / Import Charset

I created a database in oracle XE 11.2 that uses charset AL32UTF8 that I now want to export. When I perform the export, the resulting data appears in WE8MSWIN1252 character set and AL16UTF16 NCHAR ...
1
vote
2answers
9k views

work with json in oracle

Is there an easy way to work with JSON within Oracle? I have a stored procedure that I use to call web services quite often, JSON is a format that I am familiar with in web development context, but ...
1
vote
1answer
144 views

Use of '@' '.' and 'public operator/keywords in Oracle database?

I got into a weird SQL query-patch which looks for @ . and public keywords. I was wondering what is the purpose of these operators/keywords? I suspect that it might be looking for SQL injection or ...
4
votes
2answers
6k views

RMAN-06054: media recovery requesting unknown archived log, Where is SCN kept?

I have the following situation: Backups of DB1(located on srv1 server) database are taken everyday at 1:00 AM. I took backed up files(datafile,archivelog,controlfile,spfile) of 24/10/2011 and ...
5
votes
2answers
7k views

Oracle RAC failover not working correctly

I have Oracle 11gR2 set up on a RAC environment with two nodes. I have SCAN set up, eg: I have two entries on the DNS set up so I can ping the SCAN name and reach either node. I can also ping both -...
0
votes
1answer
300 views

How to find equivalent of Oracle's privileges in SQL Server?

I have a user in Oracle for which the permissions given are CONNECT and SELECT_CATALOG_ROLE. How do you find the equivalents when setting up a similar user in SQL Server?
2
votes
1answer
7k views

Oracle Wallet Setup ORA-12578

I am having trouble setting up the Oracle Wallet on a new box connecting to a new database. I have added the following lines to my SQLNET.ORA: SQLNET.WALLET_OVERRIDE = TRUE WALLET_LOCATION = (SOURCE=...
1
vote
1answer
3k views

function based index as a conditional unique key?

I have a search table which has a generated primary key PK_ID,and also has primary keys from three or four other tables in the FK_ID column CREATE TABLE METADATA ( PK_ID NUMBER(10) ...
1
vote
1answer
415 views

How to implement a low resource privileged user on Oracle 10g using Resource Manager?

In my database I have users and their respective grants using the least amount of privileges principle. How do I start taking advantage of resource manager to prevent users from hogging all the ...
14
votes
8answers
20k 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 ...
2
votes
1answer
442 views

Oracle Change Data Capture: Unsubscribed column results in change set record

I am using Oracle 11g's Change Data Capture to track changes on a database table. I am using synchronous mode to minimize latency. Here's an example to illustrate my problem: Published_Table ...