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
0answers
22 views

SQL - Optimize table population with dynamic queries

I need to optimize the following pl/sql procedure. So, fundamentally my question is: There is a way you can do a bulk insert in a pl/sql that could be more efficient than loop through an associative ...
0
votes
2answers
45 views

Failed to connect to oracle SQL Plus [closed]

I tryed to connect to SQL Plus as the admin "System", I'm sure that the password I wrote was correct but the connection failed. I also tried to connect with Scott/tiger but it failed as well. What can ...
3
votes
0answers
44 views

Can an active session in oracle be dead?

I have a time consuming query which populates a materialized view. It has been running for 18 hours - which was not expected. SELECT STATUS FROM V$SESSION WHERE SID=194; The above query shows the ...
0
votes
1answer
56 views

What is the best query to get the latest row version based on time?

I'm wondering what can be the most efficient query to get the latest rows from the following table. CREATE TABLE AGE_DATA ( INSERTED_DAY TIMESTAMP(6), HOSTNAME VARCHAR2(255 CHAR), CONCEPT ...
0
votes
1answer
26 views

Oracle grant select on a table

I want to grant select permission on a specific table to a remote ip address I had done it before in Mysql with this: grant all privileges on mydb.* to myuser@localhost identified by 'mypasswd'; ...
0
votes
3answers
38 views

Oracle RMAN Back-up files in red hat can be read in windows?

We have performed a cold back-up of a database using Oracle RMAN. The back-up ran on a Red Hat Server and then the files were copied to a mounted external hard-drive. Can this back-up files then be ...
0
votes
0answers
16 views

Difference between @multitenant(SINGLE_TABLE) and @multitenant(VPD) in EclipseLink

Despite the fact I searched a lot in the internet and read many articles, I still be unable to get the difference between the Single_Table strategy and the VPD strategy of EclipseLink. At first I ...
0
votes
1answer
30 views

Using oracle hints

I am trying the following query to list the first 10 rows from fisgen table: SELECT /*+FIRST_ROWS(10)*/ salute, gender, fid FROM fisgen; The hint is not executed. All the rows from the table are ...
0
votes
0answers
11 views

Configuring management interface on Oracle RAC Listener

i have a SCAN configuration ready & working, but require along with it that each node be separately reachable on a management interface for administrative connections. Listener would have to be ...
2
votes
1answer
47 views

How do I retrieve the loop record in the connect by clause?

I have a employee-->Manager hierarchy and using the following query: SELECT EMP_ID, FIRST_NAME CONNECT_BY_ISCYCLE "CYCLE" FROM MYTABLE CONNECT by NOCYCLE PRIOR MANAGER_EMP_ID = EMP_ID START WITH ...
2
votes
1answer
64 views

With Clause vs View of the same name

In my database, there is a view named VAL_DATES_V which is used in many other views in the same schema. For example, the SQL code in the view SECTOR_V uses VAL_DATES_V. CREATE OR REPLACE VIEW ...
0
votes
2answers
23 views

Single select from template record oracle

Due to lack of terminology in my head, let's say I've got 1 record from users table with these attributes : Name | Surname | Height | Weight Person X 6,2 190 How do I find other ...
0
votes
1answer
44 views

Displaying output in SQLPlus [closed]

I will open my SQLPlus with CMD in windows. When I write a query it shows 157998 rows as result. I want see the all result in sqlpus window, but it is not showing all the result.
-2
votes
1answer
31 views

How to record sqlplus session activity like “/var/messages” in Unix..? [closed]

something like $ sqlplus '/as sysdba' @spool log1.txt SQL> --Is there anything like the above..?
0
votes
1answer
28 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
62 views

Right way to restart Oracle 12c Server with pluggable databases

I am new to oracle. I installed Oracle 12c on windows with a pluggable database on a test VM. Everything was working fine. After the installation I was able to connect via EM Express on port 5500, via ...
0
votes
1answer
32 views

Regarding table access

How to revoke access for particular table from an user who have 'select any table' privilege? I want to block access to system tables that have password details such as user$ etc.. DB : Oracle ...
0
votes
1answer
36 views

Connecting to Oracle Pluggable database using service name

I installed Oracle 12c on windows using all the defaults but choosing to use a pluggable database and to install the sample data. The container database and SID name is ORCL and the pluggable database ...
0
votes
0answers
36 views

Is this MERGE statement correct?

Question: Is this MERGE statement correct ? emphasis on the ON and AND .. are they rightly placed? MERGE INTO VR_ORDER_LINE USING (SELECT * FROM E14) ON ( VR_LINE.RETAIL_NUMBER = ...
0
votes
1answer
55 views

Continuous replication between Oracle Database and Microsoft Azure SQL [closed]

Background info: Our core ERP has it's data on Oracle. Our own applications are Microsoft SQL based. Almost every application reads data from this Oracle database and usually there is some sort of ...
-2
votes
1answer
44 views

Single-row subquery returns more than one row

I try to run the follwoing query but it gives me 'Single-row subquery returns more than one row' error. BEGIN FOR C2 IN (SELECT S.bom_header, S.sap_cage_cd, ...
0
votes
1answer
115 views

Oracle 11g XE 64bits installation problem on Windows 7

I had to install Oracle 11g XE on my laptop under Windows 7. So I follow this Tutorial. The installation didn't even fail once, and seem to be OK. But every time i tried to connect to it with SQLPLUS, ...
0
votes
0answers
31 views

IO contention on raid5 happens?

I found all of the Oracle data files including redo, control, system, index and everything are in just one directory. And that directory is on Raid 5 disks. In this case do I need to do something ...
0
votes
0answers
24 views

I/O contention on RAID disk [duplicate]

I found all of the Oracle data files including redo, control, system, index and everything are in just one directory. That directory is on Raid5 disks. In this case do I need to do something for ...
0
votes
0answers
47 views

Oracle 11g xe replication/cluster free license?

I am new to db clustering/replication and I want to set up a cluster/replication of a database backed by t2 nodes. I used docker and spun up a preconfigured oracle 11g xe database ...
0
votes
0answers
26 views

Oracle listener up but instance connection blocked ORA-12528 / ORA-12505! [duplicate]

Its been one week since i last try to run my final project that i worked in my last internship at some banking company. Suddenly, my webapps (java project) in eclipse cant start. In the log it says ...
0
votes
1answer
161 views

ORA-04031: unable to allocate 32 bytes of shared memory

I want to flush shared pool because of error like ORA-04031: unable to allocate 32 bytes of shared memory So I want to flush shared pool using alter system flush shared_pool; Connected as ...
2
votes
2answers
114 views

Should new roles be assigned to SYS

Should the user SYS be assigned new roles beside the roles that it has when it was created?
0
votes
1answer
36 views

Concept of Cardinalilty in Oracle

As per wikipedia: Cardinality refers to uniquess of data: In SQL (Structured Query Language), the term cardinality refers to the uniqueness of data values contained in a particular column ...
2
votes
1answer
201 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
73 views

How to achieve using TRIM command on SELECT * From TABLE

I am building DWH where in source data dump is made through SELECT * query into DB. I am taking dump from the source DB, to save time (else had to write 115 select stmt using TRIM where average number ...
1
vote
0answers
44 views

Export entire Oracle schema to ASCII and import into DB2

I'm looking for a solution to export a number of schemas from Oracle to ASCII or other flat file format. The data then has to be read by DB2 import. Does anyone know the what oracle export commands ...
0
votes
1answer
8 views

is it possible to rollback only a partition/subpartition?

Is it possible to create a savepoint and to rollback only a partition of a table? Lets assume I created a monthly partition and subpartitions with a group_id for table x. Now i run some stored ...
0
votes
0answers
64 views

How to find out the maximum number of datafiles per tablespace in Oracle?

According to this Oracle document, the maximum number of database files per tablespace is "Operating system dependent; usually 1022". I know there are queries for some of the other limits mentioned ...
0
votes
0answers
30 views

Portable Method of Deploying Oracle Express on Windows (Ideally without Installer)

I'm looking for a portable way of deploying Oracle Express alongside a C# application on a continuous integration machine running CruiseControl. Ideally I would not have to use the installer - this ...
2
votes
2answers
116 views

Is it possible to upgrade Oracle 8i to 12c?

We have an old server running Oracle 8i. Is it going to be possible to directly update it to something newer like Oracle 12c, or would that require a complete uninstall and re-install? If we had to ...
0
votes
0answers
25 views

Oracle SQL Updating Trigger Statement

Hey all so let me see if I can clearly explain what I would like this trigger to exactly do. First of all the trigger will deal with 2 tables: Delivery Table: DeliveryNum |ItemName | Quantity | ...
0
votes
1answer
30 views

Removing editioning from an Oracle user

I maintain an Oracle Enterprise 11.2.0.3 database where one user has editioning enabled. I understand that this was an irreversible choice according to the documentation. If I wish to revert that ...
2
votes
1answer
42 views

Why does Oracle indicate my table is using so little space?

I'm running Oracle 11g. I have a table with two BLOB columns. I inserted 10,000 rows into the table, and each column contained a byte array of size 10289. As you can see, there are 10,000 rows in ...
0
votes
1answer
49 views

Oracle: duplicate schema to another database

I want to copy an Oracle schema from a production database to a validation database. Both databases are Oracle 11g R1 standard edition and need less interrupting time as I can (but I can do if it ...
0
votes
0answers
68 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
2answers
56 views

Duplicate data in a table given table name

For a performance testing application we need to have lot more data in our tables than what we have now. How do I duplicate the data in a table. In the process of duplicating I also need to set new ...
0
votes
1answer
30 views

Is PDO_OCI classed as ODBC? [closed]

I did post this question at Is PDO_OCI (PHP PDO using Oracle Instant Client) classed as ODBC? anonymously, but then it wouldn't allow me to comment on it so I registered and am posting it again here. ...
0
votes
1answer
42 views

Oracle SQL Summing Values From Two Different Tables

Hey all so I am trying to add to (or subtract from) a column of different values based on a separate column in another table. Here is a example of what I am tying to do: Table 1: (Current Inventory) ...
0
votes
0answers
30 views

Oracle Linked Server only works with Sql Login

I'm having this weird error for some time. When I login to sql server and use the linked server SELECT * FROM OPENQUERY(MEGA, 'SELECT 1 FROM DUAL') I receive this error OLE DB provider ...
0
votes
0answers
11 views

Configure Oracle DB to store backups on External Storage [closed]

How can we Configure Oracle DB to store backups on External Storage ? Oracle DB is a vm machine on ESXi Host Let me know if you need more details. Please advise.
1
vote
1answer
43 views

Migrating Oracle to MySQL: MySql Workbench Not Available

I am currently trying to migrate information from a query of a remote Oracle database to a local MySQL database. I have poked around and have found it has been frequently suggested to use the ...
0
votes
1answer
53 views

How to quickly increase column size in Oracle?

In our Oracle 11 database we have a table with more that 100 million rows and we would like to increase size of one column (not used in any index). I tried to execute command alter table shipment ...
0
votes
2answers
68 views

Join multiple Tables by date

i got some problems on my approach to join a couple of tables by a date range. This are my tables: RETURNS: RETURN_DATE RETURN_AMOUNT 02.05.14 2 02.05.14 3 02.05.14 1 ...
1
vote
1answer
75 views

Restrict Oracle DB Login based on SQL Client being used

We have an application in our organization that is based on Oracle Forms 11g (on Oracle Fusion Middleware/WLS). Users have access to the application through accounts created at the database (i.e. they ...