Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.

learn more… | top users | synonyms

0
votes
1answer
27 views

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

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
51 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 ...
0
votes
0answers
20 views

Is it Possible to Partition a table with varchar2 Values?

In one of my tables I have values like M, F & O. In which M stands for male, F for female & O for other. I have 2 million records in this table. Based on Gender I want to split this table. Is ...
0
votes
0answers
32 views

Error PROT-23, ocr manual backup

Everyday I have a manual backup of ocr in a rac instance 11.2 and It works fine, but this night the backup failed with PROT-23 error. Now I try to execute it and allways fails. I execute with root ...
0
votes
1answer
19 views

Creating oracle Database instace

We need to create a oracle database instance similar to customer environment. What are all the parameters needs to be considered other than similar version of software. Like Character set, Multibyte ...
0
votes
0answers
29 views

Is there any way to check database log about CRUD?

I want to test DB traffic simulating CRUD for my program. For this goal, the first, I want to know what actions(select, update, insert, or something) happen when my program is running with the DB so ...
0
votes
0answers
17 views

Declare parameter created within the procedure from the outside parameter sent to procedure

I am not familiar with the PL/SQL so I need a help with this PL/SQL procedure: CREATE PROCEDURE insert( ID INTEGER, XML clob) AS DECLARE txt_XML varchar2(32767); BEGIN ...
0
votes
1answer
42 views

Oracle DB refresh on 11g using 10g Cold backup

I am a sql dba, I am having only a little knowledge on Oracle. looking for help regarding oracle db restore. I am having an Oracle 10g cold backup, i need to restore this on Oracle 11g setup, can you ...
0
votes
1answer
24 views

localhost:port_number/em (what is my port number)?

I am new to SQL databases. I have started learning SQL databases from SQLZOO, where they told me to use Oracle. I have installed Oracle Database 11g on Windows 10 with the help of this video. I have ...
1
vote
1answer
42 views

What does remote database have to do for DB link in Oracle

In local database, it has to create DB LINK through CREATE DATABASE LINK. What about remote database side, what does it have to do? On fixed user link, local database need to know ID and password ...
1
vote
1answer
19 views

Data Replication in Oracle

I have a table on master site which only allow insert operation. I want to replicate the rows which are inserted recently so, need something which can track the last record replicated into the local ...
1
vote
1answer
17 views

What PUBLIC access means on tables in Oracle?

I recieved a communication from my DBA that they want to revoke PUBLIC access and they shared attached screenshot. What does this mean by PUBLIC access on these tables? And what happen if they "Revoke"...
2
votes
1answer
18 views

Combine intersecting ranges to produce new ranges based on the points of intersection

I have a table with data like this: ID valid_from valid_to item_a Item_b Item_c 1 20.5.2016 15:28:02 21.5.2016 7:12:49 1 2 - 1 21.5.2016 7:12:50 ...
1
vote
1answer
82 views

Select query with views crashes with ORA-03113: end-of-file on communication channel

I've installed an application developed on 11g XE in a 11g Enterprise Edition server (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production) and main SELECT query triggers this: ...
0
votes
3answers
102 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? ...
1
vote
3answers
69 views

Which one is created first? Database or Instance?

Forgive me I just learned Oracle. There exist so many terminologies in the Oracle world. Regarding the concept of database and instance. I already know some differences between them. The Oracle ...
1
vote
2answers
44 views

Block size is for Database or Tablespace?

Forgive me I am just a newbie in the Oracle. I saw there is a db_block_size parameter which can be specified the block size for a database so that the whole database will be read and written data with ...
0
votes
1answer
46 views

Unable to view partition table in a schema

I am using oracle 11g enterprise edition, I have created a schema as "TESTSCHEMA" and in it i have created a partition table as "sales_test". The query for the table, create table sales_test (...
0
votes
0answers
21 views

ORA-29327: unsupported client compatibility mode used when talking to the server

I have application created in Spring, using Hibernate. The problem is that the application has this error during working with database: ORA-29327: unsupported client compatibility mode used when ...
0
votes
0answers
43 views

ORA-03214: File Size Specified is smaller than the minimum required

I am trying to resolve another error ORA-01654: unable to extend index I2B2METADATA.META_FULLNAME_I2B2_IDX by 128 in tablespace SYSTEM by writing the following query : ALTER TABLESPACE SYSTEM ADD ...
0
votes
1answer
47 views

Oracle return the first row, not returning the first row

I have this query : select (quarter_1 + quarter_2 + quarter_3 + quarter_4) as total from budget where as_of_dt < to_date('2016-06-28', 'yyyy-MM-dd') order by as_of_dt desc; Which returns bunch ...
1
vote
0answers
56 views

Getting Error/Exception In GoldenGate Replication

I am planning to configure a simple GoldenGate configuration and want to implement an exception table that will store all the exceptions. I followed two links, neither of which work for me: ...
1
vote
0answers
89 views

Unique constraint violated even though the table is empty

The item_type table is empty, yet on this: INSERT INTO item_type (id, name) VALUES (1, 'PHYSICAL') I get error: Error: ORA-00001: unique constraint (MYDB.SYS_C0013475) violated SQLState: ...
1
vote
0answers
65 views

Can't run procedure on Oracle SQL Developer [closed]

Since yesterday, I have not been unable to run procedure on Oracle SQL Developer. When I click on Run button, progress bar with "Launching" text appears on the right bottom corner of the SQL Developer,...
1
vote
1answer
43 views

How to select all attributes of object type

I am running select query with a function in it. That function returns an object type with 4 attributes and I'd like to select all those attributes. When I try it int this way. It returns just the ...
0
votes
0answers
40 views

Install Oracle Instant Client components from Custom option

Installing the Oracle DataBase Instant Client 12c, 4 options are displayed: Instant Client - This installation type installs only the shared libraries required by Oracle Call Interface applications ...
1
vote
0answers
26 views

EXTPROC issue during 10g to 11g database

I am currently 10g to 11g database migration and trying to configure EXTPROC. EXTPROC32 was configured as part of 10g to execute C++ library and working fine. It appears that 11g does not provided ...
1
vote
1answer
63 views

Oracle - execute DML query as different user

I would like to be able to run DML queries (INSERT,UPDATE,DELETE) by executing a procedure on a given schema. Those queries need to change data on different schemas on the same instance. So, basically,...
0
votes
1answer
61 views

Oracle equivalent of sp_rename in SQL Server

I am trying to rename a column of multiple tables in Oracle using a cursor over a table that has all the information of other table. In SQL Server I was able to do it correctly using sp_rename. I am ...
0
votes
0answers
31 views

updating entire row with values from other table [duplicate]

I have two tables, namely product and product_bkp. Due to faulty mappings, some of the rows from table product got updated wrongly. Now I want to update them using the backup table product_bkp. I ...
3
votes
2answers
62 views

Golden Gate realtime replication basic question

I have a task to replicate unidirectional real time data from source database A to target database B. I do not need all the table from A, only few tables and few columns inside those tables. Say 10 ...
1
vote
1answer
33 views

Security and Performance Implications of SQL Tuning Advisor

I work on a relatively small development team that works with an Oracle (11g) database. It's recently been requested that all the developers be given the Advisor role so that we can utilize SQL Tuning ...
2
votes
2answers
52 views

why I can't set oracle sessions value = 35?

I want to simulate the error "ORA-00018.Maximum number of sessions exceed",so I want to limit sessions = 35 and I am going to open serverl sqlplus to simulate this error,but sessions number didnt ...
0
votes
1answer
48 views

Oracle date not returning the right data

I don't know whats going on here, but here is my table (budget) with select * from budget : |budget_id|as_of_date|quarter_1|quarter_2|quarter_3|quarter_4| |1 |15-MAY-16 |400 |100 |...
0
votes
2answers
81 views

oracle rman connecting to a database in not mount state

When connected to oracle database through rman directly from the terminal, everything works fine, but when the same connection string is executed through a shell script rman connects to the database ...
0
votes
1answer
91 views

ORA-02049 Timeout: Distributed Transaction Waiting for Lock Solution needed

We are cleaning up the last year's transactions from our primary database. We use public database link to delete the records a day by day from another database. Each days records are around 30-40k, ...
0
votes
1answer
76 views

how to get multiple rows from multiple tables concatenated into a single string in a stored procedure in Oracle

I have a table A that has 7 different 1-N relationships. Given an A id, now I am running 7 simple queries to get the N side rows. I suspect this could be sped up. Is it possible to: create a stored ...
0
votes
0answers
18 views

Error with displaying ranges of dates when using pivot table

can i know is there any problem with this codes as when i use datagridview and then te pivot table it sometimes the dates runs whereby sometikmes the dates does not follow in sequence. I not sure ...
4
votes
1answer
210 views

Select multiple columns from subquery - Connect by

I have a table which manages folder structure. Hence it has a parent-child relationship. We trigger a query to sum all documents in the complete heirarchy: SELECT folder_name name, ...
0
votes
1answer
37 views

Get dates between two months

Can I know why am I getting weird output in my SQL statement whereby my table has two dates of the month May but it only appears for one month, the same things I test for dates range it is working. ...
0
votes
0answers
25 views

network Adapter could not establish the connection in netbeans with oracle11g in linux

I am using fedora 23 64 bit. My system is up to date. I have installed oracle 11g xe. I have downloaded the jdbc driver 'ojdbc6" , now i am trying to connect netbeans with the oracle database but it ...
1
vote
1answer
22 views

Display dates not in ascending for To_Char

can i know why and how i can solve the problem whereby if i use To_Char it does not sort the date in ascending. Below is my code select distinct To_Char (attendance_Date, 'dd/mm/yyyy') from ...
2
votes
2answers
47 views

Select rows where smaller row does not exist

Consider the following table data: ID NAME 1 Kshitiz 2 Aman 5 Aakash 6 Manjeet Here there are records missing between 2 and 5. What query can I use to select row 5 in this table?
0
votes
1answer
13 views

(SQL) User tables are separated into two sections

Using SQL Plus, I create 13 tables via an .sql file, each containing primary and foreign keys. When I execute "select table_name from user_tables;" they are displayed in this partitioned fashion. The ...
0
votes
1answer
53 views

Very fast individual queries but when joined super slow

I've got query 1: select department_id from USER_ACCESS where USER_ACCESS.USER_ID = 13170 AND USER_ACCESS.MANAGEMENT = 1 Takes about 0.475 seconds, which is not a lot for the data set I m ...
0
votes
2answers
49 views

Name already been used by an existing constraint after renaming the table and creating a new one

I would like to know why, if I alter a table name to different name and then create a table with the same name, I am getting the error "name already been used by existing constraint". This is the ...
0
votes
1answer
26 views

Is it possible to perform skip N rows and fetch M rows without full scan

Let's say I've got this query: SELECT EMP_ID,LAST_NAME FROM EMPLOYEES WHERE POSITIONID IN (1,3) ORDER BY POSITIONID,LAST_NAME; Now if I want to show only the first ten rows between 50 and 60, ...
0
votes
0answers
22 views

Copying values from one table to another table which the column intended to be copied delared as default

Can i know, the below column late_allowed when creating attendance table i declared as default and with a numbers (such as 3). The problem is that i am not sure how to put and where can i put default ...
1
vote
2answers
80 views

Why does Oracle change my date fields?

I have an Oracle 11g XE set up in Moscow, Russia, and therefore on MSK time zone. When a client in the same timezone stores a DATE variable from Java with, say time set to 12:00, the time is changed ...
0
votes
1answer
52 views

ORA-24033 : No recipient for message has been detected

I am using Oracle E-business Suite R12.1, 11G database version. Error I encountered when trying to create or modify a user or responsibility: ORA-24033 : no recipient for message has been ...