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
3answers
656 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 ?
1
vote
2answers
5k views

Root cause for Invalid arguments in call (ORA-17068)

We are getting Invalid arguments in call when we try to establish the connection with Oracle DB occasionally ( One hour in a day). I did some research about this in Internet, still i am not getting ...
0
votes
1answer
145 views

Time out while connecting to the database. Current time out value is 30 seconds

I am installing a repository creation utility on a windows 8 x64 bit system and getting the following error: Time out while connecting to the database. Current time out value is 30 seconds When ...
-3
votes
1answer
44 views

Why different connections in database.? [closed]

I know we can use a single connection for different databases but why an option of multiple connection is provided, in other words, when is the correct situation to use multiple connections when we ...
0
votes
1answer
1k 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 ...
0
votes
1answer
34 views

PUBLIC privilege potential security threat - Oracle database

Recently, audit findings at my site found that PUBLIC being by default assigned to all the schemas that are created is a big risk since when a new user is created and even if we were to assign only ...
1
vote
1answer
332 views

Not able to update MySQL table using Oracle: Unknown column in 'where clause' {42S22,NativeErr = 1054}

I have the following tables: MySQL table: jti_member_interact CREATE TABLE `jti_member_interact` ( `INT_MEMBER_ID` int(11) NOT NULL, `INT_ID` int(11) NOT NULL AUTO_INCREMENT, `INT_SOURCE` ...
0
votes
1answer
38 views

INSERT and UPDATE in Trigger

I have created a trigger so I could insert every row in a backup table CREATE OR REPLACE TRIGGER xyz AFTER INSERT ON table_1 REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN INSERT INTO table_2 ...
0
votes
0answers
17 views

Why does Oracle text catsearch function need to follow with > 0?

Why does Oracle Text catsearch function need to follow with "> 0" ? Even I use > 10000, > 100 nothing different. Example: CATSEARCH(PRODUCTNAME, 'NOTEBOOK A4','') = 10000000000000000000000 ...
0
votes
1answer
157 views

Restoring oracle database

I come from SQL Server and I need to restore a oracle .bkp file in my database. Im using RMAN and I have the .bkp file in: F:\Oracle Back Ups\Back.bkp´ The command that I use in RMAN is: RMAN> ...
1
vote
1answer
56 views

Oracle: Query gives different answer when running from procedure

I guess my problem is somehow related with grant permissions. I have an "ADMIN" user, I grant it "dba" permissions like this: grant dba to admin Now in the "ADMIN" schema I have 2 tables: The ...
1
vote
1answer
59 views

Oracle Min - ORA-00937 not a single-group group function

I try to find companies whose fare has minimum fare of destination which more than one companies use that destination. My command; SQL> select tickets.bus_id bus, tickets.fare fare, ...
0
votes
1answer
816 views

Import big CSV on Oracle

I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to ...
8
votes
1answer
2k 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
2answers
238 views

Database link from Local Oracle 11g to Oracle Database Cloud Service 11g

We are using Oracle database from Oracle Database Cloud Service, now we are not able to connect Cloud db from Local oracle db. Somehow we created link using below commnd, CREATE DATABASE LINK link_1 ...
2
votes
0answers
419 views

Oracle 12c connection to SQL Server 2014

I have installed Oracle 12c on Centos 7 and I wanted to connect SQL Server 2014 using freeTDS. So, I installed the following: FreeTds. unixODBC. Next, I configured ODBC on the Linux server so ...
0
votes
1answer
7k 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 ...
1
vote
2answers
9k views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME ...
0
votes
1answer
546 views

Oracle trigger error: table %s.%s is mutating, trigger/function may not see it

I am having some issues while trying to use triggers over tables where I need to get the reference of custom data type from a table. I can't seem to get it to work, here are the scripts I am using ...
2
votes
1answer
2k 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 ...
1
vote
2answers
70 views

Read from SQL Server into Oracle

Is there a way for Oracle to read from SQL Server? We are basically trying to read from a SQL Server table and update the information in Oracle. We used to have a database link in Oracle that takes ...
1
vote
1answer
56 views

Oracle 11gR2 permit NOLOGGING but ensure non-corrupt backups

I'd like to stand up a database which offers a single tablespace for NOLOGGING operations (all other perm tablespaces set with FORCE_LOGGING=YES). A conventional weekend full-backup + daily ...
0
votes
1answer
783 views

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when ...
1
vote
2answers
526 views

Is there an Oracle function to check for valid Japanese characters (Non-ASCII)?

Is there an Oracle function that can recognize if a character is readable or not? I would like to search a specific column for garbled characters. I know that this can typically be done with a ...
2
votes
2answers
42 views

Is an Oracle 10g instance dependent on the windows account authentication?

I have created an Oracle 10g (10.2.0.4) instance on a Windows 2003 Server with a domain user xxx having domain administrator level privileges. Now I wish to change xxx's password. Will it impact the ...
1
vote
1answer
45 views

Troubleshooting / traceroute within Oracle Instant Client?

I am troubleshooting a freshly reimaged backup server Win2000 / Oracle 10.1.0.5.0. Here's what I did: Installed Oracle 10g by copying Basic Instant Client package and ODBC package into same ...
0
votes
1answer
40 views

Oracle RAC 11g creation

I would like to play with RAC configuration. Using virtual area (VMware or VirtualBox): RAC1 (Windows 2003 Server) RAC2 (Windows 2003 Server) Shared storage (Openfiler) DNS server (for using SCAN ...
1
vote
1answer
35 views

SQL Error: OA-12991 - Unable to Drop a Column after removing all referenced Multi-Column constraints

I am new to Oracle DB and am in need of some help. I would like to drop a specific column but i am getting a specific error. The issue specifically is: SQL Error: ORA-12991: column is reference ...
1
vote
2answers
166 views

ORA-00257: archiver error

I ran into this error earlier today and requested that the extra logs be purged from the server. It was done but it still claims that there isn't any room. Is there a way to notify the server that it ...
0
votes
1answer
278 views

Why would DBMS_METADATA.GET_DDL Fail when i have the SELECT_CATALOG_ROLE Role?

I am trying to get the DDL using METADATA_DBMS.GET_DDL for an object in a database, and I get the following error: ORA-31603: object "MY_PACKAGE" of type PACKAGE not found in schema "S1" ORA-06512: ...
7
votes
1answer
1k views

Find active values of SQLNET.ORA parameters on server

How can I find the active values of SQLNET.ORA parameters on the server? I know how to find the SQLNET.ORA file but there's no guarantee the values in that file are actively used. Parameter changes ...
0
votes
1answer
42 views

SQL: Pivot + Group by in one go

I wish to pivot INFO2 into 2 columns. INFO3 data should adjusted accordingly after the PIVOT. The challenge is I also have a date column, which I want to take the MAX of. The MAX(Date) should also ...
2
votes
1answer
79 views

Why Does Oracle kill a session at the specific time? [closed]

Oracle kills sessions remotely open at the specific time. It means if I open a session at local machine, it is ok. In my case, at every 58 minute. For example, at 13:58, 14:58, 15:58 and so on. It ...
0
votes
2answers
181 views

ORA-01410 Error

I am getting ORA-01410 and ORA-06512 for the following block of code in a trigger im firing for deletion of a record in my table. Are the calls correct ? getlong ('xxx', 'YYY', :OLD.ROWID), getlong ...
1
vote
2answers
55 views

Delete rows from a table with inner join conditions

I have a query that selects data from a table based on some inner joins: select * from table1 p inner join table2 e on e.col1='YU' and e.username=p.username inner join table3 d on p.col2=d.col3 and ...
1
vote
1answer
26 views

finding out the metadata and joins

Suppose I have a database with a large number of tables. Is there any command that I can type in PL/SQL which display only the field names of a given table? Given any table is there any command ...
1
vote
2answers
388 views

Notification email when deadlock is encountered in Oracle alert log

How to send a notification email when a deadlock is encountered in alert log on any node like the deadlocks encountered below? (an alert any time a deadlock is detected in alert log) Node 1: Mon Sep ...
0
votes
1answer
42 views

How to grant privileges to use DBMS_OUTPUT in Oracle?

SET SERVEROUTPUT ON, DBMS_OUTPUT work perfect in my user, System or DBA. But when i create new user, it's not work! How to grant privileges to use this?
1
vote
1answer
118 views

Step by step establish a connection between SQL Server 2014 and Oracle 12c

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want these servers to be able to see each other, so I can SELECT anything I want ...
0
votes
1answer
3k views

SQL Server - linked Oracle server: EXECUTE permission denied on 'xp_prop_oledb_provider'

Inside of our SQL Server, we have created a linked server to an Oracle server. We ave mapped several users to the Oracle server and specified the credentials. On the Linked Server 'Security' ...
1
vote
1answer
4k views

netca failed during installation of Oracle 12c on Windows

I have installed Oracle 12c on Windows Server 2008 and during installation it shows the following warning: [INS-20802] oracle net configuration assistant failed When I click retry it continues ...
1
vote
3answers
110 views

How to draw ER diagram for recursive relation when the number of roles is more than 3?

I know for a recursive relation where there are 2 roles, for example: Worker works for Manager and Worker and Manager both are 2 roles of Employee, we show it this way: But what if Employee had ...
0
votes
1answer
41 views

Can I install Oracle 12c and NOT use pluggable databases?

I've just installed Oracle 12c. I did not select any of the fancy new options, I just wanted an Oracle instance. I'm fairly new to Oracle but I was used to 11.2.0.4. Every command I try now fails ...
1
vote
3answers
556 views

changing a range into discrete values for a field in oracle

I have a data table that contains records like this: ZIP Ground Air 010-041 005 305 150-163 004 304 As I have it right now, it's actually an excel file but I eventually need to ...
0
votes
1answer
28 views

Oracle 11G, Move indexes from one datafile to another

I have an Oracle 11G DB installed on Windows Server 2008 SP2 64bit OS. Below is some data files usage statistics: As you can see, there are two files: index01.dbf and index02.dbf belong to the same ...
0
votes
2answers
49 views

List expiration dates of Oracle backups

Is it too much to ask Oracle to provide expiration dates with a list of backups? I am not looking for expired backups. I am looking for a list of expiration dates for each backup.
0
votes
1answer
150 views

Oracle Text: query scoring with CTXCAT index?

If a text column is indexed with a CTXSYS.CONTEXT index it can return a score showing how well the text matches the query. create index ix on t(text) indextype is ctxsys.context parameters (''); ...
0
votes
1answer
4k 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 - ...
6
votes
2answers
5k views

efficient way to poll database?

I have a Linux CentOS server hosting an Oracle 11.2 database, which communicates with an application server, which communicates with a client (a Flex application). I'll try to describe the pseudo-code ...
3
votes
1answer
341 views

sql error on script execution. try deleting repository before creating repository

I want to migrate my mysql databse to oracle. I have followed the migration demo from this url http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html but I got this ...