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
0answers
61 views

Combine Oracle locator instance with Oracle spatial instance with db link

we plan to have two oracle databases, one with oracle spatial installed, the other one just has the locator option. Is it possible to create an oracle database link between the two databases in order ...
1
vote
0answers
5k views

Could Oracle ORA-08103 'object no longer exists' error be caused by size of undo_retention parameter?

Had a once-a-day long running data warehousing procedure that I had written that was failing about 50% of the time. Logs were showing ORA-08103 'object no longer exists'. ORA-12012: error on auto ...
1
vote
0answers
277 views

Oracle TOAD and Team Coding with TFS: Unable to get revisions from TFS

My company is currently exploring the option of using TOAD as a means to seamlessly allow developers to check-in/check-out code in TFS. This would be seeded by our packages, stored procedures, etc. ...
1
vote
0answers
141 views

Pass in dynamic value to Oracle job scheduler

How does one pass a dynamic value into the oracle job scheduler when the underlying command is a stored procedure? example procedure: create procedure foo (bar varchar2) ... Job creation in ...
1
vote
0answers
499 views

Restoring Oracle prod backup to test server with new database name

I need to restore an Oracle production database (aaprod) to a test server that already is home to a test database (aatest) under a new name (bbtest). I have a cold backup of the production database ...
1
vote
0answers
503 views

How can one reliably update a LOB column with data from another LOB column in Oracle?

I have tried: UPDATE "SCHEMA".TABLE SET LOB_COLUMN = (SELECT LOB_COLUMN FROM "SCHEMA".TABLE) I have tried: CREATE OR REPLACE PROCEDURE COPY_LOB_DATA IS OLD_BLOB BLOB; NEW_BLOB BLOB; ...
1
vote
0answers
270 views

Oracle server session terminated by fatal error

I have an Oracle server running on Windows Server. When an INSERT statement runs I receive an Oracle Ora-00603 error. The insert statement just tries to insert a BLOB into a table. I searched the ...
1
vote
0answers
131 views

Use of hash functions in group by?

I'd use a listagg() to generate a list of components a certain customer has and compare it to another list generated the same way somewhere else to detect inconsistencies. The problem is that ...
1
vote
0answers
395 views

Which oracle (10g) template files (DBCA) can be be copied to different server for cloning?

I am trying to clone a schema from one Oracle 10g server to a different Oracle 10g server. I have created a database template (DBCA) from an existing database (structure and data). I have copied ...
1
vote
0answers
579 views

Connection to MS Access from Oracle over a DB Link

I need to establish a connection between a MS Access database, which is placed on a network share on a windows box, and an Oracle database on a Unix Box. I need to query the Access tables from the ...
1
vote
0answers
2k views

ORA-00449: background process 'MMON' unexpectedly terminated with error 448

I got the follwing error while running a query from Java: The database returned the following error: [Oracle] #11 ORA-00449: background process 'MMON' unexpectedly terminated with error 448 [Oracle] ...
1
vote
0answers
588 views

How do I import a dump for a deleted tablespace?

I'm trying to import a database dump, however I am encountering this error: ORA-39083: Object type TABLE:"MYSCHEMA"."MINF" failed to create with error: ORA-00959: tablespace '_$deleted$5$0' does not ...
1
vote
0answers
131 views

XML parsing failed

I'm using a query on a oracle db which extracts values from clobs using the xmltype function and an xpath. Unfortunately the query fails and reports a 'XML Parsing failed'. I assume that one of the ...
1
vote
0answers
143 views

Problem with SDO_AGGR_CONCAT_LINES in Oracle

I have a line consisting of 3 segments A, B & C A touches B at just one point, likewise for B & C The SDO_AGGR_CONCAT_LINES function returns a MULTILINE object (GType = 2006) rather than a ...
1
vote
0answers
89 views

Dealing with Invisible Referencers

Using Oracle database, suppose I have a parent table parent defined in schema A, and a child table child defined in schema B. To achieve this, schema A granted references privilege on parent to schema ...
1
vote
0answers
487 views

FATAL ERROR IN TWO-TASK SERVER: error = 12571

oracle9i/windows2003,java application. oracle crash, alert log file contains sdh_ora_4636.trc which contains: *** 2012-05-05 13:53:32.000 *** SESSION ID:(100.50539) 2012-05-05 13:53:32.000 FATAL ...
1
vote
0answers
453 views

ORACLE SSL using Microsoft Certificate Store for PKI

I am trying to set up PKI SSL authentication between client and server using a Microsoft Certificate Store. Client: Windows 7 64 bit with Oracle client 11.2.0.3.0 Server: Windows 2008 R2 64 bit with ...
1
vote
0answers
56 views

Diskless Oracle and persistent filesystems

I'm putting together a diskless Oracle database SLES image. What will need to be kept stateful? For example, what filesystems need to persist? Right now, the easy ones I know of are /home, /perf ...
1
vote
0answers
57 views

sdo_tune.quality_degradation returning negative values

While running the sdo_tune.quality_degradation function on one of our Oracle databases most of the results were around 1 but a number had values like -556127.225. Does this mean that these indexes ...
1
vote
0answers
171 views

Can not open oracle 10g database when migrated from oracle sql developer 1.5x to 3.1x

I have migrated from Oracle sql developer tool 1.5x to 3.1x and imported my connection settings with database 10g. When I try to open a connectionstring in the developer tool I get this message: ...
1
vote
0answers
53 views

What patch(es)/feature(s) to Oracle provide the column avg_hard_parse_time on v$sqlstats?

I have some profiling scripts which work in some environments, but not others; the odd thing is that it doesn't seem terribly consistent across versions, so I'm guessing there's some patch or feature ...
1
vote
0answers
585 views

FREETEMPORARY on blob with no reference

In Oracle 11g, we are using XMLELEMENT to get records from tables. The problem seems to be, however, that we are calling SELECT XMLELEMENT(...).getClobVal() from DUAL; which is eating our temp ...
1
vote
0answers
757 views

What can cause [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused.?

The Title speaks for itself. We have this error message on the client side of the application. The devs suspect a problem on the database. The alert log on the database shows no errors at all. The ...
1
vote
0answers
90 views

Question on Oracle database table compress option?

How come a compress enable table (name as ABC) when created (Oracle 11g R1), but after merging with a partitioned table's partition with data which is not compressed, then the table (ABC) auto ...
1
vote
0answers
468 views

Error starting up OC4J_EM: java.sql.SQLException: Logical handle no longer valid

I'm trying to launch the OPMN-managed process OC4J_EM, which is needed for Oracle's Enterprise Manager. When I run use the startall or startproc command, I get an error: failed to start a managed ...
1
vote
0answers
754 views

Which packages are required to install Oracle 11.2.0.3 on Solaris 11?

Where can I find information on which packages are required to install Oracle 11.2.0.3 on Solaris 11? The documentation only mentions Solaris 10. I tracked down the packages required for Solaris 10, ...
1
vote
0answers
2k views

Convert the Highvalue of user_partition in varchar2

I have a requirement where I would like to use the HIGH_VALUE field of user_partition table as a Varchar2 or TimeStamp value and I would like to get it used as a Function in SQL Query. Something like ...
0
votes
0answers
17 views

how to update 'update trigger fired record's column?

I'm new on this task. I tried to update when I/F table insert after trigger. but it wasn't work.. There is my trigger source like.. create trigger T_ATABLE_I after insert on ATABLE for each row ...
0
votes
0answers
24 views

How to cast as type of a table column?

I have multiple views with union like this: select column1, column2 from mytable union select cast(extcol as nvarchar2(15)), cast(extcol2 as nvarchar2(10)) from exttable But later I change the size ...
0
votes
0answers
22 views

How can I use Oracle's CONNECT BY PRIOR to only get specific revisions of hierarchical records?

I've got a table schema in Oracle 11 which is storing records that are linked together. The table schema is roughly like this CREATE TABLE "SOMEDATA" ( "ID" INTEGER NOT NULL, "ITEMNAME" ...
0
votes
0answers
28 views

create_index_cost used_bytes vs alloc_bytes

I'm reading a lot about create_index_cost, but I can't seem to find out why there is such a discrepancy between the size of used_bytes and alloc_bytes. I know what each parameter means, but why is ...
0
votes
0answers
48 views

Help with Joins - Cartesian Product

I have 5 regions that each contain 1 store and 1 warehouse. I have a table that contains the regions and corresponding stores and warehouses. I also have a table that lists the inventories of both ...
0
votes
0answers
45 views

Rows to columns

I am new to Oracle. I know MySQL. I wrote below query in MySQL: Tables: CREATE TABLE agl_asset ( asset_id BIGINT(20) NOT NULL, caption VARCHAR(64) DEFAULT NULL, description VARCHAR(4000) ...
0
votes
0answers
35 views

Oracle 12G Merge subpartition data into partition

I have a Oracle 12G table which is interval partitioned (monthly) and list sub-partitioned. There is no longer a requirement to sub-partition the table and hence I would like to "merge" the data in ...
0
votes
0answers
91 views

Oracle - Slow queries without prepending schema name or providing hint

I am logged in as the schema owner in Oracle 11gR2 on Linux. I have 55 million rows in table. select max(col) from table; - takes 300 seconds (index full scan) select max(col) from schema.table; - ...
0
votes
0answers
37 views

How to compare between two values in one field depending on another field in SQL* / Oracle Reports?

I have three fields in a table named table_family. One is "relation" it has 3 kinds of values 1 for person, 2 for parents, 3 for son. Other field is "age" and it contains the ages of all the ...
0
votes
0answers
40 views

How to store values from a loop and compare them?

I have to select child items from a parent item and then compare text of each child and if the text is same I should not be displaying the heading. I have written a procedure for this, which is like ...
0
votes
0answers
42 views

ETL - Moving data from Postgres/Oracle to a TripleStore (RDF)

I'm looking for pointers on how to handle an ETL process that I have to implement for my organization. I know how to query SQL database but i'm not SQL DB specialist. I work more in the sphere of the ...
0
votes
0answers
21 views

Accounting - Dimention table in mysql

I am designing a accounting and mini erp system. I use a date dimension table to track all date related data. In oracle we can have many schema for a database. so we could create each schema for ...
0
votes
0answers
35 views

Unique Constraint exception after dropping constraint

We had dropped a unique constraint using the ALTER TABLE DROP CONSTRAINT script, but it is still throwing the Unique Constraint exception while trying to insert. We drilled this down to two possible ...
0
votes
0answers
26 views

Required Information to start oracle warehouse builder

I am using windows 8 64 bit . I want to install Oracle Warehouse Builder on my system. I have installed Oracle 11g and come to know that Warehouse Builder is already a part of it. But when I start ...
0
votes
0answers
18 views

parsing and purpose of oracle audit (.aud) logs

I am looking at the oracle audit logs and am trying to understand and parse. The format appears to be consistent: Date Length: Action: ...etc My questions are: 1) what generates these? Is it ...
0
votes
0answers
20 views

Oracle 11g - Matrikon opc server

I need to connect MatrikonOPC client for ODBC with an external database on Oracle 11g in a Windows Server 2003. This is for passing information to the database. I have all the info of the database. ...
0
votes
0answers
10 views

Fusion Middleware Clone

I am trying to automate the installation of fusion middleware. Can I clone an exisiting fusion middleware installation that is fully functional onto another host and then change various configuration ...
0
votes
0answers
46 views

SQL Loader data load in multiple tables

I have a question regarding SQL*Loader : We are loading 40 tables from external files using sqlloader; if data load fails and only 30 tables are loaded, is it possible to start load from 31st table ...
0
votes
0answers
38 views

Update on table deletes the record

I'm having a problem in my oracle database, I have a table PAYMENTS which has an ID (PK) and when I want to update a record: UPDATE PAYMENTS SET AMOUNT = 2000 WHERE ID = '1'; The record with ID = ...
0
votes
0answers
31 views

ORACLE Query error contains lots of caret at symbols (i.e. ^@^@^@)

I made a query using Oracle DB, and the error contains the error code, followed by several thousand ^@ symbols. This would look like: Error at query 298 ORA-00942: table or view does not exist ...
0
votes
0answers
43 views

How to make sqlplus output appear in one line when running using shell script?

For example i have an output as below : exec dbms_stats.gather_table_stats(ownname =>'ABC',tabname=>'XYZ', no_invalidate=> FALSE, estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt=> 'FOR ALL ...
0
votes
0answers
64 views

Oracle 11 express vs Oracle 11 enterprise performance

We have a very long select query which is executed via our java application through hibernate. This takes 2 seconds to execute on our local Oracle 11 express db server and takes around 22 seconds on ...
0
votes
0answers
82 views

ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)

I have an Oracle Enterprise Edition as a source and taken the dump using the oracle data pump(expdp) and the dump is imported using (impdp) to an Express Edition of Oracle. The import was working ...