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
1answer
153 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 ...
1
vote
1answer
44 views

Oracle how to manage the flashback log space? [closed]

I set db_flashback_retention_target=1440min,Why the flashback log kept 7 days? Thanks! closed as unclear what you're asking by Phil, Michael Green, Tom V, Shanky, Andriy M Jan 5 at 12:53 Why the ...
1
vote
1answer
157 views

compare 2 tables with minus with a SDO Geometry shape column

if I have a column like SHAPE: CREATE TABLE SOL_PUBLIC.PUNCTE_PERIMETRU_SIT ( ID NUMBER(10) NOT NULL, NUMAR NUMBER(19), X ...
0
votes
1answer
221 views

Check Oracle Service is Started from Batch Command

Uses: Oracle9i Standard Ed; I have a schedule which performs a Dump Import and afterwards the System Reboots itself, which is happening without any problem. After the System had rebooted, I have ...
1
vote
2answers
55 views

Checkpoint during Backup

Can database process make automatic checkpoint when I'm in process of copying files during ALTER DATABASE BEGIN BACKUP; and ALTER DATABASE END BACKUP; You can assume that process of copying ...
1
vote
3answers
61 views

Retrieving the top row of data

I have very limited SQL knowledge and need to report on the top most current row of data within a table. The table holds Effective Date, Information and a Renewal Date. select DATA_KEY_ID, ...
1
vote
2answers
679 views

Specify NLS-Settings during Oracle installation under Windows

Is there an easy way to specify NLS parameters for the database during the installation? We want to install a new database (environment: Windows). For testing purpose we need NLS settings for ...
0
votes
1answer
41 views

Synchronous data transfer from SQL Server to Oracle

I have a requirement like: The table is present both in a SQL Server Database and an Oracle database with appropriate data types. Whenever a record is inserted into or updated in SQL server ...
0
votes
1answer
567 views

Unable to access OEM 11g grid control after upgrading to Firefox ver 39.0

Previously, I have encountered the similar issue after upgrading Firefox to version 37.0.1. Here's the link of the question posted: Unable to access OEM 11g after upgrading to Firefox ver 37.0.1 I ...
0
votes
0answers
80 views

Performance tuning of a SQL query

Problem statement: I have a table which stores the customer, related customer and count of related customers. The related customer can have again further related customers it's like a recursive ...
0
votes
2answers
55 views

Can Oracle databases start automatically when Windows machine is booted/rebooted?

In one of my client machines every time Windows starts we have to start the Oracle database manually. Is there a solution/ command to start the database automatically when the machine is ...
0
votes
1answer
1k views

Export, based on query, into INSERT text file

I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
1
vote
1answer
2k views

startup mount issues with Oracle

I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the command shutdown immediate;. I get the Database ...
2
votes
2answers
1k 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 ...
1
vote
1answer
2k views

Achieve log transfer to standby (Data Guard)

I am not able to transfer my archive logs from primary to standby. I executed the following query: archive log list Database log mode Archive ...
1
vote
1answer
62 views

How to correct this oracle error?

This query SELECT praogrupos0_.ID_GRUPO_SEDE "ID1_209_", praogrupos0_.ID_EJERCICIO "ID6_209_", praogrupos0_.ID_INSTITUCION_LIQUIDADORA "ID7_209_", praogrupos0_.ID_PERIODO "ID8_209_", ...
1
vote
1answer
288 views

How to create DBA user from oracle APEX 11gR2 XE

Please anyone tell me how to create DBA user from ORACLE Application express(http://127.0.0.1:8080/apex/apex_admin)? I installed Oracle 11gR2 XE on windows 8.1 PC and I am able to login to Oracle ...
1
vote
1answer
165 views

ORA-01406 while building a Sphinx index

We are getting ORA-01406 error while trying to build an index over Oracle DB using Sphinx: root@bdt:~# ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ NLS_LANG=AMERICAN_AMERICA.UTF8 indexer bsrpIndex ...
1
vote
2answers
7k views

ORA-02049 and ORA-02063 Errors

Select For UPDATE NOWAIT is performed on a table by 20 processes in parallel The error below is returned by the 4 processes out of 20 (16 processes are successful) SQL_UPDATE_ERROR- : SQL update ...
3
votes
2answers
580 views

Security for Oracle linked server from SQL Server

I'm trying to make the linked server from SQL Server 2005 to Oracle more secure by not having user/pass on "Be made using this security context:" fields so only a specific user can access the data ...
0
votes
2answers
3k views

Oracle schema import is not importing all the tables present in the schema dump file

I have exported an existing oracle schema from another machine and then imported it in my local machine. Import was successful, but some tables which are present in the export dump file are not ...
3
votes
1answer
117 views

I want to change oracle “homedir” how to do?

A good link as answer is ok. I want to change "homedir" or "basedir" of oracle db from /oracle to /var/oracle. How to do? I have set the oracle unix variables($ORACLE_HOME,$ORACLE_BASE) with the new ...
1
vote
1answer
22 views

Whether Cold backup method can be used to “migrate oracle DB”?

I have to migrate one database. I have exact server replica. (Same directory structure on target as well as source database) Previously i have performed DB migration using export/import datapump (As ...
3
votes
1answer
1k views

Standby controlfile error

I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
0
votes
2answers
91 views

Trigger to compare inserted value with value from another table

I have two tables: Stockitem (serialno, qty) serialno is the primary key and Order(serialno,orderno,qty) orderno and serialno are the primary keys. I want to create a trigger in order to ensure ...
0
votes
1answer
4k views

ORA-01033: ORACLE initialization or shutdown in progress using Oracle Express

I am using Oracle Database 11g Express Edition. I'm on Windows 7-64Bit I get this error when trying to access the database: ORA-01033: ORACLE initialization or shutdown in progress I set up the ...
2
votes
1answer
1k views

sqlplus is not starting

I have a strange error on a Red Hat machine. InstantClient is installed in and ORACLE_HOME is set to /opt/oracle/product/112030_cl_64/cl/ The user which installed the client was oracle:oinstall. My ...
2
votes
2answers
4k views

Trouble setting up Nagios to monitor Oracle services

I've got an install of Nagios XI that doesn't seem to want to talk to any of my Oracle services here. I've pulled out the monitoring command and am running it manually, after setting ORACLE_HOME and ...
0
votes
1answer
383 views

Oracle 10gR2 - fix for SSL version following Poodle attack

We use Oracle utl_http to send https requests from within our database (10gR2). As SSLv3.0 is now considered insecure (POODLE) we need to upgrade to TLS. How can we ensure TLS usage when sending ...
0
votes
2answers
246 views

sqlldr running slow after indexes created

let me explain this.... I had running 1 session of sqlldr while I run indexes into table for 6 fields... now the indexes are completed but the sqlldr running very slow it load one file after each 30 ...
3
votes
1answer
2k views

How to separate out individual sql statements from Oracle SQL script for execution from java code

I have Oracle DB 11g Enterprise Edition and I want to execute sql script from my java code. I am reading this sql script from a .sql file and the script contains statements such as create table, ...
0
votes
1answer
234 views

Oracle DB Point In Time Recovery faulted

I'm testing a procedure via RMAN backup to retore/recover at recover-point, but it fails. Exactly I've executed the first time and it works: Backup: RMAN> backup database INCLUDE CURRENT ...
4
votes
1answer
85 views

Result on execution of any SQL is number 2

After successful execution of any sql in oracle sql command line it shows 2 like i want to see the table or description of any table it show 2 instead of showing the table. SQL> select * from dual ...
2
votes
2answers
317 views

How to setup Oracle at Amazon RDS

I created a Relational Database Service (RDS) with Oracle database at Amazon Web Services (aws.amazon.com). However, when I attempt to connect to the database (with SQLDeveloper or Navicat), I am ...
4
votes
2answers
2k views

Loading XML documents to Oracle 11g DB with control file

I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
1
vote
1answer
70 views

Error at line 1, column 25: ORA-00923: FROM keyword not found where expected

I have some code that works in Access but now I want to forward the code to our IT department to make a view in our SQL database. Could anyone please help me convert it so it is correct for normal ...
1
vote
1answer
38 views

DB2 Naming Standards - Similar to OFA

I'm an Oracle DBA getting started on DB2. On Oracle we have a document called Optimal Flexible Architecture that sets a group of naming standards, like what should be the disk name for the database. ...
0
votes
1answer
142 views

How to install GLOBAL schema on Oracle 12c?

GLOBAL schema need to be installed for Oracle OLAP 12c. This link gives steps for installing GLOBAL schema on Oracle 11g and there is no page for Oracle 12c. ...
0
votes
2answers
54 views

Using a query in an update

I have a query which generates a result set (key, a, b). I want to use an update statement where, for each entry in a table with Tkey = key, set ColA = a, ColB = b. How would I do this? Right now ...
0
votes
0answers
29 views

Oracle - compressed subpartitions in uncompressed table

I am working with Oracle 11.2. I have table which on subpartition level has in DBA_Tab_subPartitions column COMPRESSION set to ENABLED for all subpartitions. But on partition level in ...
0
votes
1answer
394 views

Connect by prior - multiple fields and query efficiency

I have 2 tables one of which defines the hierarchy for the other equipment id desc 1 item1 2 item2 3 item3 4 item4 5 item5 6 item6 7 item7 8 item8 ...
6
votes
2answers
152 views

Precision of NVARCHAR2 column is 1.5 times lower than displayed by desc command

I wanted to update precision of an nvarchar2 column and came across an interesting case. I have tried to replicate it below: create table test_table1 (col1 nvarchar2(100)); table TEST_TABLE1 ...
0
votes
2answers
46 views

How to transpose rows to column in datatabse [duplicate]

I have one table which contain 3 column,Col_ID, Col_Group, Col_Price for this my column is like below Col_ID Col_Group Col_Price 1 AA 0 1 BB 2000 1 ...
0
votes
1answer
36 views

Grouping a sequence into ranges

I have 50000 students records in different exam centers having different subjects, in oracle table like this: Center_Code Roll_No PaperCode 10050 1 711 10050 2 ...
3
votes
0answers
260 views

Fast restore of dropped partitions

I want to test the restore of erroneously dropped partitions of a subpartitioned table. This restore would consist of three steps: restore the database (or at least the necessary tablespaces) to the ...
2
votes
1answer
58 views

How to find the number of rows changed by an UPDATE statement in Oracle?

Imagine the following table: id | name | family ---+------+-------- 0 | John | Smith 1 | Mary | Winters 2 | John | Doe and now the following statement: UPDATE t SET name = 'John' WHERE id = 0; ...
1
vote
1answer
49 views

Oracle TNS Permission denied when creating database

I hope you can help me. I need to restore an Oracle 9i (9.2.0.6.0) database on a Windows Server 2003 R2 x64 from a cold backup. I managed to get the 9i installer and the version patch (since I was ...
2
votes
1answer
879 views

Finding why an Oracle listener got automatically restarted

I got the following message in the <listnername>.log file. I want to find out the reason why it got automatically shutdown and restarted again with different PID. 03-MAR-2013 03:00:57 * ...
0
votes
1answer
66 views

oracle conversion variable value to sequence name

please can someone help me? I want to call a sequence from a variable (seq_x) as in the code but I cannot. if :op.qt is not null then select BATCH_X_SEQ into seq_x from kbatchseq where ...
1
vote
1answer
466 views

How to select data out of an Oracle collection/array?

Due to needing some complex data manipulation and not being able to use PHP, I crafted a procedure (not stored, it's just run when we run the query) in Oracle to manipulate the data and store it in an ...