Oracle 11g is the July 11th, 2007 release of Oracle’s primary database product. New features added in 11.0.1 include Virtual Columns, Automatic Memory Management and Interval Partitioning.

learn more… | top users | synonyms

2
votes
1answer
1k views

Insert into table from a query to a linked database hangs

I have a schema with some database links to other schemas that we use to pull data from. We pull the data into a staging table, massage it, and then do some merges into our schema/database. The data ...
1
vote
1answer
59 views

Oracle Ref Partitioning: Deadlock due to child table row migration

My ordering application uses Oracle 11g Database. This DB has a primary table ORDERS and multiple child tables like ORDER_DETAILS, PLAN etc. ORDERS table is LIST partitioned on STATUS column and all ...
0
votes
1answer
8 views

Do I need to create tablepspace and also add all datafiles before import schema using datapump

Do I need to create tablespace and also add all data files before import schema using data pump or impdp add all data files itself first and then unload data into it..?
0
votes
1answer
24 views

How to get a list of stored procedure along with their execution count in oracle 12c?

Hi I am new to Oracle 12c, though I was working on SQL Server for a long time. Is there a way to get a list of stored procedures with their execution count in oracle 12c. We can get it using DMV in ...
0
votes
1answer
64 views

sqlplus not connecting to Oracle XE 11g

I installed Oracle XE 11g on my Ubuntu in vmware fusion. The oracle installation is all went fine but I am not able to connect the oracle database using sqlplus. I am getting this exception: $ ...
0
votes
1answer
77 views

What is contained in the controlfile of oracle database?

As we all know that controlfile contains datafile locations and redo log locations along with their names.It also contains dbname,timestamp,checkpoint info,log sequence number,rman backup info.In ...
0
votes
1answer
42 views

Partitioning on a computed column

Using - Oracle 11g I have created a table say X. of this table, a column say C3 is a computed column which will have a value based on incoming values for the other 2 columns say C1 and C2. I am using ...
0
votes
1answer
31 views

Use Oracle on Web App (New Question)

Our database project is about creating a web application where the user can add or edit information. My concern is How do I connect Oracle 11g with my PHP? Note: Our teacher did not teach us about ...
0
votes
1answer
73 views

How do I create an Oracle 11g user with read access to all tables/schemas?

I need to create a user that has read access to all the schemas. Do they just need Select priviliges or is there more that needs to be done?
0
votes
1answer
159 views

Is there are a way to restore System schema to it's original state?

I've installed Oracle 11g Database Enterprise Edition and my task was to import schemas. I'm totally new so I ran command: imp system/password file=path.dmp full=y And import everything (10 dumps, ...
0
votes
1answer
143 views

Keeping messages in a backup table after dequeue is completed

I would like to transfer the enqueued messages to a backup table after they have been dequeued. Currently we are using DBMS_AQ.DEQUEUE with mode dequeue_mode := DBMS_AQ.REMOVE. So after the message ...
0
votes
1answer
52 views

Oracle dataguard - Redo apply

In a low bandwidth environment when a transaction commits that generates a large amount of redo data will cause other independent transactions to slow down. This is because the redo data of small ...
0
votes
1answer
92 views

Combining data of multiple rows in view

I have a table that holds timetracking data of users and looks somewhat like this: projectid activityid worklocationid year week day hours 1 22 21 2014 37 ...
2
votes
0answers
471 views

Oracle 11g bug ? not returning the record until I triggered index to invisible and then to visible

We are using Oracle 11g, 11.2.0.3. We know a record exists in a table but a select is not returning it for some odd reason. The execution plans the general query, not forcing any index, shows that ...
2
votes
0answers
488 views

oracle streams apply: how to get a reason why LCR message was not applied

I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't. ...
2
votes
0answers
2k views

Oracle 11g displaying ORA-01034, ORA-27101, and Linux “error 2” messages.

When I try to connect to Oracle 11g using: sqlplus noah/noah@orcl I get these errors: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or ...
1
vote
0answers
8 views

Oracle Application Server Integration With APEX

This might not be directly related to DBA, if so kindly advise. I need to integrated some reports created via Oracle Reports Builder with APEX. Reports are in RDF format. Which version of Oracle ...
1
vote
0answers
13 views

Script to find unused indexes over a period of time doesn't work in Oracle 11g

The statspack_unused_indexes.sql script described in this page would be incredibly useful to me, but it has been coded for an earlier version of Oracle. When I try to run it on 11g, I get the ...
1
vote
0answers
39 views

Oracle tuning strategy for columns with long tails

We have an Oracle 11g database, where the two biggest tables are Customer and Order. The order profile of our customers has a long tail: we have millions of customers, with most only having a small ...
1
vote
0answers
122 views

Oracle listener configuration

I have oracle 11.2.0 installed on linux. And I have arcgis server 10.2 on the same machine. I created an geodatabase. But when i try the sde functions like sde.st_asText i got: -ORA-28575: unable to ...
1
vote
0answers
92 views

Oracle 11g SSIS SQL Server 2014 Truncation

We have a nightly SSIS job which downloads data from a Vendor's ORACLE system into our SQL Server 2014 system using ORACLE's Wallet. On some tables, we've noticed that some VarChar columns have last ...
1
vote
0answers
85 views

Sync/Replication of 2 Oracle Databases with NetApp storage

I am working on a high availability setup of Oracle Enterprise Manager. I need the back-end repository replicated (preferably in real time, or something close) to another repository, in which I could ...
1
vote
0answers
186 views

Port no in Oracle Forms 11G

Which port number to be used in forms 11G Preference-->Runtime--> Application ServerURL Section? I have: 1521-Given at the time of database creation 7003 and 7004-Given at the time of WLS Domain ...
1
vote
0answers
213 views

Oracle ASM failover strategies

I inherited a production system with the following setup: Disk A, Failgroup AB Disk B, Failgroup AB Disk C, Failgroup CD Disk D, Failgroup CD Diskgroups AB and CD are configured with normal ...
0
votes
0answers
32 views

column values combination

I have chains of nodes like A -> B -> C -> F D -> E and store them in an Oracle table pair with 2 columns left_node and right_node left_node right_node A B B C ...
0
votes
0answers
17 views

Recover Oracle database with damaged system datafile

I'm working with Oracle version 11. My system01.dbf is corrupted and there is no backup. The database was in archive log mode and logs exists. Is there any way to recover data and import to a new ...
0
votes
0answers
23 views

Case statement in a where clause in Oracle

I am writing a report for a customer using SQL. The end result of this report is to show a group of people with an expired certification or expiring certification. The report has a ...
0
votes
0answers
9 views

ALTER SESSION from a Control File

I am using a Control File to import data from a CSV file into a table, using sqlldr to import the data, where a large number of fields are numeric values with integer and decimal part separated by ...
0
votes
0answers
27 views

Connecting to oracle 11g through maestro gives initialization error

I'm very new to oracle DB. When trying to connect to oracle through maestro, this error comes up: Initialization error SQL*Net not properly installed OracleHomeKey OracleHomeDir Dont have any ...
0
votes
0answers
24 views

SQL Server Replication: Central Subscriber : Loading data in the same table

I have configured a Transactional Replication from Oracle (11g) to SQL Server 2014. I have many clients with the same database and we want to have a Multi-Publisher and only one Subscriber. The ...
0
votes
0answers
121 views

Use of temporary table variable inside a stored procedure

I am new to oracle, I was trying to create a procedure which consist of temporary table inside. I have tried this code below and getting an error in the declaration of temporary variable. DECLARE ...
0
votes
0answers
48 views

connecting to database on ec2 Virtual Machine from sql developer

I am using Oracle SQL Developer 4 to connect to databases . We are running an Oracle 11g on Amazon EC2 Virtual Machine (not RDS) and I can’t connect remotely. inside the Virtual Machine as local ...
0
votes
0answers
30 views

SQL Server to Oracle migration

Converted model resulted into incomplete script generation as all stored procedures, triggers and views were missing, only table structures were generated and i did not get any error messages for it. ...
0
votes
0answers
101 views

Portable Method of Deploying Oracle Express on Windows (Ideally without Installer)

I'm looking for a portable way of deploying Oracle Express alongside a C# application on a continuous integration machine running CruiseControl. Ideally I would not have to use the installer - this ...
0
votes
0answers
30 views

How to identify which oracle 11g process using more memory

Oracle 11g 32bit Window server 2008 I have installed oracle 11g on window server2008. Total Memory Size =2504 Maximum Memory Size=2600 Normally it is using memory nearly 1750Mb, but from last month ...
0
votes
0answers
24 views

How do I setup description_list properly without having invalid username error

I'm running Toad 12.6.0.53 and I'm working on two databases which contain the same setup - but are not clones as the schemanames vary between the two databases. As in 99% of the time it is NOT ...
0
votes
0answers
49 views

How to store values from a loop and compare them?

I have to select child items from a parent item and then compare text of each child and if the text is same I should not be displaying the heading. I have written a procedure for this, which is like ...
0
votes
0answers
177 views

Update error: cannot modify a column which maps to a non key-preserved table

I am having a problem in Oracle update statement. UPDATE ( SELECT cc.string21, c.boolean5, cc.string22, cc.string23, cc.string24, cc.string25 FROM ...
0
votes
0answers
225 views

Please anybody help me with oracle db importing?

I try to import .DMP file with impd comand. root@HP:~# impdp SYSTEM/xxxxxxxxx log=4.log file=as.DMP and i get this ;;; Import: Release 11.2.0.2.0 - Production on Thu Oct 2 12:21:14 2014 ...
0
votes
0answers
243 views

DBMS_CRYPTO - ORA-06521 PL/SQL: Error mapping function

PACKAGE: user/password -- SYSTEM/SYSTEM CREATE OR REPLACE PACKAGE enc_dec AS FUNCTION encrypt (p_plainText VARCHAR2) RETURN RAW DETERMINISTIC; FUNCTION decrypt (p_encryptedText RAW) RETURN ...
0
votes
0answers
280 views

merge in cursor is slow ,any alternative for that in oracle 11g

we have a requirement like below. we need to update one table A from another table B based on joining criteria. both tables are having porper joining columns. Table A has 2 columns missing_order_cw ...
0
votes
0answers
264 views

How to put more than 1000 values into an Oracle

I have a comma delimited list of many IDs(Database size is very huge here). Sometimes this list can exceed 1000 items, at which point Oracle throws an error. The query is similar to this... select * ...
0
votes
0answers
76 views

Is it possible to copy mounted database without RMAN?

I need to make a copy of production database for development. For some reason I can't use RMAN. My question is: can I copy standby database while its in mounted state and recovery is canceled? Of ...
0
votes
0answers
87 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 ...
0
votes
0answers
775 views

Oracle EXP Error ORA-12704: character set mismatch

I need to duplicate a Oracle 11g Express Edition database from one computer to another computer. I tried exp sys/password FULL=Y FILE=backup.dump (the idea is to do a imp on the other pc) But it ...
0
votes
0answers
429 views

Alternatives for UPDATE statement Oracle 11g

I'm currently using Oracle 11g and let's say I have a table with the following columns (more or less) Table1 ID varchar(64) Status int(1) Transaction_date date tons of other columns And this ...
0
votes
0answers
1k views

How to concatenate multi row sql output

Version Information: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production HP Server Automation v9.14 I am creating a report of all my HP-SA managed servers. The report includes data from ...
0
votes
0answers
51 views

Any recommendation on tuning following query

My query has lot of select statements and unions. I think it is querying database multiple times and combining data. Is there a way we can eliminate multiple passes to the database? I would like to ...
0
votes
0answers
284 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
249 views

Renaming the system generated partitions during interval partitioning

I am trying to rename the system-generated partition names (generated during interval partitioning). I try to do this while my table is live(data read and write is happening). I need two scripts. I ...