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

2
votes
1answer
118 views

Foreign Key Constraint over two tables

I am trying to put the following entity-model into practice: We have a list of Payments, each Payment belongs to a certain store and is of a certain payment type (e.g. 10€ maintenance cost in ...
0
votes
0answers
33 views

How to call Oracle Function from POSTGRESQL

I am sorry if this topic already exists. I have: PostgreSQL 9.3 , Oracle 11gR2 on Linux . I used oracle_fdw to query Oracle table from Postgres but oracle_fdw can not call function. Questions: How ...
1
vote
0answers
14 views

Cannot update parent rows with trigger on the same table

I currently have the following two tables in my database CREATE TABLE folders ( id NUMBER NOT NULL, name VARCHAR2(100) NOT NULL, bytes NUMBER DEFAULT 0 NOT NULL, parentId NUMBER, CONSTRAINT ...
2
votes
1answer
371 views

Help with Oracle Pipelined function

I have a pivot where I have a contract with tank numbers separated by ; and I've been given this example to pivot them down into rows (which works): SELECT oks_c.contract_number, ...
1
vote
2answers
54 views

Oracle regexp_like square brackets inside character set

This questions is in regards to Oracle, pl/sql, and the regexp_like function. I am trying to build a character set that will match on all typical special characters. My character set currently looks ...
1
vote
3answers
60 views

Getting results without using IN

Oracle has a limit on the arguments in the IN statement of 1000, I believe, is there a way around this? If I had a statement similar to this (with 1000 ids or more): SELECT COUNT(*) FROM "VERSION" ...
0
votes
2answers
383 views

my oracle db won't open please help

This is what happens when I try to query as DBA: SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 10 22:28:00 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys ...
0
votes
2answers
55 views

Is it possible to record all the SQL executed by a session?

There is a web application which is connected to my Oracle database server via JDBC. When a user does some actions on that web application, I want to know what SQL statements were submitted to ...
2
votes
1answer
690 views

Finding why an Oracle listener got automatically restarted

I got the following message in the <listnername>.log file. I want to find out the reason why it got automatically shutdown and restarted again with different PID. 03-MAR-2013 03:00:57 * ...
0
votes
2answers
55 views

Unique constraint error Oracle

I have two databases - one is 11g and another 12c. 12c db has the exact data of 11g (expdp/impdp). Now I'm facing an error in one of the tables with unique constraint error. I have checked the ...
0
votes
1answer
37 views

What is the advantage of pluggable database over normal databases?

Why creating pluggable database over normal database is good for system performance.
1
vote
2answers
45 views

Oracle: Can a user log in without a password?

I'm writing a sqplus-like program. I assume the connect string contains the password if it contains a slash, e.g. scott/tiger or scott/tiger@orcl. if connect string does not contain "/": prompt ...
1
vote
1answer
2k views

startup mount issues with Oracle

I am a newbie with Oracle so bear with me. I am trying to simply shutdown and restart an Oracle db instance on a Windows Server 2008 machine (Oracle 11.2.0). Logged in via sqlplus, I issue the ...
0
votes
2answers
48 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 ...
0
votes
1answer
1k views

Oracle Duplicate Database with no archived logs

I am trying to perform a duplicate operation from one server to another (testing disaster recovery) on oracle 11g. I am very much still learning about Oracle. The system is not in production, it is ...
0
votes
0answers
18 views

.dmp file generating problem on oracle

I have a server windows2003 with oracle 10g and developer 6i. My experience is when I install developer 6i first and then install database 10g then .dmp file generate perfectly using imp or exp. but ...
0
votes
1answer
127 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
1answer
2k views

How to create Oracle RAC database using dbca silent mode with different db_name and db_unique_name

I have a requirement to use dbca (version 11.2.0.3) silent mode to create a RAC database on a 2-node RAC and the db_name and db_unique_name must be different, I tried following dbca command ...
2
votes
1answer
124 views

Can I exchange partition between two table with partition with same name?

I am trying to restore one partition from a backup table. Both tables have partitions with the same name. My goal is to grab the data from the backup table partition x and put it in original table ...
2
votes
1answer
30 views

What does Oracle use for handling a client connection (process or thread)?

SQL Server 2016 and MySQL 5.7 use thread-based connection handling. PostgreSQL 9.5 uses one operating system process for each individual connection. According to Oracle 12c documentation it's not ...
0
votes
2answers
248 views

Make Oracle backup files available for duplicate

I have a Red Hat Enterprise Linux server with Oracle 10.2.0.5 and a database on it (SID is TNATEST). I have a remote CentOS server with Oracle 10.2.0.5 on it that I want to duplicate TNATEST to. The ...
3
votes
0answers
598 views

SQL Developer Data Modeller and Data Dictionary question

I'm not a DBA but I am a (mostly!) competent SQL report writer. Can I trouble you DBAs for some pro-knowledge, please? I can connect SQL Developer to Oracle XE's data dictionary without any problem, ...
0
votes
1answer
204 views

Connect by prior - multiple fields and query efficiency

I have 2 tables one of which defines the hierarchy for the other equipment id desc 1 item1 2 item2 3 item3 4 item4 5 item5 6 item6 7 item7 8 item8 ...
0
votes
1answer
46 views

Synchronise Oracle Tables to SQL Server

Our ERP is using an Oracle database while our BI system is based on SQL Server. We need to get the changed data in Oracle and copy it in our staging area. At the moment we get the changed rows by ...
3
votes
1answer
1k views

How to separate out individual sql statements from Oracle SQL script for execution from java code

I have Oracle DB 11g Enterprise Edition and I want to execute sql script from my java code. I am reading this sql script from a .sql file and the script contains statements such as create table, ...
6
votes
3answers
76k views

How to make sqlplus output appear in one line?

I have a table with 100 columns. When selecting data in SQL Plus the output wraps, making it difficult to read. What I'd rather like is either a horizontal scroll bar to appear or somehow send the ...
3
votes
2answers
507 views

Security for Oracle linked server from SQL Server

I'm trying to make the linked server from SQL Server 2005 to Oracle more secure by not having user/pass on "Be made using this security context:" fields so only a specific user can access the data ...
20
votes
11answers
57k views

Eliminate duplicates in ListAgg (Oracle)

Prior to Oracle 11.2 I was using a custom aggregate function to concatenate a column into a row. 11.2 Added the LISTAGG function, so I am trying to use that instead. My problem is that I need to ...
1
vote
2answers
68 views

ORACLE_HOME / ORACLE_SID variable - why do we need to export them ?

I am not sure if this is a bash / shell question or oracle question. I am on linux and oracle 11g. I have always export my ORACLE_HOME and ORACLE_SID variable and e.g. using invoking sqlplus is no ...
0
votes
1answer
159 views

Is there are a way to restore System schema to it's original state?

I've installed Oracle 11g Database Enterprise Edition and my task was to import schemas. I'm totally new so I ran command: imp system/password file=path.dmp full=y And import everything (10 dumps, ...
0
votes
1answer
15 views

Long full scan hasn't returned but session is gone from V$SESSION

I have a query on a big table purposefully hinted with /*+ FULL() */ and uses partition pruning, and for a while the scans for each partition can be seen in V$SESSION_LONGOPS. After a while no more ...
8
votes
2answers
15k views

How do I find an object that doesn't seem to exist in the objects table?

I have an object called cot_ntn_pi_v. I was told this was a synonym. It doesn't appear in the all_synonyms table. It looks like a view or table but I can't find it in the all objects table. I can ...
0
votes
1answer
585 views

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when ...
3
votes
2answers
3k views
3
votes
3answers
51 views

Oracle data dictionary, tell built-in roles apart from custom roles

In Oracle, if you describe the DBA_ROLES view, you only get three columns: SQL> describe dba_roles; Name Null Type ------------------------------------------------ ROLE ...
2
votes
1answer
132 views

How to create a function(table_name) that return a collection in Oracle?

I need to create a function in Oracle that accepts a table name and return a collection the content of which is based the table that accepted. I've been doing some search, many examples are of the ...
0
votes
0answers
33 views

Is there a command like Linux `tail`, but for Oracle?

Is there a command like Linux tail, but for Oracle? For example just to leave open in a terminal, to view all SQL queries as they happen without having to refresh.
0
votes
2answers
52 views

Getting the last data update time of a specific table in Oracle

How can I get the last update time of table, i.e. at what time the last operation (insert/update/delete) was performed on a table in oracle? I have tried using: SELECT ...
11
votes
2answers
61k views

Oracle: Quick way to list all database links

The title says it all, is there a way to quickly list all the current database links in oracle? Something along the same lines as this, which lists the current user's tables: select * from ...
2
votes
2answers
996 views

How to disable flashback query logging for a specific table (Oracle)?

We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it ...
1
vote
2answers
2k 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 ...
0
votes
1answer
17k views

How to move csv file into oracle database using sql developer? [closed]

How to move csv file into oracle database without creating table firstly using sql developer rather than sql loader?
-2
votes
1answer
153 views

LOAD DATA statement not working in Oracle SQL Developer

When I run the statement: LOAD DATA LOCAL INFILE 'C:/path/date.txt' INTO TABLE dimdate FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (date_id, yyyymmdd, fulldate, weekofyear, month, quarter, ...
3
votes
0answers
32 views

View of structurally same tables [closed]

Let's say I have two schemas (HR and Finance for example), in each schema I have a table with information about document types this department works with. Tables have the same structure: HR.doc_type ...
1
vote
0answers
43 views

Metrics for performance of Oracle

I am trying to measure various metrics for a stored procedure - that we are tinkering with and using under different loading (i.e. size of tables). So I have drawn up this list of metrics to plot ...
0
votes
1answer
718 views

How to restore 11gR2 fullbackup to 12c database in rman

I need to transfer my database from Oracle 11gR2 to 12c database. It will be in same computer. I took full backup of Oracle 11gR2 database. Then I remove Oracle 11gR2. I installed Oracle 12c and I ...
0
votes
2answers
216 views

Revised Question: How do I prevent Oracle 12c Database from starting on machine boot

I'd posted previously about srvctl, didn't realize it was only used if a Grid Infrastructure was installed, which in my case, is not. Anyways, I have Oracle 12c Database installed on my Windows 8.1 ...
2
votes
3answers
120 views

Selecting records where date range is current year minus #years

I want to select and eventually delete records from a point in time earlier than current year minus "x" years. I'm unsure of the most efficient way to do this.
0
votes
1answer
38 views

Location of RMAN backup

I have two servers. One is DB server another is RMAN Catalog DB server. From my RMAN Catalog, I connect to my remote DB server and I run the backup. Where will the backup files be stored? Will it be ...
1
vote
2answers
77 views

How to set Persian calendar,currency,numbers,date and time and text in oracle database?

I have installed oracle database 12c on my laptop. I want to be able to store text,numbers,calendar,currency,... in my local language (Persian) in database tables and also show contents in Persian ...