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
2answers
209 views

Oracle Compatible Parameter to set

Is there any difference in setting the Compatible Parameter to 11.2.0.0 vs 11.2.0.4 ? Are there any advantages / dis-advantages ?
0
votes
1answer
32 views

Oracle: Traversing a graph of my foreign keys?

Given a table, what is a query that will show foreign key constrains, both immediate and nested? I.e. if T2 has an FK on T1, and T3 has an FK on T2, I would like to show T1 -> T2 -> T3.
0
votes
1answer
37 views

ORA-19809 & ORA-12560

Following some maintenance on our server (change raid battery + reboot) my database (Oracle 11g) is not available anymore. I m a newbie in Oracle and I have been through the forum and I can t find the ...
0
votes
1answer
1k views

Oracle Enterprise Manager - Where do I find the error logs?

I'm not familiar with oracle management. The problem is when I try to connect to the enterprise manager through the Web browser I get this error: In english: "Internal Error has occurred. Check ...
0
votes
2answers
9k views

TNS-12535: TNS:operation timeout

I have Windows Server 2008 R2 with Oracle Client 11.1.0.7.0 client installed. TNSPing to 100% available databases (accessible from other machines, i.e. I can do TNS ping to these databases from other ...
2
votes
1answer
198 views

ORA-12528 and ORA-12505 error on Oracle database 11g

It's been one week since I last tried to run my final project that I worked on in my last internship at some banking company. Suddenly, my webapps (Java project) in Eclipse can't start. In the log it ...
0
votes
1answer
2k views

Cannot create an instance of OLE DB provider “OraOLEDB.Oracle” for linked server

i am having a bit of a linked server problem . I created a sql server linked server and it's been working fine for last 2 years and suddenly not working . SQL Server Microsoft SQL Server 2005 - ...
2
votes
1answer
3k views

Oracle program “lsnrctl” is missing after the installation of 32bit Oracle client

I cleaned up my computer for all old Oracle stuff using Uninstall (OUI) and then later used regedit to delete all references to Oracle and then deleted all remains of Oracle directories. I have HP ...
0
votes
2answers
105 views

Different user can not access table

I have sysdba user and with that login I created a number of tables in db. After that I created one more user by login with sysdba. But this second user can not have access of tables that has been ...
0
votes
2answers
13k views

“ORA-01017: invalid username/password” : Why is that?

What is the difference between the two : SQLPLUS / AS SYSDBA and SQLPLUS Enter user-name: SYSDBA Enter password: If I use the first command I get connected and see the prompt SQL> but upon ...
0
votes
1answer
24 views

Oracle Database Migration using Oracle SQL Developer

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node Question ...
0
votes
2answers
60 views

Why is Oracle's number datatype so HUGE? and why do I seem to have no alternatives?

Oracle has a favorite numerical class called NUMBER. It is a 22 byte value that just seems ludicrous in an index. I have some values that would easily fit in a 6 byte integer and would therefore fit ...
4
votes
3answers
451 views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
0
votes
1answer
54 views

Can Oracle have too much RAM?

Our database is slow in some very important use cases. I have traced it to a problem with some queries performing full text searches and single row accesses on a lot of records (db file sequential ...
0
votes
0answers
14 views

Only 'SESSION REC' in ACTION_NAME column

I was asked to generate a report of operations performed on certain Oracle 9i tables in a given period of time. When I query the DBA_AUDIT_TRAIL table I only get SESSION REC in the ACTION_NAME ...
1
vote
0answers
33 views

Oracle listener configuration

I have oracle 11.2.0 installed on linux. And I have arcgis server 10.2 on the same machine. I created an geodatabase. But when i try the sde functions like sde.st_asText i got: -ORA-28575: unable to ...
0
votes
1answer
195 views

Linking Oracle 10g XE with SQL server using ODBC

I am connecting Oracle 10 XE with an SQL server 2008 using ODBC in windows 7. I have successfully done following steps: Configured ODBC and test it, runs ok! Configured listener in tnsnames.ora and ...
2
votes
2answers
11k views

insufficient privileges while executing oracle stored procedure?

Im getting insufficient privileges error while executing the following oracle stored procedure. Im using Oracle Database 10g Express Edition. CREATE OR REPLACE PROCEDURE sp_update_acounts( ...
1
vote
1answer
427 views

Internal query on CDEF$ and CON$ very CPU bound

I am checking an application (Infor ERP LN) that loads a lot of data into an oracle 10.2 database. While checking one of the user sessions with SQL_TRACE and its output with tkprof, I found that the ...
0
votes
1answer
54 views

Oracle 11.2 restore DB to a specific point

I should execute following tasks: 1. test system and during test change Oracle data and Create New/Remove Old datafiles and tablespace. 2. at the end of test rollback to behviour before of point 1. ...
0
votes
0answers
16 views

Oracle database as a single synchronization point for two separate web applications [migrated]

I am considering using an Oracle database to synchronize concurrent operations from two or more web applications on separate servers. The database is the single infrastructure element in common for ...
0
votes
1answer
3k views

Can't connect to a Oracle db instance via SQLDeveloper

When I set the connecting information on the GUI in SQLDeveloper I get the following error (everytime!) Status : Failure -Test failed: IO Error: The Network Adapter could not establish the ...
0
votes
2answers
620 views

“sqlplus as sysdba” startup error

My setup: Oracle 11g 32G RAM 8 CUP threads Three oracle instances have been running. But running this: sqlplus "/as sysdba" gives me a prompt: Connected to an idle instance. When I issue ...
1
vote
0answers
45 views

Oracle: built in SQL pretty-print?

Oracle has some packages that will dump objects in SQL format, such as dbms_metadata.set_transform_param. One option that can be set is to "pretty print" the SQL. Is there anything in Oracle that ...
0
votes
1answer
138 views

ORA-39244:Event to disable dropping null bit image header during relational select

I was trying to import a dump file using IMPDP command and has end up with the following errors: ORA-31626: job does not exist ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user user1 ...
0
votes
0answers
48 views

Slow running Oracle query caused by unnecessary full table scan

I'm by no means an expert with Oracle, but I know enough in terms of how to analyze explain plans and perform basic optimizations. However, this time, Oracle has stumped me with it's explain plan. ...
0
votes
1answer
49 views

Stack trace of oracle sql execution

Is there a way to get the stack trace of the SQL query that is given in awr, I mean a way to check the flow of the query from which package or procedure that it has been triggered? tkprof and awr both ...
2
votes
1answer
1k views

Insert into table from a query to a linked database hangs

I have a schema with some database links to other schemas that we use to pull data from. We pull the data into a staging table, massage it, and then do some merges into our schema/database. The data ...
0
votes
0answers
43 views

Script to automatically Identify tablespaces above threshold and bring it back to below threshold value

I am facing all the tablespaces crossing threshold problem in all most all the databases we have in our environment. Because of this much manual effort is been needed. I am able to identify the ...
1
vote
2answers
12k views

Oracle 12c Installation in Windows 7 error INS-30131

I am trying to install Oracle 12c in a Windows 7 x64 computer and after a while I get this error: SEVERE: [FATAL] [INS-30131] Initial setup required for the execution of installer validations failed. ...
0
votes
1answer
1k views

ora-12705 cannot access NLS data files or invalid environment specified

I have i'm installing oracle in machine 12c, while installing everything goes smoothly but when it reach to database creation it passes two step. cleaning up failed stat copying database file ...
0
votes
1answer
771 views

Oracle Duplicate Database with no archived logs

I am trying to perform a duplicate operation from one server to another (testing disaster recovery) on oracle 11g. I am very much still learning about Oracle. The system is not in production, it is ...
3
votes
1answer
433 views

ASM diskgroup drop from another ASM instance

I have created long time back one ASM RAC setup and I created one diskgroup with some name say xyz. I think that instance is gone but the diskgroup was not dropped exclusively using command: drop ...
3
votes
2answers
1k views

Loading XML documents to Oracle 11g DB with control file

I am using Oracle 11g XML database and trying to load XML documents to this DB with a control file and the sqlldr utility. All these XML files have an element that contains a date string with time ...
1
vote
2answers
7k views

exporting oracle tables on command line as sql files

I use exp and expdp to export database tables on command line but it generates binary .dmp files. I want to export/import tables as .sql* files on command line like pl/sql developer app can do. Is ...
0
votes
1answer
811 views

Oracle Enterprise Manager Installation

First I install oracle 11g database with this configuration Step 2 of 9 I selected Create and configure a database Step 3 of 9 I selected Desktop Class Step 4 of 8 Global database name: Blitz ...
3
votes
1answer
122 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 | +--------+---------+-----+ ...
1
vote
1answer
175 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
35 views

In USER_INDEXES but not in USER_IND_COLUMNS

I can't believe I don't know this but what type of index (Oracle) would have an entry in the USER_INDEXES view and not in the USER_IND_COLUMNS view? I see two system entries in USER_INDEXES. Here is ...
0
votes
1answer
283 views

Oracle 11g r2: Cannot create partition on timestamp field

I have data with a timestamp field of the form '2014-01-01 00:00:00.99' in one of the columns. I want to create a new partition for the table every month. For this I did something like this. CREATE ...
0
votes
1answer
42 views

SQL select with unique_list - losing an item

I have an oracle database and I have the following problem: If I make an select like this: SELECT fk_proddes_id,fk_id_cod_deseu, LISTAGG (TO_CHAR (cod_eliminare), ',') WITHIN ...
2
votes
2answers
809 views

How to disable flashback query logging for a specific table (Oracle)?

We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it ...
1
vote
2answers
56 views

Compressing partition - what about index?

To save space on disk I want to compress some partitions of my tables: alter table TEST_TAB move partition TEST_TAB_2014 compress for all operations; I have also indexes on this partition. Should I ...
2
votes
4answers
7k views

Oracle 12c create user

I have some problem with creating user in Enterprise Oracle Database System. A could'n create user using command like create user name identified by password; because of exception: ORA-65096: ...
0
votes
1answer
2k views

Unable to install 64-bit Oracle 10g Release 2 ODAC 10.2.0.3 for Windows x64 on 64 bit Windows Server 2008 R2

I need to connect an application to Oracle. In the installation guide for that application it says that it requires 64 bit version of Oracle Data Access Component,more specifically 10.2.0.3 . I have ...
3
votes
1answer
37 views

Migration From Oracle to PostgreSQL Encoding Errors

I'm working on migrating data from an oracle database to a postgresql database. I running into a problem where I export the data from oracle, using sql developer, and importing it into postgresql. ...
-1
votes
1answer
31 views

Return Distinct Set of Values Based on MAX Date

I'm new to SQL and I am really struggling to put a specific query together. Let me start my question by explaining what fields & tables I am dealing with. Table A Table B The unique key is ...
0
votes
1answer
1k views

Copying a table in SQL Server database to Oracle database

I am new to database management. I need to copy a particular table "Attendance" in SQL Server database to Oracle database. There is no connection between the two databases. Also, "Attendance" is ...
2
votes
2answers
22k views

Oracle password has expired, however I have no way of changing it

When I connect to my local development database, I get an error saying the password has expired. I've been trying to change it with sqlplus to no avail: C:\>sqlplus ...
0
votes
2answers
205 views

Make Oracle backup files available for duplicate

I have a Red Hat Enterprise Linux server with Oracle 10.2.0.5 and a database on it (SID is TNATEST). I have a remote CentOS server with Oracle 10.2.0.5 on it that I want to duplicate TNATEST to. The ...