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

0
votes
0answers
19 views

alter database open - Oracle11g [on hold]

Because of some issues i had faced I'm trying the below query on oracle 11g. But its throwing error. Could anyone please help Query:alter database open ERROR at line 1: ORA-00600: internal error ...
0
votes
0answers
19 views

ORA-01033: ORACLE initialization or shutdown in progress [on hold]

I'm facing the below error while trying to login to database. Oracle services were up and running but was not able to login. Error:ORA-01033: ORACLE initialization or shutdown in progress I tried to ...
0
votes
0answers
10 views

can we create a user defined groups with different users and different schemas in oracle11 g [on hold]

i want to create a group of different users in which they are able access different database .To that particular group i need to give limitations for accessing to the database. can any one help to ...
0
votes
0answers
18 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
1answer
11 views

How do i prevent executing os command in oracle 11g

I have Oracle 11g installed on a linux serveur and i'm looking for a way to prevent sysdba from executing system command through oracle(Using java for example).
2
votes
2answers
817 views

Unable to start Oracle Database Server : Get an error as I try to start it

I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop : but as I click this icon I see this dialog box : What is it ? How do I ...
0
votes
0answers
17 views

Accounting Program Error [on hold]

I have Oracle Application R12 running on 11g. The error occurs in Accounting Program when we are running Create Accounting session in Payable Module. When we click on Diagnostics it gives this ...
0
votes
0answers
17 views

Unable to open display to specific user in Red Hat 6.4 [on hold]

I am trying to install Oracle database 11g in my Red Hat 6.4 and the installer abort with a warning followed by a error message: Warning ">>> Could not execute auto check for display colors ...
0
votes
2answers
206 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
38 views

Sql*Plus ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

I installed Sql*PLUS on a cloud Oracle Linux Environment in order to access an remote database. I used the installation instructions provided as an answer here: ...
0
votes
1answer
194 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
1answer
23 views

Oracle grant select on a table

I want to grant select permission on a specific table to a remote ip address I had done it before in Mysql with this: grant all privileges on mydb.* to myuser@localhost identified by 'mypasswd'; ...
0
votes
1answer
114 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 ...
2
votes
1answer
62 views

With Clause vs View of the same name

In my database, there is a view named VAL_DATES_V which is used in many other views in the same schema. For example, the SQL code in the view SECTOR_V uses VAL_DATES_V. CREATE OR REPLACE VIEW ...
2
votes
2answers
2k views

Can't drop UNDO TABLESPACE

We have oracle 11gr1 rac two instances on two different servers, new undo tablespace UNDOTBS20140508 created 30G, I want to remove the old one UNDOTBSX02, I did the following: CREATE UNDO TABLESPACE ...
7
votes
1answer
414 views

Designing Simple Schema for Disaggregation of Demand Forecast

I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case: I have a parent-child hierarchy of products (example, Raw ...
0
votes
1answer
104 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
3answers
124 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 ...
1
vote
1answer
5k views

Net Start OracleXETNSListner

I am trying to run Oracle Express Edition on Windows 7 and getting the following error. C:\oraclexe\app\oracle\product\1O.2.O\server\BIN>net start OracleXETNSListener System error 5 has ...
0
votes
0answers
18 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
10 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
1answer
41 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
2answers
117 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. ...
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
31 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
39 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
37 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
28 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
21 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 ...
1
vote
4answers
15k views

Oracle Export using EXPDP gives ORA-06512 SYS.UTL_FILE error on Windows 7

I am using Oracle 11g and want to export a table using below statement C:\>expdp SYS/sys@MYDATABASE DIRECTORY = Mydir DUMPFILE = Customer.dmp LOGFILE = Customer.log TABLES = PERSON.CUSTOMER ...
0
votes
1answer
72 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
2answers
3k views

How to see profile assigned to a user

Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it. Now how can i see for TEST_USER which profile has been assigned? I want some query that will check what profile a ...
2
votes
2answers
10k views

insufficient privileges while executing oracle stored procedure?

Im getting insufficient privileges error while executing the following oracle stored procedure. Im using Oracle Database 10g Express Edition. CREATE OR REPLACE PROCEDURE sp_update_acounts( ...
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
2answers
442 views

Changes in Oracle Database implicit conversion rules for select statement

Due to hardware failure after a power outage we had to recreate the database for one of our 3rd party applications from an dumpfile (created via exp). The old hardware had Oracle 10G R2 running while ...
0
votes
1answer
23 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
80 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
0answers
20 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
45 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
51 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, ...
9
votes
1answer
34k views

Oracle 11g listener fails with ORA-12514 and ORA-12505 errors

I run an instance of Oracle 11g locally on my development machine and can connect to the local instance directly via SqlPlus: c:\>sqlplus ace SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar ...
1
vote
1answer
49 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 ...
3
votes
2answers
12k views

How to execute this procedure in PL/SQL?

I have this table in the below format: Persnbr | Userfieldcd | Value 01 | Port | Funds 01 | Vip1 | Systems 02 | Port | Bank 02 | Vip1 | Authority This is how I want ...
0
votes
1answer
70 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 ...
-2
votes
2answers
26 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 ...
1
vote
0answers
82 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 ...
0
votes
1answer
82 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
16 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 ...
1
vote
2answers
6k views

Adding subpartitions to existing partitioned table

In Oracle 11g, is there a way to introduce subpartitions into an existing partitioned table? I cannot seem to find a combination of EXCHANGE and SPLIT partition that does the right thing. SPLIT will ...
13
votes
6answers
28k views

Best way to delete very large recordset in Oracle

I manage an application which has a very large (nearly 1TB of data with more than 500 million rows in one table) Oracle database back end. The database doesn't really do anything (no SProcs, no ...