Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

0
votes
1answer
9 views

Oracle Data Pump imported table, some columns not selectable

Imported a table into Oracle 12g using data pump. Some of the columns, though present in the table as shown by describe, cannot be selected but they show up in select *. Cannot select them ...
1
vote
1answer
20 views

Overlap of group of scripts

I have a group of scripts set to run in a certain order, but sometimes I find the group running long and overlapping into the next group run. Is there a way to prevent that? group.sh: script1.sh &...
1
vote
0answers
16 views

view current session roles for another session

In Oracle, I can view the currently set roles for my current session using the query SELECT * FROM SESSION_ROLES. Is there any way that I can see this information for another session?
0
votes
1answer
29 views

How do I measure performance of a single sql execution in oracle

I need to measure the duration of individual sql executions in Oracle DB. I have the following query but it has two major problems. SELECT instance_name, host_name, sql_id, sql_fulltext, ...
0
votes
0answers
14 views

When establishing access to data on a remote database, are views or synonyms preferred?

Consider a scenario where you have two databases: On database A you need to access data on database B. You could create a view on database A that selects from the table on database B. CREATE OR ...
0
votes
1answer
23 views

how to use substring with a delimiter

Employee_M City Emp_Num_ID Cleveland 2164445437/FTTD/JAMES, TYLER/139561151 Tokyo 1261120379/FTTD/BOYD, ADAMS/14468140 Marakech 4049838896/FTTD/SMITH, TULY E/13956144 Houston ...
0
votes
0answers
9 views

is it possible to enable supplemental logging only on the phisycal standby database of an Oracle dataguard setup?

We have an Oracle Dataguard setup with a Primary and a Phisycal stand by database that we need to use CDC in it. A requirement for CDC is having supplemental logging enabled, my question is if we ...
1
vote
1answer
31 views

executing a stored procedure on a monthly schedule

I'm looking to create an invoicing procedure that executes automatically once a month. The procedure name is INVOICE_PROC. I have tried to use a trigger to execute it but I can't get it to work. ...
0
votes
1answer
28 views

How to force SQL developer to use imp/exp command while import/export

While importing or exporting oracle data dump using SQL Developer by default it is using impdp command for import and expdp command for export. But I want to import a dump which is exported using exp ...
0
votes
1answer
54 views

Not all variables bound ORA-01008: not all variables bound error

I am using Oracle SQL developer. I am running a query on employees table which is by default, having columns like first_name, last_name, employee_id, email, phone_no, hire_date, job_id, salary, ...
3
votes
1answer
37 views

Using MVIEWS to take in time data snapshot of tables

I have a requirement where I have to Load data periodically from more than 100 tables of an OLTP oracle database into MS SQL database. In my solution I want to use MVIEWs of these tables with Fast ...
0
votes
1answer
20 views

How to rearrange columns in Oracle SQL Developer script output

maybe this is an already answered question, but I am relatively new to Oracle DB and couldn't find my answer around the Internet. So I have created a table in Oracle and when running the SELECT ...
0
votes
1answer
25 views

How to solve - ORA-00205

I'm trying to create a multitenant database, but I get ORA-00205 I made a directory for datafiles: [oracle@localhost oradata]$ mkdir -p TESTCDB/data/TESTCDB I made an initTESTCDB.ora file: db_name=...
0
votes
0answers
20 views

Appling Oracle Access Advisor recommendations [closed]

On an Oracle 12c production database I created a STS for 1h when workload is high. The Oracle SQL Access Advisor created more than 300 recommendations for Materialized Views and Indexes. Can I create ...
1
vote
0answers
29 views

Is there a way to open an encrypted Oracle Database wallet through weblogic JDBC drivers?

I encrypted a column in an Oracle 12c database using the TDE method, The said column was being used in my application, The column becomes unavailable due to the Database wallet being closed. To open ...
2
votes
1answer
149 views

Building a conditional check constraint

I'm trying to build a conditional check constraint for my table TBL_AFIL, which has two fields: Fec_Renun DATE flg_afil INTEGER Constraint: IF flg_afil=1 THEN Fec_Renun can not be NULL. ALTER TABLE ...
0
votes
0answers
27 views

How to implement SQL Query into Procedure Oracle Forms [closed]

I created query to check validation on table then insert into table. I want apply this query into Procedure Program unit Oracle Forms. I am a beginner and don't know how to implement this query into ...
0
votes
1answer
28 views

Where Clause - Two columns of Primary table mapped to single column in Sec. table

I am facing a tricky scenario. We have two tables Table A Name Company -------------------------- Honda Accord Honda Pilot Chevy Impala Chevy ...
-3
votes
0answers
35 views

parallel hint problem [closed]

I have a query in production. I put a hint PARALLEL(8). This query runs for different locations. However, for all location except one location, it runs properly. The one location, where the query ...
1
vote
1answer
27 views

Oracle: procedures+functions code base not overlapping package body code base

I intend to find all code in my database containing some string. I run a query such as: SELECT DISTINCT name, type FROM all_source WHERE UPPER(text) LIKE UPPER(‘%string%’); and a lot of results, let'...
0
votes
1answer
48 views

How critical is it if SYSAUX is full?

I recently got an Ora-1688 alert and realized my SYSAUX is 99.7% full. Is this a critical issue that has to be dealt with immediately? Will this cause my system to stop?
1
vote
1answer
54 views

Why doesn't Oracle expdp create the dump file?

I'm trying to export a schema from an Oracle 10.2.0.5.0 database. For some reason, when I launch the expdp command, it finishes almost immediately and it only creates the log file, no dump file at all....
0
votes
0answers
46 views

Combine 2 rows of query results into one, with all columns filled (the two rows have opposite columns filled)

(Oracle SQL) I have been trying to figure out this problem on and off for a couple of days now, and it is driving me nuts. I don't have much experience with joins, or SQL in general, but I have ...
0
votes
0answers
20 views

mysql run out of memory during mview refresh

I want to create mview from mysql to Oracle using DBLink via odbc driver with Linux 64 bit os. but due to large number of Records around 2.5 cr records it raise the error ERROR at line 1: ORA-28500: ...
0
votes
0answers
30 views

CPU usage high after os oracle password change

Oracle 11.2.0.4 Exadata (we're relatively new to exadata still) I had something strange happen this morning and the OS user oracle password expired. This meant that cronjobs wouldn't run was the ...
0
votes
0answers
18 views

Oracle trigger starting services in standby

I'm using Oracle 18.3 with pluggable database and I have an architecture like this: host 10.0.0.1 has two instances: 1 PRIMARY and 1 STANDBY SYNC host 10.0.0.2 has one instance: 1 STANDBY ASYNC I ...
1
vote
1answer
47 views

Oracle DB what is the difference between ALL, USER and DBA Objects?

As the title suggests, I am trying to understand the structure of our Oracle DBs a little more and a little confused by the ALL, DBA & USER Objects. A quick SQL select count(*) ALL_OBJS from ...
0
votes
1answer
21 views

Oracle 11g RAC - PSU

Simple question, when patching two nodes of 11g RDBMS, do I need to patch GRID as well, or only RDMBS is enough? Thank you in advance
1
vote
1answer
20 views

Oracle SQL 11gR2 => find out all dates where “impdp” was performed

Hello my team performed several database Data Pump Import "impdp" over the last two years. The workflow was always to import all "application" schemas ( The schemas that are used from our ...
0
votes
4answers
58 views

Need to choose ASM performance for production database

We have a 1.5 TB of data (nonasm) and we plan to move into ASM by choose normal redundancy. Normal Redundancy ==> Two Way Mirroring , So we need 3TB data storage for 1.5TB data including mirroring(...
0
votes
1answer
28 views

Calculate Count Distinct without grouped columns in Oracle

I am trying to extract a few records and I ran into the "not a single group" error. This error can be resolved by removing the (count(distinct dc.DUCT_FID)) as NO_OF_WAYS column expression. However, I ...
0
votes
1answer
30 views

Connection denied from Java application

I try to connect from my little Java class to Oracle11g database and connection was refused whit SQL error. From Client (SQL Developer) connection works. This is the ERROR when I try to run java ...
0
votes
0answers
24 views

SQL Server Integration System (SSIS): looking for a way to iterate a list of Oracle databases

I am developing a package in Visual Studio in order to bring some info coming from different Oracle databases in a unique SQL Server database. Each Oracle database is a clone of the other one, the ...
0
votes
0answers
14 views

How can we pass default value as null to Associative Array in Procedure?

How can we pass default value as null to Associative Array? I have tried using below DEFAULT cast (null as t_test) here t_test is associative array
0
votes
0answers
80 views

Error while configuring REST for Oracle APEX on Windows

I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide. But when I'm trying to run @apex_rest_config.sql I get this ...
0
votes
1answer
53 views

How I should design tables for transaction (payment) for banking?

My team and I are trying to design a new simple database system to manage transaction of customers who use their debit cards. These are some problems we haven't yet decided: When it comes to 'payment ...
0
votes
2answers
46 views

Fix Oracle Database chained rows

A Oracle 12c Database has a table with Chained rows: select owner c1, table_name c2, pct_free c3, pct_used c4, avg_row_len c5, ...
0
votes
2answers
20 views

Is there a oracle SQL query show me how many time I had Downtime in my Database through a year?

I want to see log for how often my oracle Database goes down ,so is there a SQL query can give me this info..
0
votes
0answers
27 views

Does “Inheritance” Make Sense with This Requirement?

I'm using Oracle 12c. Given an existing table (we call it TBL_M), and based on the criteria below, I was wondering if using inheritance makes sense to lay out the entities: Information for one group ...
1
vote
1answer
24 views

Migrating 2+ GB Oracle CLOB column to SQL Server VARCHAR(MAX)

I have a column on an Oracle db containing HTML data with embedded images that result in some records being over 2GB in size for that column. I have successfully migrated the rest of the database to ...
-1
votes
1answer
28 views

SQL Calculate a cumulative Distinct Count per day from the first day of the month

I have a table with rows Date, Segment, Area , Province and Billing_nbr. I would also want a count distinct on Billing_nbr where total_revenue > 0 based from the ddate of that row going back to the ...
0
votes
1answer
34 views

Migration to Oracle Autonomous Database

What prerequisites, if any (such as version number, database objects in use), does an existing Oracle database have to fulfil in order to be able to migrate it straight away to Oracle Autonomous ...
0
votes
1answer
34 views

What do I need to develop an integration service to extract data from an Oracle DB to a SQL Server DB using Visual Studio 2015? [closed]

I have to develop an ETL to extract some data from an Oracle DB 11g to a SQL Server 2017 DB. I am pretty new at all this technology so I would like some advices. The strongest problem so far is to ...
1
vote
2answers
63 views

How to prevent specific applications from connecting to Oracle?

Is there a way to prevent certain applications (e.g. MS Excel or Access) from connecting to Oracle database? A bit of context: My company uses an Oracle database as our live production database. We ...
0
votes
1answer
13 views

During table migration of tables from one tablespace to another, does it needs free space to do the alter table move?

During migration of tables from one tablespace to another (all datafiles in the same disk/partition/mount), does it needs free space to do the alter table move? exemple:. I have 30gb of free space on ...
0
votes
1answer
28 views

Incremental level 1 RMAN not being deleted

I am doing a level 0 (full) incremental backup on Sundays, with the following global script: printing stored global script: weekly_backup { allocate channel DISK1 device type disk format '&...
0
votes
2answers
42 views

Oracle database installation directory using SQL

I have server that has had Oracle installed by someone else. I am able to connect to it using SQL developer and do all the operations, but I want to know the location where Oracle is installed. I ...
0
votes
2answers
28 views

select all tables from dba_table except list

I'm missing something in my query. I want to select all tables from dba_tables except a list of tables. For example, show all except HR.DEPT, SCHEMA.TAB dba_tables: OWNER TABLE_NAME ------ ----...
0
votes
2answers
37 views

Moving tables to new tablespace needs temp space or any kind of addictional space? (Oracle 11g)

I've been trying to search for this info on oracle documents but they just don't talk about it. I need to move about 2TB of different tables from 3 different tablespaces to a new tablespace (...
1
vote
1answer
30 views

Can DBA create a public synonym for a table that has the same name as an existing table

Suppose a DBA created a public synonym for a table and named it hr. The user also created a table with the same name hr. If a user performs a query like the following statement: select * from hr; ...