Tagged Questions

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
107 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
67 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
266 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
440 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
28 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
99 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
109 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
70 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 ...
0
votes
0answers
3k views

ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64

Im starting to be very very frustrated by this Oracle. So, I have installed Oracle XE 11.2 64 bit and ODAC121012_x64. I can start listener, I can do tnsping xe, but when I try to connect as via ...
0
votes
0answers
68 views

Trying to run a shell script from dbms_scheduler . Throws error no matter what the script is?

I am trying to run a shell script from a dbms_scheduler but am getting a bunch of errors :- the job defn :- BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_prog', ...
0
votes
1answer
122 views

Unable to create Central Inventory

I am Traying to install Oracle 11g on my Linux a have alrady config the varible and X-host but can,t able to Create Central Inventory my Central Inventory location is : /u01/app/u0 ** and ...
0
votes
1answer
134 views

The best way to query a partitioned table in Oracle

I have a table in an Oracle database, partitioned by a field. In our application we need to query data that is scatered across 2 partitions. Can you please tell me which method is better: making ...
0
votes
2answers
117 views

Not able to connect to non-default oracle database after reboot

I have installed Oracle 11g r2 on Centos. On initial setup it installed database named INFA for me.I setup listener.ora and tnsnames.ora for INFA and on reboots all I had to do was run lsnrctl start ...
2
votes
0answers
107 views

How to avoid hardcoding a database link name in a package body

I have a PL/SQL package that copies data from a remote DB2 database using a database link. To keep the package configuration-independent I wrapped the remote table in a view. But a single field in a ...
1
vote
1answer
305 views

Using Oracle12C Client with Oracle11.g database

I have been using Oracle12c client to connect to an Oracle11g database in a remote server for about one month, it wasn't giving me any problems until this week, when I started getting the error: ...
0
votes
1answer
35 views

Using oracle easy connect does it really connect to the remote DB?

I tried connecting to remote host db using : sqlplus abc/abc@hostname1:1000/ABC And tried printing !hostname it still shows me local hostname from which I am running and not HOSTNAME1. So if ...
1
vote
1answer
419 views

SQLNET.ALLOWED_LOGON_VERSION=12 and JDBC thin client

To fix password security issues we need to set SQLNET.ALLOWED_LOGON_VERSION=12. According to the Oracle Database Net Services Reference: Note the following implications of setting the value to ...
1
vote
1answer
163 views

ORA-02070: database does not support antijoin in this context

I don't think this is even a question, but in case someone has seen something like this before or has any thoughts besides 'file a bug with Oracle' (which I'm doing), I'd love to hear it. create ...
-1
votes
1answer
173 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
vote
2answers
134 views

Can I get some rationale from the Optimzer why it chose a certain explain plan?

This is not about reading an explain plan. This is not about adding any hints or measuring performance of a specific query. I have always been wondering whether it's possible for a given explain ...
0
votes
0answers
76 views

Why does second instance of database not open?

SQL> startup ORACLE instance started. Total System Global Area 3841982464 bytes Fixed Size 2025392 bytes Variable Size 788531280 bytes Database Buffers ...
0
votes
0answers
21 views

Why does second instance of database not open? [duplicate]

I have an instance called "test" of a database. I want to create a second instance called "orcl" of the same database on the same machine. I have created the second instance and made changes to ...
0
votes
2answers
43 views

Should I create separate table or have the information as columns in the same table

Sorry for the title but I could not find anything better that could suit my needs. I'm designing the database of a Document Management (Circulation) application. There are two types of documents - A ...
1
vote
1answer
51 views

Mutating Error , How to solve it

CREATE OR REPLACE TRIGGER LOAN_RP AFTER INSERT OR UPDATE ON FUND_DISBURSE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE V_FA FUND_DISBURSE.FUND_AMT%TYPE; V_RC NUMBER (10); ...
0
votes
1answer
207 views

ORA-00907: missing right parenthesis on query with subqueries

I am getting ORA-00907: missing right parenthesis for the following query: SELECT PEOPLE.NAME FROM CLIENTS K INNER JOIN PEOPLE ON K.ID_L = PEOPLE.ID_L WHERE NOT EXISTS ( (SELECT DISTINCT ARTIST.ID_U ...
0
votes
1answer
67 views

Insert Into does not work with multiple rows

Here Is my code : CREATE OR REPLACE TRIGGER LOAN_RP AFTER INSERT OR UPDATE ON FUND_DISBURSE REFERENCING NEW AS NEW OLD AS OLD DECLARE V_FA FUND_DISBURSE.FUND_AMT%TYPE; V_RC NUMBER ...
0
votes
1answer
55 views

Why is it necessary to type “host” before the imp command when I'm using SQL*Plus to import a dmp file into Oracle?

In SQL*Plus, I'm connected to an Oracle 11g database. When I type imp help=y It gives me SP2-0042: unknown command "imp help=y" - rest of line ignored. But when I type host imp help=y it ...
0
votes
1answer
235 views

Move Oracle database to new server

I have a Oracle 11g R1 Standard Edition database on production server working on Windows 2008 R2 SE. Unfortunately server it not working properly (os/hardware failure) and I need to move it to ...
1
vote
1answer
67 views

How to create a function(table_name) that return a collection in Oracle?

I need to create a function in Oracle that accepts a table name and return a collection the content of which is based the table that accepted. I've been doing some search, many examples are of the ...
0
votes
0answers
40 views

How can I enable audit on selected accounts only to know where they logged on from?

I want to audit certain DB accounts (the ones used for applications), to know which machine the user is logging on from. To save space, I don't want to enable this audit for every account in the ...
0
votes
1answer
620 views

Connecting to SQL Server using Oracle SQL Developer

I am using oracle sql developer to manage my oracle database. I recently added third party database jdbc drivers to be able to connect to my new MySQL and SQL Server installations. I need help with ...
1
vote
2answers
55 views

Time elapsed Calculation

I need to calculated time elapsed for each user to perform his part in a transaction. The sequence is: 0 -1 - B2 or 0-B3 The table looks like the following: ...
2
votes
1answer
326 views

Error Creating Foreign Key in Oracle

I have 2 tables: PRODUCTS PREFIX SUFFIX ATTR1 ATTR2 ----------------------------------------------------- 001 AAA 50 100 001 BBB 20 300 010 ...
2
votes
1answer
72 views

Running a query over the network multiple times seems to choke performance, how can I pinpoint the problem?

Background: Oracle 11g running on Windows 2003 x64 SP2 on a 3.06GHz Xeon X5675 with 16GB RAM Over the past 3 weeks, a query I used to run approximately every 5 minutes has started to respond very ...
0
votes
1answer
93 views

SQL query for all combinations without repetition

I need a function for calculating combinations without repetition from a list. Example: I have a list of names e.g. Tom Bob Paul Tina Now I need a list of 3 names out of the 4 without having a ...
0
votes
0answers
43 views

Migrate from mysql to oracle

I'm trying to migrate a db from mysql to oracle, I'm trying to follow the videos from the official page of oracle: Here! But I have a doubt, when I'm trying to do the step of "translate" I don't have ...
0
votes
1answer
33 views

What is the distinction between ALL_PROCEDURES and DBA_PROCEDURES, and other schema tables?

I recently failed to find a known procedure when searching ALL_PROCEDURES, and on a whim tried DBA_PROCEDURES: lo, there it is. The doc pages (ALL_; DBA_) both say "...lists all functions and ...
0
votes
1answer
204 views

Login / Password for Oracle Enterprise Manager in VM template?

I want to setup Oracle Enterprise Manager to access our development Oracle databases. I downloaded the following VM template from https://edelivery.oracle.com/EPD/Search/handle_go Oracle VM ...
0
votes
0answers
47 views

Low performance oci_execute

I work with a PHP application that connects to an Oracle database. Sometimes, the PHP executes a large query from a large database the page loads for ages (more than 200s). But I've seen something ...
-1
votes
2answers
684 views

How to dump data from Oracle to MySql

In my migration project, i need to dump the data from oracle to mysql. So is there any utility or way i can do this operation? The data dump file in the form of .dmp.
1
vote
1answer
76 views

Oracle RMAN Incremental update or merge questions

1- Does Oracle RMAN support Incremental Update/Merge option for device type SBT ? Or its only supported for Disk ? 2 - During an update/merge operation during the incremental backup, does RMAN write ...
2
votes
1answer
105 views

Is there a way to pass to execute immediate only once a variable but use it several times?

I have a Cursor that gets its data from a script along these lines: OPEN myCursor FOR SELECT value1 AS Value1, myPackage.function1 (value1, :myId) AS Result1, myPackage.function2 (value1, :myId) ...
0
votes
1answer
106 views

Tablespace of an index organized table

I want to find the tablespace of an index organized table with primary key. With dba_segments I can only find the tablespace for the primary key. But how can I find the tablespace for the table?
-1
votes
1answer
6k views

IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer

I have installed Oracle 11g ON a RedHat6 linux instance, by following all the steps mentioned in "http://technologylair.net/2013/08/oracle-11g-installation-linux/#comment-50" I am trying to connect to ...
0
votes
0answers
29 views

Debugging long Oracle queries and identifying offending data for 'Expression type does not match a required type' error

I have a long running query with a large number of complex XQueries. This queries used to work but more recently it is giving me Expression type does not match a required type error. I suspect ...
0
votes
1answer
266 views

How to reference a table from another schema inside a package?

I am using TOAD to create a package in a Schema that I have am owner. My package uses tables of another schema. The package has a procedure that uses a cursor. When I create the package I get ...
0
votes
1answer
77 views

Bypassing Password Verify Function

I am considering making a recommendation to enforce a password verify function that will not allow users to change their own passwords. My understanding of the PASSWORD_VERIFY_FUNCTION in Oracle is ...
1
vote
2answers
58 views

Oracle patching

Hi everyone I'm a student and I need a help with Oracle patch's. My DB 10.2.0.5.0 I don't understand how to check which of CPU and PSU patch's were installed. When I try to use sql select * from ...
1
vote
1answer
39 views

What is the disadvantage of maintaining both row and column table storage?

I just watched Oracle's In Memory database release. I can understand that removing a lot OLAP indexes accelerated the database a bit. But does that really mean maintaining 2 table storages doesn't ...
0
votes
0answers
50 views

increased tablespace but dba_tablespace_usage_metrics order shows same

Although I appear to have solved the problem of the tablespace being full I am perplexed that after altering the the datafile size that the tablespace size has remained the same. What is it that I ...