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

3
votes
3answers
180 views

Nested table as condition prevents using index

The following query joining a subquery does a TABLE ACCESS FULL when the master-table uses nested table as condition. When the condition is a simple =, the same query does an INDEX RANGE SCAN as ...
0
votes
2answers
79 views

Difference Between SELECT and select in oracle sql

The algorithm used to find SQL in the library cache is based on the ASCII values of the characters that make up the statement. Means The SELECT instead of select statement will be parsed again ...
-1
votes
3answers
64 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 ...
0
votes
0answers
258 views

execute .sql script inside an anonymous pl/sql block which is invoked by a shell script

I got a shell script which connects to SQLPLUS and executes the .sql file like below: read a x=`echo $a | cut -d , -f 1` y=`echo $a | sed 's/.*,//'` c=`echo $USER | cut -c -2`"OPR"`echo $USER | ...
0
votes
3answers
1k 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 ...
2
votes
1answer
35 views

Specifying Oracle Service Name in UNIX Profile

Is there any way we can specify Oracle Service Name in UNIX Profile? I know that there is an environment variable ORACLE_SID for specifying SID in the Profile, But how about service name? If there ...
0
votes
2answers
51 views

Dynamic permissions

I have a application that creates tables in one user's schema and another user needs to be able to use the dynamically created tables. Example: Application creates User1.RandomTable User2 needs ...
0
votes
1answer
37 views

Oracle service names with a minus sign (?)

Are there any reasons not to use minus signs/dashes/hyphens in Oracle service names? DBMS_SERVICE, tnsping and sqlplus seem to be fine, but the documentation says no. We are switching from Oracle ...
1
vote
3answers
198 views

Remove ORA-01100:DATABASE ALREADY MOUNTED

I am using Oracle 11g and there is a database create during installation name "xyz" and user "xyz".Now i created a user 'abc' and gave following permission to abc. "CREATE SESSION, ALTER SESSION, ...
0
votes
3answers
54 views

What is the EXPORT privilege on ORACLE

I have created a user say A. I want to export some of my schemas using A user. For example, I have B and C users. I want to export B schemas using A user. Which grant do I have to use? I am using ...
1
vote
2answers
32 views

Aggregating on a repeated group

In a current report, I'm trying to track the migration of a person from department n, to n+1, or to n+k. My data is split into a row per term (university data). An example: dept | term ...
1
vote
2answers
21 views

Update row where associated row does not exist

Given the table named ROLE: role_id[PK] NUMBER role_name VARCHAR2 Using only SQL (no PL/SQL) how would I write a MERGE (or UPDATE?) statement that would update the role_name as below, but only ...
0
votes
1answer
31 views

Output another word instead of the word in the table in a query

Suppose I have a table where I have a field which can have to values: "enabled" and "disabled". Suppose want my query to output "unblocked" instead of "enabled" and "blocked" instead of "disabled". ...
0
votes
1answer
101 views

Migrating stored procedure from Sybase to Oracle having temporary tables

I am migrating a few stored procedures from Sybase to Oracle using Oracle Developer tool. The tool migrates alomost 70%-80% of the stored procedures except a few cases where there is a temporary table ...
1
vote
1answer
109 views

Why is this second query more expensive than the first?

While reading Graph Databases book, I came across this excerpt: I can't figure out why the second query is more expensive than the first. Indeed, both filter on the Bob person. May anyone ...
0
votes
2answers
81 views

Getting error while running dbca command as oracle user on linux, please help me on this

could someone please help me on the below error to get ride of it: [oracle@localhost ~]$ dbca UnsatisfiedLinkError exception loading native library: njni11 java.lang.UnsatisfiedLinkError: ...
0
votes
1answer
69 views

Oracle average active sessions high threshold

I am trying make sense of the DB load from the AWR report for a period handed over to me by DBA. Researching a bit, I see the "Average active sessions" is a metric widely used to measure DB load. It ...
0
votes
1answer
52 views

Table statistics on database

Is there any way that I could find how many tables has statistics on them,and how many tables which doesn't have statistics on them.
1
vote
1answer
101 views

Pass the unix variable to the ddl command inside a pl/sql block

I would like to create a db link dynamically, using the input given in the unix session. i.e. the remote db name and db instance would be given by the user, in unix, which are VAR1 and VAR2. Now, from ...
0
votes
1answer
78 views

Oracle 11g not allowing to connect to. Error ORA-01122: database file 1 failed verification check

I am running Oracle 11g on Windows 7 Enterprise SP2 16 GB RAM, 1 TB HD. I can connect to Oracle using SQL Plus (see below), C:>sqlplus sys/xxxxxxxxx@XE as sysdba SQL*Plus: Release 11.2.0.1.0 ...
0
votes
1answer
26 views

What is a construct in Oracle?

I'm currently studying Oracle Architecture and Database Memory Structures. I'm a newbie in the subject and I just read that a "Shared Pool" is "a data structure that caches various constructs that can ...
-2
votes
1answer
61 views

Can I install MySql and Oracle 10g both Databases in same machine? [closed]

I have MySql Installed in my windows 7 machine and PHP on IIS. Now i need Oracle 10g anyway.I'm having king of dilemma to install Oracle 10g. If i can do so please suggest necessary steps and ...
0
votes
1answer
87 views

Cannot remotely connect to oracle express

I have installed Oracle Express in a oracle-6.5-x64 virtual machine (let's called it host). The installation went fine, I am able to connect and run commands using SQLPlus from the host. Now I'm ...
0
votes
0answers
34 views

Multiple rows to single row diff column

I have the following data: customerid ID_number 123 a1112 123 a1113 And my desired output is: 123 a112 a113 How can I accomplish that?
0
votes
1answer
38 views

Java-Hibernate-Oracle: Can a fluctuating DB connection duplicate insert statement?

  Is it possible that a fluctuating DB connection causes insert statement to execute multiple times? Thanks
0
votes
0answers
32 views

Oracle right outer join SELECT statement with a table

I am trying to find out the tables that are in MONITORING.USAGE_TRACKING table in first place, along with the other tables that need to be analyzed. SELECT A.JOB_NAME, A.START_DATE from ...
0
votes
1answer
66 views

ORA : 12519 No appropriate Service Handler

Sorry if my question has already been asked many times but I spent two days trying to solve it. I have a machine in which I had an Oracle database. Everything was working propertly until I added two ...
2
votes
0answers
109 views

Use LDAP for name look up with Oracle Instant Client

Partly as a result of having problems with conflicting versions or bitness with the full installation of Oracle client, my development team (of which I'm a member) has been moving towards using Oracle ...
0
votes
0answers
19 views

How to find out duplicate rows by using oracle 10g forms

I have developing one form by using oracle 10g for MRP changing.Here By using XL file upload that MRP will be changed.I have given that file model for you people.If my file have same Item but ...
0
votes
1answer
352 views

ORA-00227: corrupt block detected in control file

I am getting the following error while starting the sqlplus (I am using Oracle XE 11.2.0) ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0 So, I ...
-1
votes
3answers
77 views

Full table scan even after adding index

i have two tables in Oracle 11g server one is partitioned and another is having a 3GB of data. I've added a composite index on both the tables based on the where clause, in the order it appears. The ...
0
votes
1answer
35 views

Oracle: Replace corrupted first datafile

A datafile associated with a tablespace has been corrupted (got truncated to size 0). I don't mind losing the data, because I have a full DB dump which I can import. Now I want to replace this ...
2
votes
2answers
49 views

Is there a good way to select a row where the key represents the lower bound of a range?

I am designing some tables and a number of the tables have as the key a lower and upper bound which never overlap. I want to query by a value that can fall withing any of those ranges. If I keep both ...
0
votes
2answers
47 views

Find status of shutdown immediate

I just issued a shutdown immediate command, and it's taking a lot of time. Is there any way, I can find the status of the shutdown task in terms of percentage completed? Or, any kind of status update. ...
0
votes
0answers
39 views

How best to export from Oracle Ent Ed (EE) to Oracle Express Edition (XE)?

I am aware that Oracle Ent Ed (EE) has more functionality than Oracle Express Ed (XE). But I would like to do a FULL export from EE to XE. Is this even possible? The only solution I can assume will ...
0
votes
2answers
178 views

BASH: DBCA: command not found

When I use dbca command as Oracle 11g user I have the following error message: BASH: DBCA: command not found and when I checked the bash profile I found the following: # .bash_profile # Get ...
1
vote
1answer
76 views

Oracle Patching & Database Upgrade - Which Order

I have an Oracle instance running 11.2.0.2.0: SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Release ...
1
vote
1answer
75 views

Oracle 11G R2 install using separate instances or multiple schemas in a single instance

I am in the middle of a server upgrade, and have finally come to the conclusion that I need a very important question answered. I would like to inform everyone that I am a novice to Oracle ...
0
votes
1answer
182 views

Invalid date format in SSIS

I am using BIDS to export data from Oracle to SQL server. I am using OLEDB source and destination. I have around 6 datetime fields in ORACLE out of which two fields give no problem while 4 fields give ...
0
votes
0answers
25 views

How to write stdout or stderr to a particular file when using oracle dbms_scheduler to run external job?

I create a job like BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'job_testing', job_type => 'EXECUTABLE', job_action => ...
0
votes
1answer
30 views

Need DDL for an Oracle Table that would be 1 row = 1 8K Block

For performance testing in our performance environment we want a means to turn over SGA the way production does. Our performance environment is a fraction of production and production's very nature ...
0
votes
2answers
47 views

Oracle conditional statements

I am making a report, and I am trying to do following: If the value of the field is NULL, output empty string. Another words, I don't need the word "null" to be output to the user, just empty string. ...
1
vote
1answer
75 views

How to export a MySQLtable with a longBLOB column to an Oracle database?

In MySQL I have a table: Select * from Dummy; Columns like below: id name salary binary_col 1 a 100 A.pdf 2 b 200 b.pdf 3 c 300 c.pdf 4 d 400 d.pdf 5 e 500 e.pdf ...
0
votes
0answers
37 views

Oracle Archiving deleted rows via trigger and trigger logging if error

I created table in new schema/user CREATE TABLE archive.table1 ( id NUMBER(10), name VARCHAR(45), created_at DATE, updated_at DATE, deleted_at DATE ); I granted access to that table for ...
-1
votes
1answer
160 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
vote
3answers
332 views

What's the most efficient UUID column type

For storing a 128 bits UUID there are multiple storage options: a byte[16] column two bigint/long(64 bits) columns a CHAR(36) column - 32 hex digits + 4 dashes. a UUID database specific column, if ...
0
votes
1answer
24 views

What is the “other miscellaneous information” in the Shared Global Area (oracle database)?

I'm studying Oracle database ,and it says here that the SGA contains these data structures : Database buffer cache Redo log buffer Shared pool Java pool Large pool (optional) Data dictionary cache ...
0
votes
1answer
66 views

Restore an oracle dmp file

I've been given an oracle DMP file that was created on a solaris system which I need to restore to a windows system. I've created the DB with the correct blocksize, but when I try and do the restore ...
0
votes
1answer
60 views

Oracle Enterprise Manage “CPU utilization” is confusing

When I display the CPU utilization in the Enterprise Manager (in the Performance tab), there is a big discrepancy between the graph that shows the utilization and the table that shows the operating ...
0
votes
1answer
60 views

Update previous value field

I inherited a database that has multiple tables that contain some form of an object ID, a date, and a value. The metrics depend on comparing the current value on any given date to the previous value ...