The second and terminal release of Oracle Corporations Oracle 11g database product. 11.2 was released for Linux on September 1st, 2009. New features added include RAC One Node, Improved data compression ratios (up to 20x), Edition Based Redefinition, Recursive Subquery Factoring, Instance Caging, ...

learn more… | top users | synonyms

0
votes
1answer
195 views

Oracle 11g install problem on Ubuntu

I ran the runInstaller script in the root dir of the extracted zip files. After some pages of the graphical installer it sent me to run /tmp/CVU_11.2.0.1.0_macbook/runfixup.sh as root. It gave me ...
0
votes
0answers
52 views

Save a dynamic cursor for reuse?

I have a search page where users can select from multiple variables. When the page is submitted to a package in the database a cursor is constructed and opened. a snippet to show what I mean ...
0
votes
1answer
41 views

how to download oracle database to a remote server

I am trying to install Oracle 11g on my client's server. In order to download it to the server, I have followed this : Logged in to www.oracle.com with my client's username/pass from my desktop. ...
2
votes
2answers
3k views

when to use embedded PL/SQL gateway with Oracle APEX?

Oracle Application Express (APEX) requires one of the following three options for an HTTP server: (1) Oracle HTTP Server (with mod_plsql), (2) Oracle Application Express Listener, or (3) an embedded ...
0
votes
1answer
97 views

Oracle Character set identification

In the given export(Normal Export) log file i see following: Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set Is this multi-byte or single byte database char-set. Can you ...
0
votes
0answers
88 views

My queries are slow under load

I am performing a load test for my application. All my SQL queries which are fired from my application, individually look better and perform fast. The same SQL are becoming bottleneck when they are ...
0
votes
0answers
116 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
1answer
122 views

Can I use RMAN to backup and restore data in a certain point in time?

I have an Oracle database over which I have full control. What I am doing is performing load testing on our application, which uses Oracle as a database. To do this, I initially set the database up ...
3
votes
0answers
162 views

Should I group by and then join, or join and then group by?

(oracle's optimizer does the same thing for both approaches when just two tables are involved, thus my question involves three tables) Assume three tables t1, t2 and t3 with a pairwise 1:n ...
0
votes
0answers
50 views

Managing user priviliges on schema objects

In our database, most of the users have a role X, and role X grants select any table. I want to maintain this privilage for most of the tables, but I do not want some users access some tables in the ...
0
votes
1answer
40 views

object oriented database

I am new to object oriented databases. What is the error in this database schema? It gives error after insertion query and not before that insert into student_table values ( student_detail ...
0
votes
0answers
95 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
25 views

Simultaneous table read in single query in Oracle

Is it possible to set Oracle to read tables simultaneously and don't wait until the first table scan is finished? Example: I'm joining a remote table to a local table. Oracle is reading the remote ...
0
votes
0answers
66 views

ORACLE_HOME is not available

I install Oracle 11GR2 on Cenots 5.9 . i edited bash_profile to correct values for ORACLE_HOME and ORACLE_BASE and etc . But when i want to run SqlPlus , " command not found " is shown . but when i ...
0
votes
1answer
342 views

Install Oracle 11gR2 driver for Node.js 0.10.20

I want to connect Oracle 11gR2 and Node.js 0.10.20. I use this package but I don't understand this part of installation process. Can you explain it to me? # Replace /opt/instantclient_11_2/ with ...
1
vote
1answer
110 views

Altering the location of Oracle-Suggested Backup

On one database, the Oracle-Suggested Backup scheduled from Enterprise Manager always ends up in the recovery area, despite RMAN configuration showing that device type disk format points elsewhere. ...
0
votes
2answers
1k views

Problem compiling view when it is referencing a table in an other view: insufficient privileges

Oracle 11g R2 Logged on: SYS / AS SYSDBA When I try to compile or create a view that is referencing local schema tables. It works fine. Problem does occur when I try to compile the same view ...
0
votes
1answer
681 views

Installing Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) name

Installing 11gR2 on Oracle Linux 6.4. System is a desktop used by one developer. It's on DHCP. Hostname is similar to ip-t3400-1547.mydomain.local Please note I have no issues installing this ...
2
votes
3answers
312 views

How does a database use the SYS schema even when we change the password?

From the thread What is the difference between sys and system accounts in Oracle databases?, I understand that sys schema is supposed to be used only by the database. But still an administrator can ...
1
vote
0answers
60 views

Import from incremental backups to a new host in Oracle 11g

I am using Oracle 11g. I would like to know that whether it is possible to import from incremental level 0 & 1 backups to a new host using RMAN. If yes, how can I do that? For level 1 I am using ...
2
votes
1answer
2k views

RMAN & Archivelog Deletion Policy confusion

Never been able to fully grasp the notion of delete input/delete input all when backup up Archivelog with rman. Tied to the same issue is the configure Archivelog deletion policy to backed up X times ...
1
vote
1answer
97 views

Migrating a tablespace to a different database on the same ASM

How might one go about copying or moving tablespaces between databases that uses the same ASM instances? Might it be possible to cut some corners in RMAN or have ASM remap files belonging to a ...
-3
votes
1answer
74 views

I am trying to import a file but it gives me exception : ORA-20001: Invalid Operation. while calling a stored procedure, how can i solve this [closed]

I am trying to import a file , but while calling the procedure i get an exception ORA-20001: Invalid Operation. Stored Procedure: begin -- Call the procedure imp_pkg.isinmstimp(cpath => ...
0
votes
0answers
31 views

Is DBCA in Oracle for a single database or the entire system?

I ask this because I was going to create a simple phone list database for learning. But when I used dbca, I was asked did I want to install the sample databases, HR, etc. It also had the default ...
2
votes
2answers
161 views

Does RMAN in Oracle only copy the archive logs? What happens to the active redo log in case of failure?

If RMAN copy copies the archived redo logs when they are full, what happens to the current redo log in the event of a failure (hardware failure, etc.)? Isn't there always an active redo log that is ...
0
votes
1answer
87 views

imp paused mid import

OK, I'm new to Oracle administration but I'm trying to import a previous dump (no pun intended) which was split into two files. The import is happening from an Oracle 9i to 11gR2 on Windows I used ...
0
votes
1answer
107 views

Trigger and temp table or materialized view

I'm looking for the better/best solution to compare data in a table before update and after. This can be done with trigger and temp/global temp table or with read only m-view as far as I know. Would ...
0
votes
2answers
1k views

Environment Varible PATH exceeding recommended length solution?

I am attempting to install Oracle Database 11g on a Windows 7 64x laptop. I get all the way to step 5 of 8 and I get a fail on Environment variable path "exceeds recommended length"... I have ...
1
vote
1answer
61 views

recover oracle db from datafile

We have oracle db which unfortunately we did'n make backup and all control files and other files except all data-files are damaged. Is there any solution to recover db from all of these intact ...
1
vote
1answer
235 views

USER_ID field in alert logs (also in V$DIAG_ALERT_EXT view)

Does anyone know what triggers the USER_ID field in the log.xml to be populated? The value also exists in the V$DIAG_ALERT_EXT view. I've found by observing the logs that if a temp tablespace fills ...
2
votes
1answer
88 views

Backing up Oracle home directory while instances are running

Can I take a backup of Oracle home directory (with cp -r) before upgrade while the instances using the home are running or is it required to shutdown instances first? Trace files/alert logs are in ...
4
votes
4answers
10k views

Execute a script with SQLPlus containing blanks, semi-colons, and forward slashes

Occasionally I will get a script that will run fine in SQL Developer or Toad, but requires modification in order to be run successfully from SQL*Plus. Here is a worst case example containing multiple ...
3
votes
1answer
2k views

How to find the schema name of a data pump dmp file?

I have been given a DMP data pump export file to import into my local Oracle instance. I've tried running this command line: impdp full=Y directory=DATA_PUMP_DIR dumpfile=MyDumpFile.dmp ...
22
votes
3answers
20k views

What is the difference between sys and system accounts in Oracle databases?

There are two ways to connect to Oracle as a administrator using sqlplus: sqlplus sys as sysdba sqlplus system/manager These accounts should be uses for different purposes, I suppose. Which tasks ...
2
votes
2answers
269 views

How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?

In our data feeds, we have a stack of XML files as well as numerous flat files to put into an Oracle11g database. We flatten the XML into delimited files, and load the whole set using SQLLoader. I ...
0
votes
2answers
157 views

Example optimisic offline lock in SQL/PL?

Can someone show me an example of an optimistic offline lock in an Oracle Stored Procedure?
0
votes
1answer
164 views

SQL output formatting

I want this: "ACCOUNT_ID","MAJOR_VERSION","MINOR_VERSION","COUNTRY","ACCEPTANCE_TIMESTAMP","AGREEMENT_ID" "abcdefgh-1234-5678-ijkl-mnopqrstuvwx","20110901","1","CN","1329574013737","tos" But I get ...
0
votes
1answer
47 views

Is it possible to dynamically retrieve the number of columns in a view in Oracle?

As the title says, is it possible to retrieve the number of columns in a view dynamically? I'm learning Oracle 11gR2 and I'm checking out the V$ views. One of the things I want to do is output them ...
2
votes
1answer
595 views

Cannot change serivce name for Oracle

I'm trying to change the service name of an Oracle 11.2.0.3 installation on a Windows 2003 server. During installation the service name was defined with the default domain, but we'd like to get rid ...
5
votes
1answer
75 views

Why are some aggregates treated differently in the RHS of a rule in the model clause?

With my limited understanding of the model clause, I'd expected the following three queries to return the same results because there are no nulls in the data, and the functions are equivalent: select ...
1
vote
0answers
74 views

Oracle specifying join order hint

Oracle 2 node RAC 11G R2 I have a query (this is a simplified version, but still exhibits the same issue as the larger query) that looks like this: SELECT t1.trip_id, t1.origin, ...
2
votes
4answers
242 views

Oracle hint failure

When I run the PL/SQL block after the CREATE statement, I receive the duplicate key error I would expect if I did not add the hint. Any ideas to why the hint does not work? CREATE TABLE Sandbox.Clue ...
0
votes
1answer
415 views

Register XML schema using dbms_xmlschema in Oracle

The requirement is to register XML schema from XSD files in Oracle 11gR2. I am using the following code: DECLARE BEGIN DBMS_XMLSCHEMA.registerSchema( SCHEMAURL => ...
0
votes
2answers
150 views

CASE Statement - 1st case is being ignored

I have a table (usr_t_user_reg) in which I register all the users of the database. Now I want to create a view (usr_v_user_not_reg) which shows me all the users that I haven't registered yet or users ...
0
votes
1answer
189 views

Oracle 11gr2 instant client installation

I have an application that uses Oracle 11gr2. For the Oracle client installation, I first install InstantClient and then run the setup again, choose Custom, and choose "Oracle Database Utilities" ...
1
vote
0answers
1k views

Failure Of Backup Due To Limit Exceeded For Recovery Files Since Cannot Reclaim Disk Space [RMAN-03009,ORA-19809,ORA-19804]

While I try to take incremental backup level 0 by using the command RMAN> backup incremental level 0 database plus archivelog; , encountered this error. RMAN-00571: ...
0
votes
2answers
547 views

Update year alone in date (Oracle 11g)

When I checked one of my client's database, I found some mistakes which will make problems. The problem is that the date is showing as 01-01-01 when I try to display it in the dd-MM-yyyy format the ...
0
votes
1answer
1k views

Unable to connect to Amazon RDS instance [closed]

I recently created an oracle instance on Amazon RDS. Unfortunately, I'm not able to connect to the instance using Oracle SQL Developer. The (relevant) information I have from Amazon; Endpoint - The ...
1
vote
1answer
48 views

Redundant transpose. Case is not enough to solve my problem

I have db problem in transposing rows to columns. I am half way through the result but getting redundant data. My table: EMP_ID EMP_NAME SAL_PAID 01 ABC JAN 01 ABC FEB 01 ...
2
votes
1answer
1k views

SP2-0750: You may need to set ORACLE_HOME

I am getting following error message when i write sqlplus on command prompt SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory Here are the path details