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

0
votes
2answers
21 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
40 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
27 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
22 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
26 views

duplicate target database for clone error ora-1905

ORA-19505: failed to identify file "/disk1/oradata/databases/attra/rmanbkp/c-408524552-20150311-00.ctl" RMAN-00571: =========================================================== RMAN-00569: ...
0
votes
1answer
37 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
20 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
35 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
43 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
38 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
68 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
30 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
38 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
53 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
110 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
35 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
134 views

ORA-12528 and ORA-12505 error on oracle database 11g

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
70 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
31 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
4 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
52 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
19 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
92 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
20 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
29 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
38 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
39 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
43 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
26 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
32 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
1answer
193 views

ORA-01078: failure in processing system parameters LRM-00109 error too

SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 1 16:40:07 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in ...
0
votes
0answers
23 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
36 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
0answers
29 views

split string into multiple rows with multiple columns [migrated]

I have a string with user information. I have to write a function that takes string as input and inserts into some table. Input string contains multiple rows with multiple columns like following: ...
0
votes
1answer
52 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
48 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
57 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 ...
0
votes
0answers
97 views

Why am I able to query a remote database without a dblink?

While researching a security concern, I discovered that users are able to query a remote database without the need of a dblink. However, this was only true for databases that had no value for ...
0
votes
1answer
50 views

Behavior of Oracle During Very Large Transactions

I understand that if a transaction is large enough to overflow all of the redo logs on an Oracle database, and the database is in ARCHIVELOG mode, the transaction will wait until the archive log file ...
0
votes
2answers
38 views

Oracle SQL Creating Copy of Table Using DBMS_metadata

so I am trying to create a copy of a table using dbms_metadata. I know you can get the DDL of a table by executing DBMS_METADATA.get_DDL('Table','TABLENAME') so my question now is how can I use this ...
0
votes
2answers
23 views

Check attribute table referenced foreign key

I have two tables a and b like this: a: id, type b: a_id, ... There is a limitation for which the references of a in b can only be those which have type equal to a limited set of values. Is it ...
0
votes
0answers
13 views

How to use DMBS_LDAP to select 3 attributes for selected entries

I'm attempting to use DBMS_LDAP to create a procedure in Oracle 11.2.0.2.0 that ultimately updates an employee table from active directory. The attributes I want are sAMAccountName, GivenName, and ...
0
votes
1answer
21 views

Reusing views to do aggregate queries [closed]

I have created some views which give me some values. So some thing like the following select from a table of all ids gives me some thing like id1 id2 id3 id4 view1 gives me id1 2 id1 1 id1 3 ...
0
votes
0answers
42 views

Character set for 11.2 version database in oracle for sql* loader

NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ...
0
votes
1answer
65 views

Oracle Full Client / Database Client package locations

I need to install multiple versions of the Oracle client on an app server for an automation project. The platform I'm looking for in specific is Linux, 64 bit. Oracle's network of websites are a maze ...