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
1answer
2k views

Upgrade path - Oracle Standard to Oracle Enterprise

Could I start on Oracle Standard edition and easily upgrade to Oracle Enterprise? Or do I need to rebuild the entire server? how does the upgrade path work?
1
vote
1answer
614 views

Alter table move taking long time

I'm currently trying to compress a table in Oracle with the following statements: ALTER TABLE MYTABLE COMPRESS FOR OLTP; ALTER TABLE MOVE; My question is: the MOVE operation is taking forever and ...
1
vote
2answers
150 views

Most efficient way to perform table operations (spec. drop) on tables having table names that match a certain criteria

I am performing a schema dump of certain tables. This accompanied by dropping the tables that will be dumped. For example I need to drop all tables that start with, let's say, "SRC_". You guys think ...
-5
votes
0answers
62 views

Website is working very slowly [closed]

We have replication from Oracle to MySQL via Oracle Golden Gate. Yesterday because of some issues we have rebuilt the replication from Oracle to MySQL (this is called opal replication). Now our ...
1
vote
0answers
206 views

Monitoring multiple Oracle databases on a single screen

We would like to monitor database activity of multiple Oracle databases on a single screen (10g and 11gR2), divided by the number of databases. Some tools are offered here: Tools to monitor Oracle ...
3
votes
2answers
2k views

DBMS_SCHEDULER event schedule jobs not executed when triggered almost at the same time

I moved this question from stackoverflow to here as it was marked on hold as off-topic. On Oracle 10g2 DB I have set up multiple event triggered DMBS_SCHEDULER jobs and all of them are subscribed for ...
4
votes
1answer
2k views

Does SQL Server 2008 have an equivalent to Oracle's “table%rowtype” syntax or (Data Type)?

In Oracle PL/SQL scripts, you can declare a variables using the syntax tablename%rowtype for its type. This will make that variable have the same "type" as a row of that table (i.e. a it will be a ...
3
votes
2answers
492 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 ...
3
votes
2answers
807 views

How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?

In our data feeds, we have a stack of XML files as well as numerous flat files to put into an Oracle11g database. We flatten the XML into delimited files, and load the whole set using SQLLoader. I ...
2
votes
0answers
3k views

Oracle Select Query Over Database Link Suddenly Hangs Endlessly

I have a query that's been in use for years and today it started hanging endlessly. I took the query apart and found the piece causing it to hang is a simple join on a primary key that should run like ...
2
votes
1answer
116 views

Zero conversion in sql

Char convertion in Oracle have a pattern: to_char(number,'pattern') and provide option "s" to take sign to result, for ex: select to_char(10,'S999') from dual; will return +10, but when i check select ...
0
votes
1answer
152 views

How would you track DB storage use and then extrapolate it?

I need to track the size of various DBs we have, then see it's growth rate so that we can guess where it will be at certain times. I'm using Oracle 11g first, but will eventually be applying this to ...
1
vote
1answer
2k views

How to call an Oracle Function with multi out Parameters though LINKSERVER

I need help as I am facing this problem. when I pass 2 output parameter to a function through a linked server I am getting this error. For 1 out parameter its working fine but when I use two output ...
1
vote
0answers
542 views

Creating view recursive query in Oracle DB results in ORA-00600 (ORA-600)

Hello Ladies and Gents, I've been trying to deploy a recursive query as a view in Oracle XE and Standard Edition, neither to much success. The query is located in this question here: ...
1
vote
0answers
504 views

SQLPlus times out when connecting to an Oracle XE database on another PC

I'm having the strangest issue. I have a very basic (I think) setup of an Oracle 11G database on one Hyper-V VM, and the Oracle 11G client on another VM. Although I'm able to access the database on ...
1
vote
2answers
63 views

Need advice regarding RMAN's working

I have configured a RMAN script which first takes the backup of the database and then deletes the obsolete backupsets according to the present retention policy.Now is there any possibility of the ...
4
votes
2answers
686 views

Multiple JOIN of 6 tables via 5 database instances

I'm currently reengineering my corporates user management and created a table which lists all users of all the 5 database instances. Next step is, that I need to write a query which shows me all the ...
0
votes
1answer
2k views

How to create Oracle RAC database using dbca silent mode with different db_name and db_unique_name

I have a requirement to use dbca (version 11.2.0.3) silent mode to create a RAC database on a 2-node RAC and the db_name and db_unique_name must be different, I tried following dbca command ...
6
votes
1answer
720 views

sqlplus consuming 99% CPU

Oracle's installed on one server, I'm running sqlplus on a different (application) server. I've recently encountered a problem getting sqlplus to do anything; it simply spins, consuming 99% CPU even ...
0
votes
1answer
37k views

Where I can find the tnsnames.ora file for my Oracle Windows client? [duplicate]

I installed Oracle client for my Windows 7 machine. I can connect to a remote Oracle database using Toad for Oracle using the direct method (giving host, port and service name for the connection). ...
1
vote
1answer
2k views

How to limit select output from sqlplus?

I stop using SQL Developer as found more convenient to use SQL Plus inside Emacs SQLi mode. SQL Developer on selects with large amount of rows show only few rows. But SQL Plus tend to dump all rows ...
0
votes
1answer
996 views

Oracle shared memory exception ORA-04031 [duplicate]

I'm trying to establish an Oracle database connection. It throws the following exception: ORA-04031: unable to allocate 4048 bytes of shared memory ("shared pool","unknown object","sga ...
1
vote
1answer
541 views

Migrating Oracle packages to SqlServer

I'm moving database from Oracle to SQLServer (2012 if that matters). The process of migrating tables/views is more or less straightforward and automated. Triggers are also not an issue since I don't ...
3
votes
2answers
204 views

Can I grant privileges to a role without specifying an object?

I am trying to create a role to simplify granting a set of privileges that I often give to users. I am wondering if there is any way to grant these privileges on only the objects owned by their schema ...
0
votes
0answers
272 views

Delete backup directories using RMAN

Is there any way RMAN can delete empty backup directories?
1
vote
1answer
1k views

Create spfile from pfile

I'm having a problem in creating spfile from pfile.I think I don't have permission to write on Oracle Home. I'm using Windows 8 SQL> startup nomount pfile='initlittle2.ora.txt'; ORACLE instance ...
0
votes
0answers
405 views

Creating and tuning a materialized view in oracle for use by Cognos BI

I am currently in the middle of a Cognos BI implementation and am having difficulty in tuning a view in order for SQL Server to select its contents for fulfilling the incremental load in a timely ...
0
votes
2answers
2k views

SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle

I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle". I am using "Export Data..." option from Task menu. I get to connect to the source database (SQL ...
0
votes
1answer
226 views

Error while opening Oracle 11g Database

I have a problem with oracle 11g database, I have shutdown my computer this morning normally, but in the evening when I tried to connect to my database I fond a problem. I cannot connect as normal ...
0
votes
1answer
49 views

Mview replication

We are setting up a large scale replicated environment and would like to know if there is a way to skip certain dml for eg. deletes during data trasfer with simple mview replication. Also, is it ...
1
vote
1answer
367 views

How to keep an Oracle 11g instance lean?

As a Mac user I run a local Oracle Enterprise Linux (OEL) Developer Day VM that houses an Oracle 11g instance for development/unit testing. I frequently refresh the data in the schemas (sometimes ...
1
vote
5answers
5k views

What happens when we create index

What happens exactly when I create an index on the empid column of this employee table CREATE TABLE employee ( empid number(5), ename varchar2(30), sal number(10,2) ); Let's assume the ...
2
votes
1answer
498 views

the value of undo_sql in flashback_transaction_query view is always null

so I have a table defined as follow: `create table test.test as (select * from dual); and ran the following update statements: update test.test set dummy = '1' where dummy = 'X'; commit; I want ...
1
vote
1answer
321 views

Oracle DBF import brings me to a weird situation

I have a big problem . One of my client send me some files to install them to his Oracle server but as a new user in oracle I am not sure how to do that. What I've recieved are this files : ...
1
vote
1answer
839 views

Oracle schema migration to new database with zero downtime

I have a problem: I have two production schemas on one database each serving two different appplicaitons. I need to migrate (move) one schema to an entirely new database that will be dedicated for ...
1
vote
1answer
5k views

Why Oracle SQL Developer does not need Oracle client?

I installed Oracle SQL Developer from Oracle's web page. It seems to work without a Oracle client installed on my computer. How is that possible? I also installed Toad for Oracle and it seems to ...
0
votes
1answer
513 views

Can we create a table in specific datafile - Oracle 11g R2?

I am buying a new server than has two HDs: 300 GB with 15000 rpm. 600 GB with 10000 rpm. I am thinking to allocate the datafiles in both hard disks. and put the less used tables in the data files ...
0
votes
0answers
133 views

Replicating Excel's CHIDIST function in Oracle 11g

I'm attempting to replicate the functionality of an Excel workbook in Oracle. One of the formulae on the worksheet uses CHIDIST, which "Returns the one-tailed probability of the chi-squared ...
0
votes
3answers
70 views

find sold subscriptions from table 1 and store name in table 2, joined by store id. (oracle)

I am trying to get the number of sold subscriptions from one table and the store name from another. The tables have a common column containing a store id, however the columns do not have the same ...
-5
votes
2answers
174 views

Find the salary difference between two months [closed]

Suppose we have 3 columns in a table emp_no, salary, month emp_no salary month 123 1000 jan 123 2000 feb 123 3000 march So, output should look like: ...
3
votes
1answer
5k views

How to combine `delete` and `insert` operations in one statement?

for the following data, I'd like to be able to delete some rows and insert others giving the result below. Is this possible with a single statement (eg with the merge statement)? create table ...
0
votes
1answer
575 views

Call pl/sql function and discard result

I'm calling a function from pl/sql, but I do not require the result in this case. Is there a cleaner way to call this function without using a dummy variable? Works: junk := performWork(); Does ...
0
votes
1answer
120 views

Can I update an Access table with an Oracle table?

I have an Access database with a table with a unique key and price field among other fields. I have been told I have access to an Oracle database with those prices in it and the linking Key. Can I ...
2
votes
2answers
2k views

Recovering a lost datafile with no backup available

How do you recover a lost datafile if: the database is running in archivelog mode there is no backup is available
2
votes
1answer
1k views

Recovering from the loss of datafile in NOARCHIVELOG mode?

How do you recover from the loss of datafile if the database is running in NOARCHIVELOG mode?
1
vote
1answer
3k views

Oracle Select with xmlquery() error - How to ignore errors?

In trying to extract a subset of data from a Oracle DB table, one of the columns is XMLType, which is extracted with xmlquery() for relevant information. The problem is that the XML data is from an ...
2
votes
2answers
1k views

Why do shadow processes exist?

Oracle architecture has two types of process: server process or foreground process and background process, but: Some people use it to refer to foreground processes, others use it for background ...
1
vote
1answer
191 views

What signals do the DBWn processes send to LGWR?

I would really like to know what signals are in the following quote from the Process Architecture docs, and how does DBWn know LGWR has completed? Before DBWn can write a modified buffer, all redo ...
0
votes
2answers
256 views

Oracle remove and place (re-install) database on 10g

I need to put together a plan to execute some change scripts to a Oracle 10g database, which will add some values, change some values a drop a table and create a new table. I have a step for creating ...
2
votes
1answer
166 views

Locking records in Oracle during update

I had a deadlock issue which was easy to fix by changing application logic, but I was under impression Oracle would behave differently, and the deadlock would never happen. I have two tables, for ...