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

learn more… | top users | synonyms

0
votes
1answer
26 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
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 ...
2
votes
1answer
221 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
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 ...
1
vote
1answer
369 views

How do I import data into oracle 11g r2 using a `.dmp` file and a `.par` file?

How do I import data into a new installation of oracle 11g r2 using a .dmp file and a .par file? Here is what I have done so far, on a Windows 8.1 devbox: 1.) Open command line as administrator 2.)...
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 ...
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
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
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 ...
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
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 ...
2
votes
2answers
2k views

Unable to start Oracle Database Server : Get an error as I try to start it

I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop : but as I click this icon I see this dialog box : What is it ? How do I ...
2
votes
1answer
8k views

Oracle error “too many values”, must be solved with nested SELECTs

I have hit upon a "too many values" error in Oracle, when working with some intricate nested SELECTs. A simplified description of my problem, on a toy problem describing the hierarchy in a company. ...
0
votes
1answer
268 views

Keeping messages in a backup table after dequeue is completed

I would like to transfer the enqueued messages to a backup table after they have been dequeued. Currently we are using DBMS_AQ.DEQUEUE with mode dequeue_mode := DBMS_AQ.REMOVE. So after the message ...
0
votes
1answer
180 views

ALTER SESSION from a Control File

I am using a Control File to import data from a CSV file into a table, using sqlldr to import the data, where a large number of fields are numeric values with integer and decimal part separated by ...
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 ...
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 ...
2
votes
2answers
9k views

Composite primary key from multiple tables / multiple foreign keys

I want to build a composite primary key made up of foreign keys from two different tables. I'm still pretty green to this... A great answer was given to building a composite key from multiple foreign ...
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 ...
0
votes
1answer
130 views

UTL_TCP how to monitor number of connections?

I have a leak somewhere in the number of UTL_SMTP connections being made and closed. There is an underlying limit of 16 from its reliance on UTL_TCP. I'd like to be able to monitor the connection ...
0
votes
1answer
113 views

EMStagePatches_$ORACLE_SID is using up space

We have this directory: $ORACLE_HOME/EMStagePatches_$ORACLE_SID We are running out of space and this directory is using up a lot of space. Is it safe to delete it? I think it is something to do ...
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"...
0
votes
1answer
155 views

How can sqlplus knows where ORACLE_SID point?

As I understand, SID is unique value to identify an Oracle database instance. And I can set default database instance sqlplus use by changing ORACLE_SID environment variable. But how can sqlplus ...
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 ...
0
votes
2answers
750 views

Using output value of column from function for another column in SQL*Loader

I have asked the same question on StackOveflow. Do not know, if this site is linked to that or not and thus whether that question will be seen by professionals here, so I am adding it here. Please ...
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
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 ...
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 ...
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 (...
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
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 ...
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: ...
0
votes
0answers
42 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: ...
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 ...
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 ...
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,...
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
62 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
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 ...
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 ...
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 ...
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
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, ...
2
votes
5answers
48k views

Oracle Export using EXPDP gives ORA-06512 SYS.UTL_FILE error on Windows 7

I am using Oracle 11g and want to export a table using below statement C:\>expdp SYS/sys@MYDATABASE DIRECTORY = Mydir DUMPFILE = Customer.dmp LOGFILE = Customer.log TABLES = PERSON.CUSTOMER ...