All versions of Oracle. Also add a version-specific tag like oracle-11g-r2 if that context is important in the question.

learn more… | top users | synonyms

1
vote
1answer
4k 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
503 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
1k 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
175 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
175 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
23 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
86 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
104 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
922 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
617 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
4k 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 ...
3
votes
1answer
183 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
73 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 ...
2
votes
1answer
14k 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
76 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
5k 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 ...
1
vote
2answers
168 views

SQL*Plus save current COLUMN settings

In SQL*Plus, is there a way to save current COLUMN settings similar to STORE which saves SET commands in a script? COLUMN can be used to list the settings, but they are not in script format.
2
votes
1answer
242 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
201 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
1answer
106 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
1k 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
104 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
vote
1answer
353 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
170 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
469 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?
0
votes
0answers
69 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
3k 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
2k 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
135 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
61 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
264 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 ...
0
votes
1answer
85 views

General question on dbms_stats

General question on dbms_stats and auto sample size? what is the impact of having IOTs with overflows and you switch to auto_sample_size and enable approximate NDV . How does it impact?
0
votes
1answer
48 views

Possible Inconsistency Among System Tables

Is there a reason that there would be a significant difference in the number of records in the DBA_USERS table and the USER$ table?
1
vote
1answer
190 views

Can I run DDL in pretend mode in Oracle

I have a script to drop several objects in the database (including queues) -- when it partially fails I need to recreate the objects that have already been dropped to continue testing the script. For ...
1
vote
2answers
10k views

What is the difference between Schema and Database in Oracle?

In oracle, Datafile are system files where actual data is stored.The collection to datafile make Tablespace and atlast database is collection of tablespaces Correct me if I am wrong on the concepts ...
1
vote
0answers
116 views

Testing equivalence in strings with different character sets

I have to synchronize a number of tables with string columns between two databases: the source Oracle 10.2.0.3 NLS_CHARACTERSET WE8MSWIN1252, NLS_LENGTH_SEMANTICS BYTE the destination Oracle ...
0
votes
0answers
199 views

Running DBMS_AUDIT_MGMT package under other user than SYS

I want to run DBMS_AUDIT_MGMT package under user CENTRUMADMIN. But error occurs even when I try to run this part of code: BEGIN DBMS_AUDIT_MGMT.init_cleanup( audit_trail_type => ...
1
vote
2answers
167 views

Table design for multi-type data

The information model I am modelling from includes an "any type". For example a customer can have zero or more 'entries' each of which can have a number of values. Each value could be a either date, ...
3
votes
1answer
2k views

Oracle TimesTen vs Oracle database in-memory

Oracle has recently announced its latest Oracle database in-memory feature in 12c. Oracle already had an in-memory database TimesTen and now I was wondering as to what the the differences between ...
-1
votes
2answers
892 views

use of synonyms in oracle

I want to know the usage of Synonyms in oracle.I have searched in internet there i have learned like synonyms will be created in one schema and we can use that in another schema. But still am not ...
1
vote
0answers
197 views

How to ensure on Oracle RAC One Node that the OWB control service is started on the active node after a planned relocate or unexpected fail-over? [closed]

I followed the document 'How To Install a Warehouse Builder 11g Repository on a RAC' (Doc ID 1571166.1) to set up the OWB repository (11.2.0.4) on my Oracle RAC One Node system. Because it's a RAC One ...
2
votes
1answer
224 views

Oracle database startup fails several times. Giving ksvcreate

Last night my production server database (ORACLE 10.2.04) was showing me number of connection exceeded as some times it show me. Then as usual I shut down abort my database then at the time database ...
2
votes
2answers
275 views

Design of an application log database

We are generating logs like following example(this is a table no actual pipes): 2014-06-10 09:00:03.457 | Channel1 | Operation3 | Function15 | 15ms 2014-06-10 09:00:08.245 | Channel2 | Operation5 | ...
0
votes
0answers
64 views

What are the key points while using Oracle12c as application database

We want to use Oracle12c database as the default data store for our application. We would not be using the plugable database features ; only single instance standalone database. The database would be ...
0
votes
2answers
801 views

How to get next value of Sequence dynamically in Oracle

I used to a SQL guy and trying my hands on Oracle front. I am getting dynamic values of sequence in a variable. I like to fetch next value for that sequence object in some output variable. How to ...
2
votes
1answer
1k views

Does Oracle run queries to completion after SQLdeveloper disconnects?

The query is a CREATE TABLE t as SELECT .....; statement. Can I reliably count on Oracle to complete this after I disconnect? After I re-connect, how can I check on the status of this query?
1
vote
1answer
206 views

How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously

I have two servers, Oracle and SQL-Server. I have same database on both the servers. I want to perform DML (insert,update,delete). How can I perform same DML statements on both the servers ...
4
votes
1answer
253 views

How can I prevent having inconsistent data under isolation level serializable in Oracle SQL?

I have the following table: InStores +--------+---------+-----+ | ProdID | StoreID | qty | +--------+---------+-----+ | p1 | s1 | 25 | | p1 | s2 | 70 | +--------+---------+-----+ ...
0
votes
0answers
456 views

I use sqlDBx to connect oralce 12c, cannot connect

My computer is 64 bit.The sqlDbx that I am in the official website to download. I am a Chinese, hope ace to help me,thanks a lot !
1
vote
1answer
44 views

Is there a way to use Oracle XE as an easy-rollback “proxy” to regular Oracle [closed]

For development, we're currently connecting to shared dev databases that are way too big for XE (some are 100s of GB). Is there a way to set it up so that we can have a local XE on each developer's ...