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

-1
votes
1answer
52 views

Cannot UPDATE a view that uses a join

create view drums as select emp.sno,emp.name,emps.sal,emps.deptno from emplys emp inner join employees emps on emp.sno=emps.sno where emp.deptno<5; when I use this update drum set ...
-1
votes
1answer
1k views

Oracle Alter table add partition by reference gives “invalid datatype” error but create table with partition works

I have a parent and child tables. Parent table has a partition and a sub partition. Child table needs to have reference partition based on parent partition. Problem: If I create a new child table and ...
-1
votes
1answer
167 views

Connect to Oracle remote Database by only installing a client on my laptop?

Is it possible to connect to remote oracle database from my laptop if I only install instant client, without installing oracle database? I have the tnsnames.ora and listener.ora files in ...
-1
votes
3answers
405 views

Should tables with very large records quantities be split into multiple tables

I'm working on an application (asp.net) that deals with a very high record count -- let's estimate about 75 million events per year coming in fairly evenly throughout the year, and each of these ...
-1
votes
1answer
128 views

problem faced while starting up a database in oracle

I have created a database named 'test' in oracle 11g express edition.Now while I am trying to stratup "test" after shutdown of database, by default "XE" is getting started.How I solve this problem?
-1
votes
3answers
319 views

Trouble quering a join in oracle sql

Theres a question on an exercise which asks me to write an SQL statement to show the SKU, SKU_Description, WarehouseID for all items stored in a warehouse managed by ‘Lucille Smith’. I have to use a ...
-1
votes
2answers
891 views

use of synonyms in oracle

I want to know the usage of Synonyms in oracle.I have searched in internet there i have learned like synonyms will be created in one schema and we can use that in another schema. But still am not ...
-1
votes
1answer
378 views

Restoring Oracle XE database

I had Oracle 10G XE installed on my Windows machine. The machine got corrupted and I will have to install Oracle again. I did not take a backup in the form of SQL queries. How can I use the old ...
-1
votes
1answer
673 views

What must I already know to get profound knowledge in Oracle [closed]

I've been working with relational database systems for about 4 years, 2 years in Oracle particularly. I've been able to do pretty much everything I've needed so far but I know that the knowledge I ...
-1
votes
1answer
3k views

how to connect remotely to oracle database [closed]

I've installed oracle 11g express edition and sql developer. I don't know ho to connect to a database on remote server. Can anyone help please. Note that I didn't installed any other software like ...
-1
votes
1answer
688 views

How to get how many rows are inserted in ORACLE?

How do I get how many rows are inserted after executing an INSERT statement? I'm using Oracle 11r2 with MyBatis in Java.
-1
votes
2answers
2k views

Data Base Administration Oracle vs MySql? [closed]

I have worked with MSSQL for a while now, but now we want to try to move to some open source for a specific part of the company's products or explore Oracle if possible. What would you say are the ...
-1
votes
0answers
45 views

Oracle session killed, but the table still not released [on hold]

Oracle session killed(using alter system kill session command), but the record is still not released(err : could not reserve a record), even after restarting DB server (node 1 and 2) and all ...
-1
votes
2answers
64 views

Oracle SQL Query

Query the two cities in STATION (Table) with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or ...
-1
votes
0answers
27 views

Currently running TOP Sqls [on hold]

I am trying to make Top 10 Sql that currently running. I have 2 queries which makes this but i could not understand the logic. I hope you guys can help me to make it. First SQL is ; select ...
-1
votes
0answers
29 views

What are a flashback and bounce? [duplicate]

In the context of a database backup, specifically, Oracle, what is a bounce and a flashback?
-1
votes
0answers
24 views

group by ranges based on self joins

Here is what I'm trying to accomplish. I have a list, for simplification, I will make it ordered. 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. Let's call these segments. Each segment is connected by a next and ...
-1
votes
1answer
47 views

Alter - Subpartition a partitioned table

I have a table which is partitioned by RANGE on DATE key CREATE TABLE T1 DOC_ID VARCHAR NOT NULL. STATE VARCHAR ... DOC_DATE ... PARTITION BY RANGE (DOC_DATE)( PARTITION feb16 VALUES LESS ...
-1
votes
1answer
34 views

Can you view the Oracle listener status from OEM?

Is it possible to view/monitor the listener status from Oracle Enterprise Manager (OEM)? If so, how is this done?
-1
votes
1answer
78 views

Oracle - Service Account vs Database Account?

I'm a developer and not a DBA, specifically not an Oracle DBA. I have a Java application that is connecting to a Oracle 11g R2 database. I have an account and schema called "OBR". I am being told the ...
-1
votes
0answers
35 views

Unable to start Oracle database [duplicate]

I have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
-1
votes
1answer
228 views

How to resolve parameter file error

I log on to my database but giving me this error message ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ...
-1
votes
0answers
56 views

Getting error ORA-01034: ORACLE not available [closed]

I am getting this error while connecting my database in oracle sql developer. ORA-01034: ORACLE not available. ORA-27101:Shared memory Linux Error:2:No such file or directoy
-1
votes
1answer
155 views

Return Distinct Set of Values Based on MAX Date

I'm new to SQL and I am really struggling to put a specific query together. Let me start my question by explaining what fields & tables I am dealing with. Table A Table B The unique key is ...
-1
votes
1answer
618 views

Can't open/select a table created with another user

I created a table with one user and cannot read or select the table after I log in with another user. Database: Oracle Name: TestDatabase User name: sysadmin Another user "user1" was created in ...
-1
votes
2answers
4k views

Unable to mount database: error reading control file

I have an installation of an Oracle XE on Windows 7 (Home Premium). The database worked fine until yesterday when the database could not be started. It reports ORA-01033: oracle initialization or ...
-1
votes
1answer
38 views

Use Oracle 10g BI enterprise edition with Oracle 11g database

Can i use Oracle 10g BI enterprise edition with Oracle 11g database. please tell. Thanks.
-1
votes
1answer
9k views

How i can solve “ORA-03113” error when i startup oracle 11G database?

I have followed the link and others link from this site to solve my problem but I still have not solved the problem. All I get is the following: Microsoft Windows [Version 6.1.7601] Copyright (c) ...
-1
votes
1answer
1k views

Oracle Partition Table Space Issue

I have a table with list partitions on it. When i insert data i see that all the partitions have default initial size of 8 MB and I also noticed that when i truncate full table and check size it still ...
-1
votes
1answer
89 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
-1
votes
1answer
620 views

Shutdown immediate displays an error

During my shutdown for the database, there is ora error message return and it won't let me shutdown my database. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ...
-1
votes
1answer
497 views

Slowness after migration to RAC 11gr2

we are getting slowness after migrate from ORacle 10gr2 single db to Oracle 11204 oracle rac (standard ed) with asm, on oracle solaris 11. at this momento we have only one node. In the next days we ...
-1
votes
1answer
3k views

How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?

This error shows up when I try to connect to database string host:port/servicename.
-1
votes
1answer
121 views

Oracle 11g database server password rollbacks

Hi everyone, I installed oracle 11g Database server in windows 2003 server. I changed the password. It works very well when I start at first. After restarting, the password is not at all ...
-1
votes
1answer
497 views

What is Oracle Database Vault and how does it work?

I am new in oracle database.I am following oracle official site for learning oracle database vault.But i am not satisfied yet.Please help me for getting a preliminary knowledge about oracle database ...
-1
votes
1answer
442 views

Inserting dates before year 1950 in Oracle

How can I insert date which is before 1950? update up_sif.tb_person set dateB =to_date('18.10.1949','DD.MM.YYYY') where ID = '123345'; It keeps update with date 18.19.2049. Any ideas?
-1
votes
0answers
212 views

Changing password doesn't work [closed]

I need to login to a database. I have good credentials, but when I was trying to login with SQL Developer, I got this error message: ORA-28001: the password has expired Then I tried to login ...
-1
votes
1answer
165 views

I want to change ORACLE level#2 to log archiving mode instead of the current mode

I want to make that change to the archive log mode to use the redo log files to use it to make replication to database to another server. This is easy and possible when the server is single not ...
-1
votes
0answers
107 views

script to startup oracle database [closed]

I found out below script that helps me to start up a Oracle database: set serveroutput on; WHENEVER SQLERROR EXIT SQL.SQLCODE STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "MY_DB" NORESETLOGS ...
-1
votes
0answers
439 views

Synchronising SQL tables in two locations [closed]

We have a bit of a conundrum at the moment. ANSI SQL solutions please. We have two databases located at two different geographic locations and will be using the web for all traffic between the two ...
-1
votes
1answer
8k 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
-2
votes
1answer
57 views

Oracle Concurrent Insertion

We have simple case like Create table t1 (c1 number primary); session1: insert into t1 values (1); //session1 do not commit transaction session2: insert into t1 values (2); Will Session2 ...
-2
votes
1answer
1k views

Stored procedure syntax error [closed]

I am writing a procedure, independently the queries run fine with no errors.. But, when I run it as a procedure I get errors. Given below is my procedure create or replace PROCEDURE xyz(inuserid ...
-2
votes
1answer
331 views

Important distinctions between DBMSs [closed]

DBA is a career I'm strongly considering after school, but my limited experience mostly involves some PL/SQL Oracle web programming, some basic PHP/MySQL web pages, and some queries in SQL Server. ...
-2
votes
1answer
99 views

Display top 5 sales and bottom 5 sales in the same query

I want to display the top 5 sales and the bottom 5 sales in the same query in Oracle, not in PL/SQL.
-2
votes
1answer
35 views

Merging two rows when there is a duplicate value in one of the columns [closed]

Consider a table T1, having columns C1, C2, C3... C1 C2 C3 CAD PF1 100 CAD PF2 200 USD PF3 300 Result should be C1 C2 ...
-2
votes
1answer
45 views

Display Error getting while installing oracle 9i on centos 64 bit

I want to install Oracle 9i on Centos using only command line. I tried to run installer using command line by silent but getting error as below. [oracle@XXXXX]$ ./runInstaller -silent DISPLAY not ...
-2
votes
1answer
281 views

Moving from Oracle 11.2.0.1 to 11.2.0.3

We are going to upgrade our database soon from Oracle 11.2.0.1 to 11.2.0.3 We have our customer relation application that runs on the Oracle background. Both Oracle and the company that designed the ...
-2
votes
1answer
34 views

Is there any way to know all the tables(and/or views, triggers, functions) present in the Oracle 9i database?

I want to know this because, I forgot the name of the table I created Using Oracle 9i Thanking you for your time.
-2
votes
1answer
2k views

Where can I download the Oracle Fusion Middleware Infrastructure Software? [closed]

I understand that since version 12c the Repository Creation Utility for Oracle Database 12c (RCU) is part of the Oracle Fusion Middleware Infrastructure Software. This brings me to the question: ...