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

-5
votes
0answers
40 views

oracle sql developer [on hold]

i have two main tables out of many tables. i just want to get the data on the year 2004.but it only executing without any output on it.i don't know if my script was wrong because it's just been a ...
0
votes
1answer
261 views

Check Oracle Service is Started from Batch Command

Uses: Oracle9i Standard Ed; I have a schedule which performs a Dump Import and afterwards the System Reboots itself, which is happening without any problem. After the System had rebooted, I have ...
0
votes
1answer
46 views

Can I write SELECT query which returns table name after FROM keyword?

I query a table which has another table name in one column. I must get that column value for searching that table. To do that I try something like this; select cap from (select table_name from table2 ...
0
votes
2answers
30 views

How to find out to which roles tables belong?

I was wondering if there is a way to find out what roles 2 tables reside? I have 2 tables and I want to find out to which role they belong? Is there a way to find out? Thanks
1
vote
2answers
194 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
0answers
31 views

ORA-01017: invalid username/password; logon denied from sql developer but sqlplus logins

I've a strange behaviour of Sql Developer with OS Authentication, 4.1.3 32/64bit, gives ORA-01017 while sqlplus is logging in without any problem. This is the example answer sqlplus gives me: ~ ...
1
vote
1answer
28 views

What are the risks of changing oracle sys password?

I need to change some old databases SYS password because of security. I'm not DBA of these databases. I don't know if I will change SYS password what it will be happen. What are the risks of ...
0
votes
1answer
23 views

connecting to an oracle sql database from sql developer on the same computer. When the computer is a domain computer

Hi I am trying to do DBA course that requires that I use Oracle database. I am using my corporate pc to do it. I set up the loopback adapter to enable localhost communication and setup the hosts ...
0
votes
0answers
21 views

Slow startup using oracle XE 11g, can anything be done to speed it up

When installing a new Oracle XE and populating it with some initial data, I am finding the startup time exceptionally slow. It has around 2 GB of data across around 10 schemas used as a dev/testing ...
-4
votes
0answers
43 views

Retrieving the data based on id from table contains 2 million rows [closed]

I have one table/collection contains 2 million rows/document (id(20 alphanumerical digits), name, ... etc). From that table I want to retrieve data based on the id within 1 sec Which database ...
4
votes
1answer
387 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
2answers
180 views

Unable to start Oracle database

We have a oracle database, one data file(users table space) of the instance got corrupt and another data file(containing application data) was deleted due to some issue. The database is in ARCHIVELOG ...
0
votes
1answer
21 views

SSRS 2012 Report with Oracle database as datasource never finishes

I am investigating a SSRS 2012 Report which used to return data from an Oracle database. However, recently it stopped returning data. The report will sit there and run forever until something times ...
1
vote
1answer
19 views

Map ASM files to physical Linux Devices

We are having problems with log file sync waits periodically. We have a 2 node RAC cluster using ASM. I'd like to monitor the physical device(s) containing the REDO log files using iostat, but I'm ...
0
votes
0answers
13 views

Is there a way to compare very short periods of activity in Oracle?

I am having a problem with an application that requires very low latency (less than 100 ms per txn.) Every once in a while we will see spikes where transactions take 20-30 SECONDS. We looked at the ...
1
vote
1answer
37 views

I need to merge two queries with condition

I have the following query: SELECT URYRR_FORWARDS_REC_H.CB_LINE as "CB_LINE", URYRR_FORWARDS_REC_H.CB_LINE_DESCRIPTION as "DESCRIPCION", URYRR_FORWARDS_REC_H.UYU_BALANCE_FW as "MONEDA LOCAL", ...
-3
votes
1answer
44 views

Finding the mismatch column names

I have two datasets, both having same column names and just one row. I want to display the column names for which there is a mismatch of column values. Could anyone please suggest how this can be done....
0
votes
4answers
111 views

After successfully installation, Is it possible create database without DBCA?

Sorry for I am not familiar with the Oracle. Please help me grow up. :) As the title said . Could someone please tell me the steps how to create a database manually through SQL without using DBCA? ...
0
votes
2answers
10 views

Creating pluggable database using dbca

I have created a PDB using Database Configuration Assistant.Is there a way I can look at where the data files got created? I did not get the option in DBCA to specify my data file. Thanks in advance
0
votes
1answer
219 views

ORA02063 error while connecting to remote databse

I have connected to remote database using DB link. From prod databases it works fine but from test env reporting error invalid username/password. Please help.
22
votes
9answers
21k views

How do you version your Oracle database changes?

I am interested to know what methods other people are using to keep track of changes made to the database including table definition changes, new objects, packages changes, etc. Do you use flat files ...
0
votes
0answers
19 views

Oracle; Table column reducing fails with 'value too big' error although such data doesnot exist

I am importing data for a table from one server to another server (both tables are of same structure) with command like below insert into table1 select * from table1@dblink1; The table1 has a ...
0
votes
1answer
29 views

How to connect to an Oracle db using a stored procedures within a Microsoft SQL server? [closed]

I need to verify data between an Oracle db and a Microsoft SQL Server db to verify that if there differences between the two and then update the Microsoft SQL Server with any changes there may be. ...
0
votes
1answer
176 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 (''); ...
1
vote
1answer
743 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 ...
4
votes
1answer
414 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 ...
2
votes
0answers
1k views

Migrating from Oracle to MySQL using WorkBench Migration Tool

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database ...
0
votes
1answer
162 views

Where is oraenv located in solaris?

I had a problem recently with oraenv and oratab and finding out where oraenv is located was a bit challenging. Since it's a question I ask myself often, I wanted to have it here. It may help others.
1
vote
1answer
10k views

JDBC pooling Oracle driver Socket read timed out

I run Java EE application on Glassfish server v3 together with Oracle 12 DB on the same machine under Windows Server 2012 64bit. I use latest ojdbc7 driver. Connection pool config: <jdbc-...
4
votes
1answer
1k views

Standby controlfile error

I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
0
votes
1answer
194 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
3answers
2k views

Import Database from Oracle .DBF files

Recently my Oracle Installation has been crashed and I reinstalled the Oracle again. I have my old Oracle Data files (.DBF files) which have been recovered from old installation. Now, I need to ...
1
vote
0answers
26 views

What might be the cause of regular periodic slow transactions on an OLTP system?

I have a two node Oracle RAC cluster with that runs an oltp application against it. I have both a production and a duplicate test environment with the same setup. Upon running stress tests on the ...
0
votes
1answer
160 views

How to connect to Oracle database on VM1 from host with 11gClient

I have a VM running Oracle Linux 6.5, I loaded Oracle server x64bit and created a database. The database functions fine and the listener is up and running for the database. I want to connect to the ...
1
vote
1answer
501 views

OCIEnvCreate failed to create environment handle after installing oracle_fdw

I'm want use Postgresql 9.3 in CentOS 7 and add extention oracle_fdw. but when use this extenstion i get error OCIEnvCreate failed to create environment handle after installing oracle_fdw. my ...
0
votes
0answers
14 views

Issue with Linked Server query

I have a job which fetches data from an Oracle 12c database and inserts into a SQL Server 2012 database, via a linked server from the SQL side. It's a simple Select * statement and just pulls in any ...
2
votes
2answers
3k views

Repopulating Oracle tables using data from Excel/CSV file

I'm developing a Java EE application that utilizes Hibernate/JPA. Some of the data I want to use comes from another Business unit's spreadsheet that I need to periodically (re)load into 5 Oracle ...
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 ...
-1
votes
1answer
29 views

unique constraint on a column with duplicate values

How to create unique constraint on a column with duplicate values,without disturbing the existing data.i have already tried the method below, To create a normal index first and then create a unique ...
1
vote
0answers
17 views

How to Move a whole partition to another tabel on another database?

Database: Oracle 12c I want to take single partition, or a set of partitions, disconnect it from a Table, or set of tables on DB1 and move it to another table on another database. I would like to ...
0
votes
2answers
508 views

Oracle Error: the sga requires more space than was allocated for it

(Oracle SQL 12c running on Windows 10) My installation has previously been working fine. I was trying to set up one of my tables to use the In-memory option available in 12c. I was following this ...
2
votes
1answer
222 views

Oracle Ref Partitioning: Deadlock due to child table row migration

My ordering application uses Oracle 11g Database. This DB has a primary table ORDERS and multiple child tables like ORDER_DETAILS, PLAN etc. ORDERS table is LIST partitioned on STATUS column and all ...
0
votes
0answers
27 views

Dropping database in RAC

I need a drop a database which is a 2 node RAC configuration and I will also be drooping the disk groups as well completely. What is the right way to drop the database + diskgroups? Will it be ok to ...
4
votes
1answer
100 views

Can two transactions share the same SCN?

Do all transactions have a unique SCN? Can two transactions share an SCN? I'm confused by this statement in the Oracle Golden Gate manual: The CSN is cross-checked with the transaction ID (...
-1
votes
1answer
24 views

Select catalog role - Oracle

Does select_catalog_role if granted to a schema provide access only to dba tables and v$ views only and not to other schemas created for any application? The reason i'm asking this is I need to grant ...
-1
votes
1answer
26 views

how to drop oracle 12c instance on linux

I have created an Oracle 12c container db instance. I need to drop the instance. What's the most effective way to drop instance?
0
votes
0answers
26 views

Oracle SQL subquery Optimization

Hi I have table called TABLE1 that is Indexed by date DT, and Item ITEM respectively. I need to write a query that will retrieve for me a list of items, for month end for given amount of months. So ...
0
votes
1answer
1k 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 ...
0
votes
0answers
30 views

SQL Retrieval Into Excel HELP! [closed]

The picture shows the format of E1 to maybe help out visually. I'm an intern and I work for an engineering company. As a project, I want to streamline the document control [DC] process and save time. ...
0
votes
1answer
52 views

Should i expect to execute of 160billion iteration from oracle 11g?

I have a table that contains approximately 390 000 records and up to now I found 3 different algorithm(solution) for my problem. Each algorithm require cartesian product of table with itself. I am ...