Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...

learn more… | top users | synonyms

1
vote
2answers
3k views

Advice for ETL from Oracle to SQL Server?

I'm building a data mart in SQL Server which needs to extract each month from an Oracle database. Currently this is done by exporting to flat files, then running all the inserts/updates in SQL ...
0
votes
0answers
269 views

implementing DAC and MAC in Oracle

I want an example that might help me implement a dynamics modes of an access mode model. From from page 58 of Secured Database Application Development: Static Access Modes are: use 1 ...
-3
votes
2answers
873 views

Versioning data in Databases [closed]

Is there any ready mechanism in Oracle, SQL Server, PostgreSql or OR framework (C#), which can version information in a database? By versioning informartion I mean that e.g. I have table Person (id, ...
4
votes
3answers
996 views

STARTUP command fails : Why is that?

I just installed Oracle Database Express Edition 11g Release 2.This is the first time I am using Oracle. Earlier I have used MySql and MSSql and I bet this one is a lot different ! These are the ...
3
votes
1answer
17k views

What queries is Oracle executing, how frequently, and time-taken?

I have a (Java) web-application, that of course executes many queries (selects, inserts, updates, deletes) to the Oracle Database. I want to find out the following for last 7 days: SQLQuery ...
1
vote
0answers
102 views

How open oracle DB Linux (After installation)

I have just installed Oracle 11gR2 on my Linux Mint Distro (xfce). All worked fine, and I was able to acces to https://localhost:1158/em [Erreur 102 (net::ERR_CONNECTION_REFUSED) ] I rebooted my ...
2
votes
2answers
816 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
61 views

Hard Parse on Non-Identical Statements?

Let's say I have this query : SELECT X FROM Y If I run it for the first time then it would do a hard parse. After that, I run this query : select x from y With just a difference in alphabetical ...
6
votes
1answer
6k views

When a record is locked in Oracle, can we know which record is locked?

When a record is locked ,can we know which one is locked? How can I get the record rowid or something else info? I can get some info by this sql SELECT ...
1
vote
1answer
105 views

In Oracle, will certain users only be able to see certain data in the privileges tables?

I can view data in the table_privileges view logged in as a particular user, but it seems to be missing or different information when logged in as a different user. For the privileges views (data ...
2
votes
4answers
1k views

A database trigger is an alternative for?

I had the following quiz question and could not answer it myself because of a little confusion. Please answer this and tell me why? A database trigger is an alternative for? A. Stored ...
3
votes
1answer
67 views

Special ordering

I have a hierarchical query but I don't manage to order it as I want. I have a column named sequence that indicates how to order it but the data is kinda mixed up and I cant do it properly. This a ...
0
votes
1answer
130 views

Oracle ASM Backup Strategy

When the Full Backup (hot backup) happens and let us say it takes about 5-6 hours to complete. Then what about the Transactions that happen during the backup. Will it be recorded in the Backup file ...
1
vote
1answer
803 views

Connecting to Oracle SQL Developer locally on Mac?

I'm trying to connect to Oracle SQL Developer locally on my Mac. How exactly is this done? I've looked all over the network, and can't find anything helpful. The only thing I did is installing the ...
6
votes
1answer
1k views

Global locking for multi-master Oracle GoldenGate replication

This is a very complex scenario, but I figured a state-of-the-art challenge might interest some of the many high-end users of dba.se. Problem I'm working on an intercontinental data replication ...
0
votes
0answers
349 views

Understanding the time difference between data grid initial display and export/full display using Toad for Oracle

I am trying to run a query on a local Oracle DB and output the results to a .CSV file. The query runs in a decent amount of time (usually less than 5 minutes), but returns tens of thousands (possibly ...
3
votes
2answers
10k views

Selecting data from multiple rows into a single row

I have a table that has columns like following. Batch number is a database design thing like row number demand_id batch_number debit status customer 34 1 ...
1
vote
1answer
2k views

How to change Oracle user password without showing the actual password on screen?

Is there a way you can change Oracle user password without showing the actual password on the screen? I understand that you can execute ALTER USER user_name IDENTIFIED BY new_password; but this will ...
1
vote
1answer
231 views

Can Oracle Named User Licenses be reused? [closed]

If I have 20 Named users for the month of January, then come February and those users do not retain access but are replaced by 20 new users. Would I need 40 Named users for this use case or would 20 ...
0
votes
1answer
2k views

Oracle create user with privileges to grant references

I want to create an Oracle user who can grant references to other users. Do I need to make him sysdba for that, or is there any other way?
7
votes
1answer
1k views

Generate XML using Oracle XML schema

I have some XML schema definitions that have been registered using DBMS_XMLSCHEMA. I have created tables using the XMLTypes generated. I can create XML using XMLQuery and if I understand correctly, ...
2
votes
2answers
9k views

ORA-12154 TNS: could not resolve the connect identifier specified with SQLPLUS

I am using Toad to connect my database and its working fine for me . But when i try to connect with the same credential , i am getting the error message as shown below: ORA-12154 TNS: could not ...
1
vote
0answers
3k views

Root cause for Invalid arguments in call (ORA-17068)

We are getting Invalid arguments in call when we try to establish the connection with Oracle DB occasionally ( One hour in a day). I did some research about this in Internet, still i am not getting ...
1
vote
1answer
242 views

How to start running queries in Oracle?

I've just installed the last version of free Oracle (11 XE) and I would like to run some queries. I've also installed the DreamCoder IDE to connect to the Oracle but I cannot run any query. Already ...
2
votes
1answer
369 views

LoadBalancing JDBC DataSource Connect without URL

When using JDBC I like the new DataSource-way to establish the connection. Further I like the isolated set-Methods for the properties like setUser, setPassword, setDriverType, setServerName, ...
0
votes
0answers
161 views

Materialized view for a yet-to-be-defined DBlink

In our product we have a main application with an oracle 11g DB and an optional module with another DB. We want the two to communicate through a dblink and I was told to put some code for the ...
0
votes
1answer
2k views

Creating new database and insert values in Oracle 10g xe hr account?

I am new to Oracle 10g xe. When I log into hr account, how do I start creating new database and insert values? My case study is a five aside football league, where the organizer wants to know ...
1
vote
2answers
2k views

Oracle insert max from two date

I want to create an insert statement in a PL/SQL Script that inserts the larger of two different values. Conceptually, what I want to do is something like Insert into MYTABLE (DATE_INSERT) VALUE ...
2
votes
2answers
10k views

How to set Password for sqlplus /as sysdba

I am new to Oracle. I would like to know how to set login password for sqlplus / as sysdba in oracle 11g. I want to set the password for my next login, i dont want to login as sqlplus / as sysdba ...
1
vote
1answer
939 views

What is the difference between Oracle clusterware and Real Application Clusters?

What is the difference between Oracle clusterware and Real Application Clusters? If we have 2 servers and want to join them into a cluster why there are two separate software products?
1
vote
0answers
830 views

Migrating from Oracle to MySQL using WorkBench Migration Tool

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database ...
0
votes
1answer
1k views

Moving data between Oracle and PostgreSQL

For a future project I need to use the following setup: Some small (offline) data boxes (colleting data over the time) fill PostgreSQL databases. (Summing up to about 1 TB a year. For time to time, I ...
1
vote
2answers
2k views

Can a table belong to multiple tablespaces?

Can a table belong to multiple tablespaces?
2
votes
1answer
1k views

How many database licenses do we need for setting 2 servers (nodes) into a cluster?

Suppose we have a server that has only 1 CPU with 1 core, so we need 1 Oracle database license for installing a database into it. Now, if we would need to add a second server, combine them into ...
5
votes
3answers
2k views

Why would one need multiple instances of same Oracle database?

I came across following statement while reading this short article - An instance is the software (and memory) that Oracle uses to manipulate the data in the database. In order for the instance ...
11
votes
3answers
778 views

Is there any way to break out of the string and inject SQL without using a single quote in oracle?

I'm testing an oracle based application and I've found the following code: Query = "SELECT name FROM employees WHERE id='"+PKID+"';" i.e. the query string contains quotes around the PKID value which ...
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 ...
1
vote
1answer
5k views

Oracle 10g dump file into Oracle 11g database

I went through this link for my answer to the same question. I was not sure if i could continue in the same link, so created a new question. Oracle 10g dump file push into Oracle 11g database Sorry ...
0
votes
2answers
238 views

Oracle 10 UPDATE query

I get 0 rows updated message when I ran the query below. Why? Any ideas? Update salespersons set salespersons.salary = salespersons.salary * 1.12 where salespersons.empid = (SELECT ...
1
vote
1answer
327 views

Struggling with complicated date query

So I have been tasked to write a query involving dates for a contract management system we have. The database stores the date the contract's primary terms expired, the frequency that the contract ...
0
votes
2answers
251 views

How to influence Oracle backup output size?

I have two environment one Prod one Dev. Dev is created by Prod data and both have a similar database size. However, the backup output size varies greatly. Prod is about 300 M while Dev always above ...
1
vote
1answer
4k views

conversion of high_value to date datatype

I need to comparte the high_value which is of LONG datatype to sysdate which is of DATE datatype. I need to fetch the partition names of all the partitions which is 90 days old. The code is some what ...
0
votes
1answer
2k views

How to return different statements in where clause ? (oracle)

I mean: CREATE OR REPLACE FUNCTION FUNCTION1(ID IN NUMBER) RETURN NUMBER BEGIN SELECT COLUMN1, COLUMN2, COLUMN3 FROM TABLE1 WHERE COLUMN1<= Y AND (CASE WHEN ID < X THEN COLUMN1<COLUMN2 ELSE ...
4
votes
1answer
18k views

temporary table inside procedure oracle

I'm in a situation right now. I'm migrating several procedures from Mysql 5.0 to Oracle 11g. Mysql procedures allow me to: 1. Create temporary tables 2. Insert data into temporary tables / Query these ...
6
votes
3answers
2k views

Clustered index in SQL Server vs index organized tables in Oracle

I am making the transition as a database developer from SQL Server to Oracle and found some fantastic resources here already (How to make a transition from SQL Server DBA to Oracle? and As a DBA, how ...
2
votes
1answer
7k views

unable to login oracle as sysdba

I just got 11gR2 running and was able to conn as sysdba. I shutdown and started up the database to mount a new pfile. Now, I cannot login as sysdba. My parameter for password file is: ...
4
votes
2answers
12k views

How and when to use sys_refcursor in oracle

Can some one give me a small explanation about how and when should someone use sys_refcursor ?
2
votes
1answer
112 views

Oracle Table Design, Storing Small Values

In Oracle if you want to store a small value, such as a one digit code (e.g. 0, 1, 2, 3 4, or Null; or Null, or 1; or 1, or 2), what is the space optimal way to store such a value. Currently I'm ...
0
votes
0answers
2k views

12154 error when using PL/SQL Developer

I have installed a few versions of Oracle on my machine. I have tried 64 bit and 32 bit versions. I have installed 11G. I need Oracle 10G 32 bit. Using the following guide I removed all versions of ...
3
votes
1answer
265 views

Use a Context namespace in a multi-tenant database?

I'm developing an Apex application that uses database Contexts in conjunction with Row Level Security. I'd like to install a second copy of the schema and workspace on the same instance; this works ...