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

1
vote
1answer
24 views

What to do when archive logs are lost/corrupted that are not backed up

All recently generated archive logs were corrupted but datafiles are fine.What if recently generated archives corrupted and the archives backup is not available, so what would be the strategy to ...
1
vote
1answer
35 views

Is there a way to get disc space remaining using an SQL query on an Oracle database?

We experienced a problem recently where the disc space ran low and some queries started giving unpredictable results. The root cause was that we'd take too many restore points and filled up the disc. ...
1
vote
1answer
21 views

How do I include zeros in a count(column)?

I am attempting to build a report for a client. I need a display of all the values in Tab1, Col1 (a validation table), a count of each time that occurred, and a percentage of the total. Here's what ...
0
votes
1answer
25 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
32 views

error:ORA-01008: not all variables bound

I created a bus table and when i try to insert values in the table like: insert into bus values(&bus_no,&source, etc.,); I get an error: ORA-01008 not all variables bound
0
votes
1answer
18 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
0answers
7 views

Problem in ASM starting please help [duplicate]

Hi as iam working on windows 7 plateform with oracle 11.2.0 i have created the parameter file for ASM but when iam giving the startup it is giving me error as ORA- 01078 failure in processing the ...
0
votes
1answer
12 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
0answers
19 views

Recurse path from leaf to root? [duplicate]

I have a table structure (in an Oracle 11g database [11.2.0.3.0]) that maps out a folder hierarchy for employee records that looks like this (note: I have to start at the leaf node and recurse up to ...
0
votes
1answer
58 views

Using output value of column from function for another column in SQL*Loader

I have asked the same question on StackOveflow. Do not know, if this site is linked to that or not and thus whether that question will be seen by professionals here, so I am adding it here. Please ...
0
votes
1answer
34 views

Update does not working while select returns right results

I am trying to execute the query below: UPDATE( SELECT Ord.Completed FROM Product P INNER JOIN Order1 Ord ON Ord.OrderID = P.OrderID WHERE EXISTS( SELECT * FROM Delivery ...
0
votes
1answer
85 views

Oracle Package in Data Dictionary that can't be dropped

I've encountered a very interesting problem that I can't figure out how to fix. I have a package that I wanted to create on my database with a wrapped body. I mistakenly omitted the word "BODY" from ...
0
votes
1answer
45 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, ...
1
vote
1answer
48 views

What is {Oracle}… {Oracle Off}?

I inherited an old script, that should, as part of a pl/sql routine, create a temporary index for me. I tried it on Oracle 11.2.0.4.0, but it does not accept the options. CREATE INDEX x ON y(gid) {IN ...
0
votes
1answer
57 views

Problem creating Oracle database manually

I am using Windows 7 and Oracle 11. When I want to create a database manually, it is giving me two problems: I set my oracle_home to c:\app\best\product\11.2.0\dbhome_1. Under home I have a ...
1
vote
0answers
50 views

How to Avoid Mutating Error in Oracle

I am using Oracle 11g. I have a this trigger: create or replace TRIGGER TRG_UPD_RAPRJCT11 AFTER UPDATE OF CURRENT_STATUS ON AGL_RAPROJECT FOR EACH ROW BEGIN IF (:OLD.CURRENT_STATUS='Review2' and ...
-2
votes
2answers
25 views

creating tablespace failed!

I've restored a db and its failed with many errors. When I look into the log file, I found that the tablespace does not exist. So when I try to create a tablespace in plsql am getting the following ...
0
votes
0answers
13 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
41 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 ...
1
vote
1answer
29 views

Rollback in Oracle

I am having a problem in Oracle rollback. In my stored procedure I have multiple insert and update statements. If every thing is fine I am sending success message and also I am tracing success status ...
0
votes
2answers
81 views

Oracle connection suddenly refused on windows 8

I am having all kinds of connection issues with sql developer all of a sudden. It was working till yesterday and stopped working on windows 8 machine. i am still able to connect via command prompt. ...
0
votes
1answer
39 views

Create a new table oracle

Hello I recently changed companies and the databases as well. Having worked with postgres so far, oracle is still fuzzy to me, so here I am stuck with creating a table. This is my SQL attempt : ...
-1
votes
1answer
24 views

sequence id in oracle

I am using Oracle 11g. I have a senario like: I need to increase auto increment id like below 00000001 00000002 00000003 00000004 For example, my table looks like below id empid name ...
-1
votes
1answer
247 views

Commit and rollback in Oracle stored procedure

In my Oracle stored procedure, I have multiple insert and update statements like below: create or replace PROCEDURE SPTest AS BEGIN insert into emptest(empid,empname,deptno) (1,'ravi',10); ...
0
votes
0answers
77 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
16 views

update multiple column from multiple tables [duplicate]

I am trying to update multiple columns from multiple tables. My query like below but this is not working , how can write in correct way to update this. UPDATE Z_test_agl_asset a Z_test_cust_att c ON ...
0
votes
0answers
93 views

update multiple columns from multiple join tables with selected data from multiple tables in where condition

please help me. UPDATE Z_test_agl_asset a, Z_test_cust_att c ON (c.customattributes_id=a.asset_customattributes_id) , Z_test_cust_att cc ON (cc.customattributes_id=c.extendedcustomattributes_id) ...
0
votes
0answers
27 views

Materialized View

I am new to oracle I have problem can any one help me please. I have one base table, and my requirement query like below. SELECT a.asset_id, a.asset_customattributes_id, cc.string21 AS string46, ...
1
vote
1answer
26 views

What is the privilege my user requires to be able to grant CONNECT, RESOURCE and CREATE SESSION to other users in Oracle 11g?

What is the privilege my user requires to be able to grant the following privileges CONNECT, RESOURCE and CREATE SESSION to OTHER users in Oracle 11g?
0
votes
2answers
155 views

Oracle server 11g stops working with 12541 error until IP address changes

Running Oracle 11g 11.2.0.1.0 Server mysteriously stopped accepting connections to its databases. In other words, you run sqlplus and try connecting as any account and get an error that the listener ...
0
votes
1answer
67 views

parsing and purpose of oracle audit (.aud) logs

I am looking at the oracle audit logs and am trying to understand and parse. The format appears to be consistent: Date Length: Action: ...etc My questions are: 1) what generates these? Is it every ...
2
votes
2answers
185 views

How to convert html entities in Oracle?

I'm trying to decode html containing html entities. I've tried dbms_xmlgen.convert and utl_i18n.unescape_reference but the results are less than satisfactory. SET ESCAPE ON; SELECT ...
1
vote
0answers
66 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 ...
0
votes
2answers
463 views

Slow import for users .DMP files in Oracle 11G

After upgrading my DBMS Oracle 10g to 11g, when it will import user files, they are slower than the old version. A .DMP file in Oracle 10g with the size of 20GB takes almost 1 hour to import, but ...
0
votes
1answer
45 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
94 views

How to install oracle 11g XE and use the data files of another instance (like Postgres)?

I installed Oracle 11g XE in Windows 7 x64, then Windows 8.1 (install new OS, not perform an upgrade of the previously Windows 7 x64 installation). Can be possible to install Oracle 11g XE over the ...
0
votes
1answer
82 views

Oracle Hierarchical query: how to follow max on each level

I'm trying to get a query to "follow" the max values in each level excluding the max values in other branches. Here some examples to illustrate what I'm trying to achieve: Given this hierarchical ...
0
votes
0answers
145 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
1answer
31 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 ...
1
vote
1answer
1k views

Composite primary key from multiple tables / multiple foreign keys

I want to build a composite primary key made up of foreign keys from two different tables. I'm still pretty green to this... A great answer was given to building a composite key from multiple foreign ...
0
votes
3answers
118 views

Replacing the results of a row

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...
0
votes
0answers
170 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
1answer
86 views

Select * from (every table in an subselect)

I was trying to get an select * from (for column table result) every table_name with the result bellow, how can i achieve this? (SELECT a.table_name FROM all_cons_columns a JOIN all_constraints c ...
0
votes
1answer
42 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 ...
0
votes
0answers
159 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
1answer
168 views

How to know when a query was executed?

How to find out when a query was executed? I ran a query couple of days ago, I'm not sure about the exact time. I want to know at what date and time the query was executed. Is it possible to get that ...
0
votes
0answers
160 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
3answers
115 views

Delete all the data from all tables

I have a little problem. I have to delete all the data from our database. I don't want to drop tables, only delete the data sets. These are 47 tables in total. I tried the following: Delete ...
0
votes
1answer
81 views

Update table from different table [closed]

UPDATE RBI.RBI_OV_F_DETAIL A SET (BRANCH_ID, BRANCH_NUMBER) = ( SELECT PRICE_BRANCH_ID, PRICE_BRANCH FROM RSE.RSE_SO_F_ORDERS B WHERE A.SOURCE_ID = ...
0
votes
0answers
61 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 ...